GML OPM Apps Receipt Number

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
Run GML OPM Apps Receipt Number and other Oracle EBS reports with Blitz Report™ on our demo environment
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
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
Blitz Report™