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 1772: FROM po_distributions_all pod

1768: AND NVL(msi.organization_id, poll.ship_to_organization_id) = poll.ship_to_organization_id
1769: AND msi.inventory_item_id(+) = pol.item_id
1770: AND poll.line_location_id IN(
1771: SELECT pod.line_location_id
1772: FROM po_distributions_all pod
1773: WHERE (
1774: p_project_id IS NULL
1775: OR(p_project_id = -9999
1776: AND pod.project_id IS NULL) --bug#2669021

Line 4126: FROM po_distributions_all pod

4122: AND rsl.shipment_line_status_code <> 'CANCELLED'
4123: AND rsl.shipment_line_id = v_shipment_line_id
4124: AND poll.line_location_id IN(
4125: SELECT pod.line_location_id
4126: FROM po_distributions_all pod
4127: WHERE (
4128: p_project_id IS NULL
4129: OR(p_project_id = -9999
4130: AND pod.project_id IS NULL)