VIEW: APPS.PO_DISTRIBUTIONS_PRINT

Source

View Text - Preformatted

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) )

View Text - HTML Formatted

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) )