FND Design Data [Home] [Help]

View: POS_RECEIPT_HEADERS_V

Product: PO - Purchasing
Description:
Implementation/DBA Data: ViewAPPS.POS_RECEIPT_HEADERS_V
View Text

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 ORG.ORGANIZATION_ID (+) = RSH.ORGANIZATION_ID

Columns

Name
RECEIPT_NUM
RECEIPT_DATE
SOURCE_TYPE
SUPPLIER_ID
SUPPLIER
VENDOR_ID
VENDOR
SUPPLIER_SITE_ID
SUPPLIER_SITE
ORGANIZATION_ID
SOURCE_ORG
SHIPMENT_NUM
SHIP_TO_LOCATION_ID
SHIP_TO_LOCATION
BILL_OF_LADING
PACKING_SLIP
SHIPPED_DATE
FREIGHT_CARRIER_CODE
EXPECTED_RECEIPT_DATE
EMPLOYEE_ID
RECEIVER
NUM_OF_CONTAINERS
WAYBILL_AIRBILL_NUM
COMMENTS
USSGL_TRANSACTION_CODE
GOVERNMENT_CONTEXT
SHIPMENT_HEADER_ID
SUPPLIER_URL