VIEW: APPS.POS_RECEIPT_HEADERS_V

Source

View Text - Preformatted

SELECT RSH.RECEIPT_NUM , RSH.CREATION_DATE RECEIPT_DATE , RSH.RECEIPT_SOURCE_CODE SOURCE_TYPE , /* SOURCE CODE: INTERNAL ORDER, INVENTORY, VENDOR */ DECODE(RSH.RECEIPT_SOURCE_CODE, 'VENDOR', RSH.VENDOR_ID, RSH.ORGANIZATION_ID) SUPPLIER_ID , DECODE(RSH.RECEIPT_SOURCE_CODE, 'VENDOR', POV.VENDOR_NAME, ORG.ORGANIZATION_NAME) SUPPLIER , RSH.VENDOR_ID , POV.VENDOR_NAME VENDOR , RSH.VENDOR_SITE_ID SUPPLIER_SITE_ID , POVS.VENDOR_SITE_CODE SUPPLIER_SITE , RSH.ORGANIZATION_ID , /* SOURCE ORG */ ORG.ORGANIZATION_NAME SOURCE_ORG , RSH.SHIPMENT_NUM , RSH.SHIP_TO_LOCATION_ID , HRL.LOCATION_CODE SHIP_TO_LOCATION , RSH.BILL_OF_LADING , RSH.PACKING_SLIP , RSH.SHIPPED_DATE , RSH.FREIGHT_CARRIER_CODE , RSH.EXPECTED_RECEIPT_DATE , RSH.EMPLOYEE_ID , PRF.FULL_NAME RECEIVER , RSH.NUM_OF_CONTAINERS , RSH.WAYBILL_AIRBILL_NUM , RSH.COMMENTS , RSH.USSGL_TRANSACTION_CODE , RSH.GOVERNMENT_CONTEXT , RSH.SHIPMENT_HEADER_ID , POV.ATTRIBUTE14 SUPPLIER_URL FROM RCV_SHIPMENT_HEADERS RSH, PO_VENDORS POV, PO_VENDOR_SITES_ALL POVS, ORG_ORGANIZATION_DEFINITIONS ORG, HR_LOCATIONS_ALL HRL, PER_ALL_PEOPLE_F PRF WHERE RSH.RECEIPT_NUM IS NOT NULL AND POV.VENDOR_ID = RSH.VENDOR_ID AND POVS.VENDOR_SITE_ID (+) = RSH.VENDOR_SITE_ID AND HRL.LOCATION_ID (+) = RSH.SHIP_TO_LOCATION_ID AND PRF.PERSON_ID (+) = RSH.EMPLOYEE_ID AND TRUNC(SYSDATE) BETWEEN PRF.EFFECTIVE_START_DATE (+) AND PRF.EFFECTIVE_END_DATE (+) AND ORG.ORGANIZATION_ID (+) = RSH.ORGANIZATION_ID

View Text - HTML Formatted

SELECT RSH.RECEIPT_NUM
, RSH.CREATION_DATE RECEIPT_DATE
, RSH.RECEIPT_SOURCE_CODE SOURCE_TYPE
, /* SOURCE CODE: INTERNAL ORDER
, INVENTORY
, VENDOR */ DECODE(RSH.RECEIPT_SOURCE_CODE
, 'VENDOR'
, RSH.VENDOR_ID
, RSH.ORGANIZATION_ID) SUPPLIER_ID
, DECODE(RSH.RECEIPT_SOURCE_CODE
, 'VENDOR'
, POV.VENDOR_NAME
, ORG.ORGANIZATION_NAME) SUPPLIER
, RSH.VENDOR_ID
, POV.VENDOR_NAME VENDOR
, RSH.VENDOR_SITE_ID SUPPLIER_SITE_ID
, POVS.VENDOR_SITE_CODE SUPPLIER_SITE
, RSH.ORGANIZATION_ID
, /* SOURCE ORG */ ORG.ORGANIZATION_NAME SOURCE_ORG
, RSH.SHIPMENT_NUM
, RSH.SHIP_TO_LOCATION_ID
, HRL.LOCATION_CODE SHIP_TO_LOCATION
, RSH.BILL_OF_LADING
, RSH.PACKING_SLIP
, RSH.SHIPPED_DATE
, RSH.FREIGHT_CARRIER_CODE
, RSH.EXPECTED_RECEIPT_DATE
, RSH.EMPLOYEE_ID
, PRF.FULL_NAME RECEIVER
, RSH.NUM_OF_CONTAINERS
, RSH.WAYBILL_AIRBILL_NUM
, RSH.COMMENTS
, RSH.USSGL_TRANSACTION_CODE
, RSH.GOVERNMENT_CONTEXT
, RSH.SHIPMENT_HEADER_ID
, POV.ATTRIBUTE14 SUPPLIER_URL
FROM RCV_SHIPMENT_HEADERS RSH
, PO_VENDORS POV
, PO_VENDOR_SITES_ALL POVS
, ORG_ORGANIZATION_DEFINITIONS ORG
, HR_LOCATIONS_ALL HRL
, PER_ALL_PEOPLE_F PRF
WHERE RSH.RECEIPT_NUM IS NOT NULL
AND POV.VENDOR_ID = RSH.VENDOR_ID
AND POVS.VENDOR_SITE_ID (+) = RSH.VENDOR_SITE_ID
AND HRL.LOCATION_ID (+) = RSH.SHIP_TO_LOCATION_ID
AND PRF.PERSON_ID (+) = RSH.EMPLOYEE_ID
AND TRUNC(SYSDATE) BETWEEN PRF.EFFECTIVE_START_DATE (+)
AND PRF.EFFECTIVE_END_DATE (+)
AND ORG.ORGANIZATION_ID (+) = RSH.ORGANIZATION_ID