FND Design Data [Home] [Help]

View: RCV_RECEIPTS_PRINT_REQ

Product: PO - Purchasing
Description: Print view of receipts
Implementation/DBA Data: ViewAPPS.RCV_RECEIPTS_PRINT_REQ
View Text

SELECT RSL.ITEM_ID
, ''
, RSH.SHIP_TO_ORG_ID
, RSL.ITEM_REVISION
, RSL.CATEGORY_ID
, RSL.ITEM_DESCRIPTION
, PUN.UN_NUMBER
, PUN.DESCRIPTION
, PHC.HAZARD_CLASS
, RRH.ROUTING_NAME
, PDT.TYPE_NAME
, PRH.SEGMENT1
, TO_NUMBER(NULL)
, PRL.LINE_NUM
, HRE1.FULL_NAME
, PLC1.DISPLAYED_FIELD
, HRU.NAME
, PRL.UNIT_MEAS_LOOKUP_CODE
, ''
, PRL.NEED_BY_DATE
, PRL.QUANTITY
, PRL.NOTE_TO_RECEIVER
, RSH.RECEIPT_NUM
, RCT.UNIT_OF_MEASURE
, RCT.TRANSACTION_DATE
, HRL.LOCATION_CODE
, HRE.FIRST_NAME
, HRE.LAST_NAME
, RSH.FREIGHT_CARRIER_CODE
, RCT.QUANTITY
, RCT.PRIMARY_QUANTITY
, PRL.QUANTITY - (NVL(PRL.QUANTITY_CANCELLED
, 0) + NVL(PRL.QUANTITY_RECEIVED
, 0))
, RSH.SHIPMENT_NUM
, RSH.BILL_OF_LADING
, RCT.VENDOR_LOT_NUM
, NVL(RSL.PACKING_SLIP
, RSH.PACKING_SLIP)
, RSH.NUM_OF_CONTAINERS
, RSL.COMMENTS ||DECODE(RSL.COMMENTS
, NULL
, TO_CHAR(NULL)
, DECODE(RSH.COMMENTS
, NULL
, TO_CHAR(NULL)
, '
, ')) || RSH.COMMENTS
, 'REQ'
, RCT.TRANSACTION_ID
, RCT.GROUP_ID
, RCT.SHIPMENT_HEADER_ID
, RCT.SHIPMENT_LINE_ID
, PRD.DISTRIBUTION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, 'N'
, HRL1.LOCATION_CODE
, ''
, RCT.SUBINVENTORY
, RCT.LOCATOR_ID
, WLPN1.LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER
, WLPN2.LICENSE_PLATE_NUMBER TRANSFER_LICENSE_PLATE_NUMBER
FROM RCV_SHIPMENT_LINES RSL
, RCV_SHIPMENT_HEADERS RSH
, RCV_TRANSACTIONS RCT
, RCV_ROUTING_HEADERS RRH
, PO_UN_NUMBERS_TL PUN
, PO_HAZARD_CLASSES_TL PHC
, PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS PRD
, PO_DOCUMENT_TYPES PDT
, PO_LOOKUP_CODES PLC1
, PER_ALL_PEOPLE_F HRE
, PER_ALL_PEOPLE_F HRE1
, HR_LOCATIONS_ALL_TL HRL
, HR_LOCATIONS_ALL_TL HRL1
, HR_ORGANIZATION_UNITS HRU
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, WMS_LICENSE_PLATE_NUMBERS WLPN1
, WMS_LICENSE_PLATE_NUMBERS WLPN2
WHERE RCT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID
AND RCT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RCT.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID
AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND PRL.UN_NUMBER_ID = PUN.UN_NUMBER_ID (+)
AND PUN.LANGUAGE(+) = USERENV('LANG')
AND PRL.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+)
AND PHC.LANGUAGE(+) = USERENV('LANG')
AND PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
AND RSL.ROUTING_HEADER_ID = RRH.ROUTING_HEADER_ID (+)
AND RSH.ORGANIZATION_ID = HRU.ORGANIZATION_ID
AND PDT.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PDT.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND RCT.SOURCE_DOCUMENT_CODE = 'REQ'
AND RSH.RECEIPT_SOURCE_CODE = 'INTERNAL ORDER'
AND PLC1.LOOKUP_CODE = RSH.RECEIPT_SOURCE_CODE
AND PLC1.LOOKUP_TYPE = 'SHIPMENT SOURCE TYPE'
AND RCT.EMPLOYEE_ID = HRE.PERSON_ID (+)
AND PRH.PREPARER_ID = HRE1.PERSON_ID
AND RCT.LOCATION_ID = HRL.LOCATION_ID (+)
AND HRL.LANGUAGE(+) = USERENV('LANG')
AND RCT.DELIVER_TO_LOCATION_ID = HRL1.LOCATION_ID (+)
AND HRL1.LANGUAGE(+) = USERENV('LANG')
AND RCT.TRANSACTION_TYPE IN ('RECEIVE'
, 'DELIVER')
AND ((HRE.EMPLOYEE_NUMBER IS NOT NULL
AND HRE.BUSINESS_GROUP_ID = NVL(FSP.BUSINESS_GROUP_ID
, 0)
AND TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE
AND HRE.EFFECTIVE_END_DATE) OR HRE.PERSON_ID IS NULL)
AND (HRE1.EMPLOYEE_NUMBER IS NOT NULL
AND HRE1.BUSINESS_GROUP_ID = NVL(FSP.BUSINESS_GROUP_ID
, 0)
AND TRUNC(SYSDATE) BETWEEN HRE1.EFFECTIVE_START_DATE
AND HRE1.EFFECTIVE_END_DATE)
AND RCT.LPN_ID = WLPN1.LPN_ID(+)
AND RCT.TRANSFER_LPN_ID = WLPN2.LPN_ID(+) UNION SELECT RCT.ITEM_ID
, ''
, RSH.SHIP_TO_ORG_ID
, RCT.ITEM_REVISION
, RCT.CATEGORY_ID
, RCT.ITEM_DESCRIPTION
, PUN.UN_NUMBER
, PUN.DESCRIPTION
, PHC.HAZARD_CLASS
, RRH.ROUTING_NAME
, PDT.TYPE_NAME
, PRH.SEGMENT1
, TO_NUMBER(NULL)
, PRL.LINE_NUM
, HRE1.FULL_NAME
, PLC1.DISPLAYED_FIELD
, HRU.NAME
, PRL.UNIT_MEAS_LOOKUP_CODE
, ''
, PRL.NEED_BY_DATE
, PRL.QUANTITY
, PRL.NOTE_TO_RECEIVER
, RSH.RECEIPT_NUM
, RCT.UNIT_OF_MEASURE
, RCT.TRANSACTION_DATE
, HRL.LOCATION_CODE
, HRE.FIRST_NAME
, HRE.LAST_NAME
, RSH.FREIGHT_CARRIER_CODE
, RCT.QUANTITY
, RCT.PRIMARY_QUANTITY
, PRL.QUANTITY - (NVL(PRL.QUANTITY_CANCELLED
, 0) + NVL(PRL.QUANTITY_RECEIVED
, 0))
, RSH.SHIPMENT_NUM
, RSH.BILL_OF_LADING
, RCT.VENDOR_LOT_NUM
, RSH.PACKING_SLIP
, RSH.NUM_OF_CONTAINERS
, DECODE(RSH.COMMENTS
, NULL
, TO_CHAR(NULL)
, '
, ') || RSH.COMMENTS
, 'REQ'
, RCT.INTERFACE_TRANSACTION_ID
, RCT.GROUP_ID
, RCT.SHIPMENT_HEADER_ID
, RCT.SHIPMENT_LINE_ID
, PRD.DISTRIBUTION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PRH.REQUISITION_HEADER_ID
, PRL.REQUISITION_LINE_ID
, 'Y'
, HRL1.LOCATION_CODE
, ''
, RCT.SUBINVENTORY
, RCT.LOCATOR_ID
, WLPN1.LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER
, WLPN2.LICENSE_PLATE_NUMBER TRANSFER_LICENSE_PLATE_NUMBER
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_ROUTING_HEADERS RRH
, PO_UN_NUMBERS_TL PUN
, PO_HAZARD_CLASSES_TL PHC
, PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS PRD
, PO_DOCUMENT_TYPES PDT
, PO_LOOKUP_CODES PLC1
, PER_ALL_PEOPLE_F HRE
, PER_ALL_PEOPLE_F HRE1
, RCV_TRANSACTIONS_INTERFACE RCT
, HR_ORGANIZATION_UNITS HRU
, HR_LOCATIONS_ALL_TL HRL
, HR_LOCATIONS_ALL_TL HRL1
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, WMS_LICENSE_PLATE_NUMBERS WLPN1
, WMS_LICENSE_PLATE_NUMBERS WLPN2
WHERE RCT.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RCT.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID
AND PRL.UN_NUMBER_ID = PUN.UN_NUMBER_ID (+)
AND PUN.LANGUAGE(+) = USERENV('LANG')
AND PRL.HAZARD_CLASS_ID = PHC.HAZARD_CLASS_ID (+)
AND PHC.LANGUAGE(+) = USERENV('LANG')
AND PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
AND RCT.ROUTING_HEADER_ID = RRH.ROUTING_HEADER_ID (+)
AND RCT.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID
AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND PDT.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PDT.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND RCT.SOURCE_DOCUMENT_CODE = 'REQ'
AND RSH.RECEIPT_SOURCE_CODE = 'INTERNAL ORDER'
AND PLC1.LOOKUP_CODE = RSH.RECEIPT_SOURCE_CODE
AND PLC1.LOOKUP_TYPE = 'SHIPMENT SOURCE TYPE'
AND RCT.EMPLOYEE_ID = HRE.PERSON_ID (+)
AND PRH.PREPARER_ID = HRE1.PERSON_ID
AND RSH.ORGANIZATION_ID = HRU.ORGANIZATION_ID
AND RCT.LOCATION_ID = HRL.LOCATION_ID(+)
AND HRL.LANGUAGE(+) = USERENV('LANG')
AND RCT.DELIVER_TO_LOCATION_ID = HRL1.LOCATION_ID (+)
AND HRL1.LANGUAGE(+) = USERENV('LANG')
AND RCT.TRANSACTION_TYPE IN ('RECEIVE'
, 'DELIVER')
AND ((HRE.EMPLOYEE_NUMBER IS NOT NULL
AND HRE.BUSINESS_GROUP_ID = NVL(FSP.BUSINESS_GROUP_ID
, 0)
AND TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE
AND HRE.EFFECTIVE_END_DATE) OR HRE.PERSON_ID IS NULL)
AND (HRE1.EMPLOYEE_NUMBER IS NOT NULL
AND HRE1.BUSINESS_GROUP_ID = NVL(FSP.BUSINESS_GROUP_ID
, 0)
AND TRUNC(SYSDATE) BETWEEN HRE1.EFFECTIVE_START_DATE
AND HRE1.EFFECTIVE_END_DATE)
AND RCT.LPN_ID = WLPN1.LPN_ID(+)
AND RCT.TRANSFER_LPN_ID = WLPN2.LPN_ID(+)

Columns

Name
ITEM_ID
ABC_CODE
ORGANIZATION_ID
REVISION_NUM
CATEGORY_ID
ITEM_DESCRIPTION
UN_NUM
UN_DESCRIPTION
HAZARD_CLASS
ROUTING_NAME
DOCUMENT_TYPE_CODE
DOCUMENT_NUMBER
RELEASE_NUM
LINE_NUM
BUYER_PREPARER_NAME
SOURCE_TYPE
SOURCE
SOURCE_UNIT_OF_MEASURE
VENDOR_PRODUCT_NUM
DUE_DATE
QUANTITY_ORDERED
NOTE_TO_RECEIVER
RECEIPT_NUM
RECEIPT_UNIT_OF_MEASURE
RECEIPT_DATE
RECEIPT_LOCATION
RECEIVER_FIRST_NAME
RECEIVER_LAST_NAME
FREIGHT_CARRIER
QUANTITY_RECEIVED
PRIMARY_QUANTITY
QUANTITY_REMAINING
SHIPMENT_NUM
BILL_OF_LADING
VENDOR_LOT_NUM
PACKING_SLIP_NUM
CONTAINERS
RECEIVER_COMMENT
TRANSACTION_TYPE
TRANSACTION_ID
GROUP_ID
SHIPMENT_HEADER_ID
SHIPMENT_LINE_ID
DISTRIBUTION_ID
PO_HEADER_ID
PO_LINE_ID
PO_LINE_LOCATION_ID
REQUISITION_HEADER_ID
REQUISITION_LINE_ID
FROM_INTERFACE
DELIVER_TO_LOCATION
PLL_NOTE_TO_RECEIVER
RECEIVING_SUBINVENTORY
LOCATOR_ID
LICENSE_PLATE_NUMBER
TRANSFER_LICENSE_PLATE_NUMBER