APPS.PO_CHANGEORDERWF_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 1735: and exists (select 1 from po_distributions_all

1731: and msi.inventory_item_id(+) = pla.item_id
1732: --and msi.organization_id(+) = pla.org_id
1733: and NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
1734: AND FSP.ORG_ID = PLA.ORG_ID
1735: and exists (select 1 from po_distributions_all
1736: where po_line_id = pcr.document_line_id
1737: and deliver_to_person_id = l_requestor_id)
1738: UNION ALL
1739:

Line 1781: and exists (select 1 from po_distributions_all

1777: and msi.inventory_item_id(+) = pla.item_id
1778: --and msi.organization_id(+) = pla.org_id
1779: and NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
1780: AND FSP.ORG_ID = PLA.ORG_ID
1781: and exists (select 1 from po_distributions_all
1782: where line_location_id = pcr.document_line_location_id
1783: and deliver_to_person_id = l_requestor_id)
1784: UNION ALL
1785:

Line 1827: and exists (select 1 from po_distributions_all

1823: and msi.inventory_item_id(+) = pla.item_id
1824: --and msi.organization_id(+) = pla.org_id
1825: and NVL(MSI.ORGANIZATION_ID, FSP.INVENTORY_ORGANIZATION_ID) = FSP.INVENTORY_ORGANIZATION_ID
1826: AND FSP.ORG_ID = PLA.ORG_ID
1827: and exists (select 1 from po_distributions_all
1828: where line_location_id = pcr.parent_line_location_id
1829: and deliver_to_person_id = l_requestor_id)
1830: )
1831: order by LINE_NUM,nvl(SHIPMENT_NUM,0);

Line 5845: po_distributions_all pda

5841: x_progress varchar2(3) := '000';
5842: cursor l_x_csr(id number) is
5843: select pcr.document_line_locatiON_id
5844: from po_change_requests pcr,
5845: po_distributions_all pda
5846: where pcr.document_line_location_id = pda.line_location_id
5847: and pcr.change_request_group_id = id -- added checks FPS Shipment Amount, Shipment price Prorate
5848: and (pcr.new_quantity is not null or pcr.new_amount is not null or pcr.new_price is not null)
5849: group by pcr.document_line_location_id

Line 7604: po_distributions_all pda,

7600: is
7601: select pda.deliver_to_person_id
7602: from
7603: po_change_requests pcr,
7604: po_distributions_all pda,
7605: po_line_locations_all pll
7606: where pcr.change_request_group_id = grp_id
7607: and pcr.request_level = 'LINE'
7608: and pcr.document_line_id = pda.po_line_id

Line 7615: po_distributions_all pda

7611: union
7612: select pda.deliver_to_person_id
7613: from
7614: po_change_requests pcr,
7615: po_distributions_all pda
7616: where pcr.change_request_group_id = grp_id
7617: and pcr.request_level = 'SHIPMENT'
7618: and pcr.document_line_location_id = pda.line_location_id;
7619: