APPS.INV_RCV_STD_RCPT_APIS dependencies on PO_DISTRIBUTIONS_ALL

Line 43: FROM po_distributions_all pod

39: pod.project_id project_id
40: ,NVL(pod.task_id, '') task_id
41: INTO l_project_id
42: , l_task_id
43: FROM po_distributions_all pod
44: WHERE pod.line_location_id = p_po_line_location_id
45: AND ROWNUM = 1
46: AND pod.project_id IS NOT NULL
47: ORDER BY nvl(pod.task_id,-1) DESC;

Line 1723: FROM po_distributions_all pod

1719: AND NVL(msi.organization_id, poll.ship_to_organization_id) = poll.ship_to_organization_id
1720: AND msi.inventory_item_id(+) = pol.item_id
1721: AND poll.line_location_id IN(
1722: SELECT pod.line_location_id
1723: FROM po_distributions_all pod
1724: WHERE (
1725: p_project_id IS NULL
1726: OR(p_project_id = -9999
1727: AND pod.project_id IS NULL) --bug#2669021

Line 3945: FROM po_distributions_all pod

3941: AND rsl.shipment_line_status_code <> 'CANCELLED'
3942: AND rsl.shipment_line_id = v_shipment_line_id
3943: AND poll.line_location_id IN(
3944: SELECT pod.line_location_id
3945: FROM po_distributions_all pod
3946: WHERE (
3947: p_project_id IS NULL
3948: OR(p_project_id = -9999
3949: AND pod.project_id IS NULL)