GML OPM Apps Receipt Number

➜ Back to Library
Description
Categories: BI Publisher
Application: Process Manufacturing Logistics
Source: OPM Apps Receipt Number Report (XML)
Short Name: POAPPSRS_XML
DB package: GML_POAPPSRS_XMLP_PKG
SELECT
                   HDR.PAYVEND_ID,
                                    HDR.ORGN_CODE      PO_ORGN,
                                    HDR.PO_DATE,
                   RHDR.ORGN_CODE   RC_ORGN,
                   HDR.PO_NO, DTL.LINE_NO,
                   RHDR.RECV_ID,
                                    RHDR.RECV_NO,
                   MAP.RCV_RECEIPT_NUM,
                   HDR.CREATION_DATE,
                   RHDR.CREATION_DATE,
                               RHDR.RECV_DATE,
                               VEND.VENDOR_NO,VEND.VENDOR_NAME
            FROM
                 PO_ORDR_HDR HDR,
                 PO_ORDR_DTL DTL,
                 PO_RECV_HDR RHDR,
                 PO_RECV_DTL RDTL,
                 GML_RECV_TRANS_MAP MAP,
                              PO_VEND_MST VEND
            WHERE
                   RDTL.PO_ID=HDR.PO_ID
                   AND HDR.PO_ID=DTL.PO_ID
                   AND HDR.PAYVEND_ID = RHDR.PAYVEND_ID
                               AND VEND.VENDOR_ID=HDR.PAYVEND_ID
                               AND VEND.VENDOR_ID= RHDR.PAYVEND_ID
                   AND MAP.RECV_ID=RHDR.RECV_ID
                   AND RDTL.LINE_ID=MAP.LINE_ID
                   AND RDTL.RECV_ID=RHDR.RECV_ID
                   AND RDTL.POLINE_ID=DTL.LINE_ID
                                        &PARAM_WHERE_CLAUSE
            ORDER BY
                 RHDR.RECV_NO, RDTL.LINE_NO
Parameter NameSQL textValidation
Organization
 
LOV Oracle
From Recv No
 
LOV Oracle
To Recv No
 
LOV Oracle
From Recv Date
 
Date
To Recv Date
 
Date
From PO No
 
LOV Oracle
To PO No
 
LOV Oracle
From Vend No
 
LOV Oracle
To Vend No
 
LOV Oracle
Download
Related Blitz Reports
GML Items Received GML PO/Stock Return History GML Sales Order Acknowledgement GMI Lot Genealogy GML Unallocated Orders GML Sales Order Audit Trail ECC Process Manufacturing, Outside Processing Batch GML Bill Of Lading GML Ship Picklist
Blitz Report™