View: RCV_DISTRIBUTIONS_PRINT_REQ

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

View Text

SELECT RCT.ORGANIZATION_ID
, PLC.DISPLAYED_FIELD
, NVL(PPF2.FULL_NAME
, PPF1.FULL_NAME) || '
, ' || NVL(HRL1.LOCATION_CODE
, HRL.LOCATION_CODE) || '
, ' || OOD.NAME || '
, ' || NVL(RSL.TO_SUBINVENTORY
, RCT.SUBINVENTORY)
, PRH.SEGMENT1
, PRL.UNIT_MEAS_LOOKUP_CODE
, (PRL.QUANTITY - PRL.QUANTITY_CANCELLED - PRL.QUANTITY_DELIVERED )
, PRL.NOTE_TO_RECEIVER
, 'REQ'
, RCT.TRANSACTION_ID
, RCT.QUANTITY
, RCT.TRANSACTION_DATE
, PPF.FULL_NAME
, PRD.DISTRIBUTION_ID
, 'N'
, NVL(PPF2.FULL_NAME
, PPF1.FULL_NAME)
, NVL(HRL1.LOCATION_CODE
, HRL.LOCATION_CODE)
, OOD.NAME
, NVL(RSL.TO_SUBINVENTORY
, RCT.SUBINVENTORY)
, RCT.LOCATOR_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, ''
, 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
, PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS PRD
, HR_ALL_ORGANIZATION_UNITS_TL OOD
, HR_LOCATIONS_ALL_TL HRL
, HR_LOCATIONS_ALL_TL HRL1
, PER_ALL_PEOPLE_F PPF1
, PER_ALL_PEOPLE_F PPF2
, PER_ALL_PEOPLE_F PPF
, PO_LOOKUP_CODES PLC
, WMS_LICENSE_PLATE_NUMBERS WLPN1
, WMS_LICENSE_PLATE_NUMBERS WLPN2
WHERE RCT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID
AND RSL.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
AND RSL.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID
AND PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
AND PRD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID
AND RCT.SOURCE_DOCUMENT_CODE = 'REQ'
AND RSH.RECEIPT_SOURCE_CODE = 'INTERNAL ORDER'
AND OOD.ORGANIZATION_ID(+) = PRL.DESTINATION_ORGANIZATION_ID
AND OOD.LANGUAGE(+) = USERENV('LANG')
AND HRL.LOCATION_ID(+) = PRL.DELIVER_TO_LOCATION_ID
AND HRL.LANGUAGE(+) = USERENV('LANG')
AND HRL1.LOCATION_ID(+) = RSL.DELIVER_TO_LOCATION_ID
AND HRL1.LANGUAGE(+) = USERENV('LANG')
AND PPF1.PERSON_ID(+) = PRL.TO_PERSON_ID
AND ((PPF1.BUSINESS_GROUP_ID IN (SELECT NVL(FSP.BUSINESS_GROUP_ID
, 0)
FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP)
AND TRUNC(SYSDATE) BETWEEN PPF1.EFFECTIVE_START_DATE
AND PPF1.EFFECTIVE_END_DATE
AND PPF1.EMPLOYEE_NUMBER IS NOT NULL) OR (PPF1.PERSON_ID IS NULL))
AND PPF2.PERSON_ID(+) = RSL.DELIVER_TO_PERSON_ID
AND ((PPF2.BUSINESS_GROUP_ID IN (SELECT NVL(FSP.BUSINESS_GROUP_ID
, 0)
FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP)
AND TRUNC(SYSDATE) BETWEEN PPF2.EFFECTIVE_START_DATE
AND PPF2.EFFECTIVE_END_DATE
AND PPF2.EMPLOYEE_NUMBER IS NOT NULL) OR (PPF2.PERSON_ID IS NULL))
AND PPF.PERSON_ID(+) = RCT.EMPLOYEE_ID
AND ((PPF.BUSINESS_GROUP_ID IN (SELECT NVL(FSP.BUSINESS_GROUP_ID
, 0)
FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP)
AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPF.EMPLOYEE_NUMBER IS NOT NULL) OR (PPF.PERSON_ID IS NULL))
AND PLC.LOOKUP_TYPE = 'DESTINATION TYPE'
AND PLC.LOOKUP_CODE = PRL.DESTINATION_TYPE_CODE
AND RCT.LPN_ID = WLPN1.LPN_ID(+)
AND RCT.TRANSFER_LPN_ID = WLPN2.LPN_ID (+) UNION SELECT RCT.TO_ORGANIZATION_ID
, PLC.DISPLAYED_FIELD
, PPF1.FULL_NAME || '
, ' || HRL.LOCATION_CODE || '
, ' || OOD.NAME || '
, ' || RCT.SUBINVENTORY
, PRH.SEGMENT1
, PRL.UNIT_MEAS_LOOKUP_CODE
, (PRL.QUANTITY - PRL.QUANTITY_CANCELLED - PRL.QUANTITY_DELIVERED)
, PRL.NOTE_TO_RECEIVER
, 'REQ'
, RCT.INTERFACE_TRANSACTION_ID
, RCT.QUANTITY
, RCT.TRANSACTION_DATE
, PPF.FULL_NAME
, PRD.DISTRIBUTION_ID
, 'Y'
, PPF1.FULL_NAME
, HRL.LOCATION_CODE
, OOD.NAME
, RCT.SUBINVENTORY
, RCT.LOCATOR_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, ''
, WLPN1.LICENSE_PLATE_NUMBER LICENSE_PLATE_NUMBER
, WLPN2.LICENSE_PLATE_NUMBER TRANSFER_LICENSE_PLATE_NUMBER
FROM RCV_TRANSACTIONS_INTERFACE RCT
, PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS PRD
, HR_ALL_ORGANIZATION_UNITS_TL OOD
, HR_LOCATIONS_ALL_TL HRL
, PER_ALL_PEOPLE_F PPF1
, PER_ALL_PEOPLE_F PPF
, PO_LOOKUP_CODES PLC
, WMS_LICENSE_PLATE_NUMBERS WLPN1
, WMS_LICENSE_PLATE_NUMBERS WLPN2
WHERE RCT.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID
AND PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
AND PRD.REQUISITION_LINE_ID = PRL.REQUISITION_LINE_ID
AND RCT.SOURCE_DOCUMENT_CODE = 'REQ'
AND RCT.RECEIPT_SOURCE_CODE = 'INTERNAL ORDER'
AND OOD.ORGANIZATION_ID(+) = PRL.DESTINATION_ORGANIZATION_ID
AND OOD.LANGUAGE(+) = USERENV('LANG')
AND HRL.LOCATION_ID(+) = PRL.DELIVER_TO_LOCATION_ID
AND HRL.LANGUAGE(+) = USERENV('LANG')
AND PPF1.PERSON_ID(+) = PRL.TO_PERSON_ID
AND ((PPF1.BUSINESS_GROUP_ID IN (SELECT NVL(FSP.BUSINESS_GROUP_ID
, 0)
FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP)
AND TRUNC(SYSDATE) BETWEEN PPF1.EFFECTIVE_START_DATE
AND PPF1.EFFECTIVE_END_DATE
AND PPF1.EMPLOYEE_NUMBER IS NOT NULL) OR (PPF1.PERSON_ID IS NULL))
AND PPF.PERSON_ID(+) = RCT.EMPLOYEE_ID
AND ((PPF.BUSINESS_GROUP_ID IN (SELECT NVL(FSP.BUSINESS_GROUP_ID
, 0)
FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP)
AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND PPF.EMPLOYEE_NUMBER IS NOT NULL) OR (PPF.PERSON_ID IS NULL))
AND PLC.LOOKUP_TYPE = 'DESTINATION TYPE'
AND PLC.LOOKUP_CODE = PRL.DESTINATION_TYPE_CODE
AND RCT.LPN_ID = WLPN1.LPN_ID(+)
AND RCT.TRANSFER_LPN_ID = WLPN2.LPN_ID(+)

Columns