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
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
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™

Blitz Report™ provides multiple benefits: