Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.PO_DISTRIBUTIONS_PRINT |
SELECT PPF.FULL_NAME
, POD.CODE_COMBINATION_ID
, POD.QUANTITY_CANCELLED
, POD.QUANTITY_ORDERED
, POD.REQ_HEADER_REFERENCE_NUM
, POD.REQ_LINE_REFERENCE_NUM
, POD.DESTINATION_TYPE_CODE
, POD.DESTINATION_SUBINVENTORY
, POD.ATTRIBUTE_CATEGORY
, POD.ATTRIBUTE1
, POD.ATTRIBUTE2
, POD.ATTRIBUTE3
, POD.ATTRIBUTE4
, POD.ATTRIBUTE5
, POD.ATTRIBUTE6
, POD.ATTRIBUTE7
, POD.ATTRIBUTE8
, POD.ATTRIBUTE9
, POD.ATTRIBUTE10
, POD.ATTRIBUTE11
, POD.ATTRIBUTE12
, POD.ATTRIBUTE13
, POD.ATTRIBUTE14
, POD.ATTRIBUTE15
, POD.PO_HEADER_ID
, POD.PO_LINE_ID
, POD.LINE_LOCATION_ID
, POD.PO_RELEASE_ID
, POD.PO_DISTRIBUTION_ID
, POD.WIP_ENTITY_ID
, POD.DELIVER_TO_PERSON_ID
, POD.DELIVER_TO_LOCATION_ID
, POD.ORG_ID
FROM PER_PEOPLE_F PPF
, PO_DISTRIBUTIONS POD
WHERE POD.DELIVER_TO_PERSON_ID = PPF.PERSON_ID (+)
AND (( PPF.BUSINESS_GROUP_ID + 0 = (SELECT NVL(MAX(FSP.BUSINESS_GROUP_ID)
, 0)
FROM FINANCIALS_SYSTEM_PARAMETERS FSP)
AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE ) OR (PPF.PERSON_ID IS NULL) )