APPS.PO_CHANGEORDERWF_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 1591: and exists (select 1 from po_distributions_all

1587: and msi.inventory_item_id(+) = pla.item_id
1588: --and msi.organization_id(+) = pla.org_id
1589: and NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
1590: AND FSP.ORG_ID = PLA.ORG_ID
1591: and exists (select 1 from po_distributions_all
1592: where po_line_id = pcr.document_line_id
1593: and deliver_to_person_id = l_requestor_id)
1594: UNION ALL
1595:

Line 1637: and exists (select 1 from po_distributions_all

1633: and msi.inventory_item_id(+) = pla.item_id
1634: --and msi.organization_id(+) = pla.org_id
1635: and NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
1636: AND FSP.ORG_ID = PLA.ORG_ID
1637: and exists (select 1 from po_distributions_all
1638: where line_location_id = pcr.document_line_location_id
1639: and deliver_to_person_id = l_requestor_id)
1640: UNION ALL
1641:

Line 1683: and exists (select 1 from po_distributions_all

1679: and msi.inventory_item_id(+) = pla.item_id
1680: --and msi.organization_id(+) = pla.org_id
1681: and NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
1682: AND FSP.ORG_ID = PLA.ORG_ID
1683: and exists (select 1 from po_distributions_all
1684: where line_location_id = pcr.parent_line_location_id
1685: and deliver_to_person_id = l_requestor_id)
1686: )
1687: order by LINE_NUM,nvl(SHIPMENT_NUM,0);

Line 5691: po_distributions_all pda

5687: x_progress varchar2(3) := '000';
5688: cursor l_x_csr(id number) is
5689: select pcr.document_line_locatiON_id
5690: from po_change_requests pcr,
5691: po_distributions_all pda
5692: where pcr.document_line_location_id = pda.line_location_id
5693: and pcr.change_request_group_id = id -- added checks FPS Shipment Amount, Shipment price Prorate
5694: and (pcr.new_quantity is not null or pcr.new_amount is not null or pcr.new_price is not null)
5695: group by pcr.document_line_location_id

Line 7446: po_distributions_all pda,

7442: is
7443: select pda.deliver_to_person_id
7444: from
7445: po_change_requests pcr,
7446: po_distributions_all pda,
7447: po_line_locations_all pll
7448: where pcr.change_request_group_id = grp_id
7449: and pcr.request_level = 'LINE'
7450: and pcr.document_line_id = pda.po_line_id

Line 7457: po_distributions_all pda

7453: union
7454: select pda.deliver_to_person_id
7455: from
7456: po_change_requests pcr,
7457: po_distributions_all pda
7458: where pcr.change_request_group_id = grp_id
7459: and pcr.request_level = 'SHIPMENT'
7460: and pcr.document_line_location_id = pda.line_location_id;
7461: