DBA Data[Home] [Help]

APPS.POS_SCO_TOLERANCE_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 3182: po_distributions_all pda

3178: IS
3179: select UNIQUE(pda.deliver_to_person_id)
3180: from
3181: po_change_requests pcr,
3182: po_distributions_all pda
3183: where pcr.change_request_group_id = c_grp_id_csr
3184: AND pcr.request_level = 'LINE'
3185: AND pcr.document_line_id = pda.po_line_id
3186: and pda.deliver_to_person_id is not null

Line 3191: po_distributions_all pda

3187: union
3188: select UNIQUE(pda.deliver_to_person_id)
3189: from
3190: po_change_requests pcr,
3191: po_distributions_all pda
3192: where pcr.change_request_group_id = c_grp_id_csr
3193: AND pcr.request_level = 'SHIPMENT'
3194: AND pcr.document_line_location_id = pda.line_location_id
3195: and pda.deliver_to_person_id is not null;

Line 4510: po_distributions_all pda

4506: IS
4507: select pda.deliver_to_person_id
4508: from
4509: po_change_requests pcr,
4510: po_distributions_all pda
4511: where pcr.change_request_group_id = c_grp_id_csr
4512: AND pcr.request_level = 'LINE'
4513: AND pcr.document_line_id = pda.po_line_id
4514: union

Line 4518: po_distributions_all pda

4514: union
4515: select pda.deliver_to_person_id
4516: from
4517: po_change_requests pcr,
4518: po_distributions_all pda
4519: where pcr.change_request_group_id = c_grp_id_csr
4520: AND pcr.request_level = 'SHIPMENT'
4521: AND pcr.document_line_location_id = pda.line_location_id;
4522: