View: PO_AP_RECEIPT_MATCH_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_AP_RECEIPT_MATCH_V

View Text

SELECT RT.TRANSACTION_ID
, RT.TRANSACTION_DATE
, RT.QUANTITY
, SH.SHIPMENT_HEADER_ID
, SH.RECEIPT_NUM
, SL.SHIPMENT_LINE_ID
, SL.LINE_NUM
, RT.PO_HEADER_ID
, PH.SEGMENT1
, RT.PO_LINE_ID
, PL.LINE_NUM
, RT.PO_LINE_LOCATION_ID
, PS.SHIPMENT_NUM
, NVL(PS.PRICE_OVERRIDE
, PL.UNIT_PRICE)
, RT.PO_RELEASE_ID
, PR.RELEASE_NUM
, PL.UNIT_MEAS_LOOKUP_CODE
, SL.UNIT_OF_MEASURE
, SL.ITEM_ID
, SL.ITEM_DESCRIPTION
, SL.CATEGORY_ID
, SL.VENDOR_ITEM_NUM
, SL.SHIP_TO_LOCATION_ID
, LO.LOCATION_CODE
, PH.AGENT_ID
, BU.FULL_NAME
, PH.FREIGHT_TERMS_LOOKUP_CODE
, AT.NAME
, PS.TAXABLE_FLAG
, PS.TAX_CODE_ID
, TX.NAME
, SH.BILL_OF_LADING
, SH.PACKING_SLIP
, PS.APPROVED_FLAG
, PS.APPROVED_DATE
, RT.VENDOR_ID
, VE.VENDOR_NAME
, RT.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, RT.CURRENCY_CODE
, SL.TO_ORGANIZATION_ID
, OD.ORGANIZATION_CODE
, PS.MATCH_OPTION
, LT.ORDER_TYPE_LOOKUP_CODE
, SH.WAYBILL_AIRBILL_NUM
, SH.SHIPPED_DATE
, SH.FREIGHT_CARRIER_CODE
, PS.ACCRUE_ON_RECEIPT_FLAG
, PL.TYPE_1099
, PH.ORG_ID
, PH.USSGL_TRANSACTION_CODE
, SL.CONTAINER_NUM
, PS.SHIPMENT_TYPE
, RT.ATTRIBUTE_CATEGORY
, RT.ATTRIBUTE1
, RT.ATTRIBUTE2
, RT.ATTRIBUTE3
, RT.ATTRIBUTE4
, RT.ATTRIBUTE5
, RT.ATTRIBUTE6
, RT.ATTRIBUTE7
, RT.ATTRIBUTE8
, RT.ATTRIBUTE9
, RT.ATTRIBUTE10
, RT.ATTRIBUTE11
, RT.ATTRIBUTE12
, RT.ATTRIBUTE13
, RT.ATTRIBUTE14
, RT.ATTRIBUTE15
, DECODE(PR.RELEASE_NUM
, NULL
, PH.PAY_ON_CODE
, PR.PAY_ON_CODE) PAY_ON_CODE
, PS.CANCELLED_BY
, PS.CANCEL_DATE
, PS.CANCEL_FLAG
, PS.CANCEL_REASON
, PS.CLOSED_BY
, PS.CLOSED_CODE
, PS.CLOSED_DATE
, PS.CLOSED_FLAG
, PS.CLOSED_REASON
FROM RCV_TRANSACTIONS RT
, PO_HEADERS PH
, PO_LINES PL
, PO_LINE_LOCATIONS PS
, PO_RELEASES PR
, RCV_SHIPMENT_HEADERS SH
, RCV_SHIPMENT_LINES SL
, AP_TERMS AT
, PO_VENDORS VE
, PO_VENDOR_SITES VS
, ORG_ORGANIZATION_DEFINITIONS OD
, PER_PEOPLE_F BU
, HR_LOCATIONS_ALL_TL LO
, PO_LINE_TYPES LT
, AP_TAX_CODES TX
WHERE SH.RECEIPT_SOURCE_CODE = 'VENDOR'
AND RT.PO_HEADER_ID = PH.PO_HEADER_ID
AND RT.PO_LINE_ID = PL.PO_LINE_ID
AND RT.PO_LINE_LOCATION_ID = PS.LINE_LOCATION_ID
AND RT.PO_RELEASE_ID = PR.PO_RELEASE_ID(+)
AND RT.SHIPMENT_HEADER_ID = SH.SHIPMENT_HEADER_ID
AND RT.SHIPMENT_LINE_ID = SL.SHIPMENT_LINE_ID
AND PH.TERMS_ID = AT.TERM_ID(+)
AND RT.VENDOR_ID = VE.VENDOR_ID(+)
AND RT.VENDOR_SITE_ID = VS.VENDOR_SITE_ID(+)
AND SL.TO_ORGANIZATION_ID = OD.ORGANIZATION_ID(+)
AND PH.AGENT_ID = BU.PERSON_ID(+)
AND BU.EFFECTIVE_START_DATE(+) <= TRUNC(SYSDATE)
AND BU.EFFECTIVE_END_DATE(+) >= TRUNC(SYSDATE)
AND SL.SHIP_TO_LOCATION_ID = LO.LOCATION_ID(+)
AND LO.LANGUAGE(+) = USERENV('LANG')
AND PL.LINE_TYPE_ID = LT.LINE_TYPE_ID(+)
AND PS.TAX_CODE_ID = TX.TAX_ID(+)
AND RT.TRANSACTION_TYPE IN ('RECEIVE'
, 'MATCH')

Columns