GML OPM Apps Receipt Number

Description
Categories: BI Publisher, Manufacturing
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 Name SQL text Validation
To Vend No
 
LOV Oracle
From Vend No
 
LOV Oracle
To PO No
 
LOV Oracle
From PO No
 
LOV Oracle
To Recv Date
 
Date
From Recv Date
 
Date
To Recv No
 
LOV Oracle
From Recv No
 
LOV Oracle
Organization
 
LOV Oracle