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