DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on PO_DISTRIBUTIONS_ALL

Line 1453: FROM po_distributions_all pd,

1449: where mr.supply_source_type_id = 1 --po supply
1450: and mr.supply_source_header_id = ms.po_header_id
1451: and mr.supply_source_line_id = ms.po_line_id ) reservation_qty,
1452: pd.PO_HEADER_ID --added for bug 6886708 for logging
1453: FROM po_distributions_all pd,
1454: mtl_supply ms
1455: WHERE ms.item_id = p_inv_item_id
1456: AND ms.to_organization_id = p_org_id
1457: AND ( ms.supply_type_code = 'PO' or

Line 1664: FROM po_distributions_all pd,

1660: where mr.supply_source_type_id = 18 --todo, need to check source type id
1661: and mr.supply_source_header_id = ms.shipment_header_id
1662: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty,
1663: pd.PO_HEADER_ID --added for bug 6886708 for logging
1664: FROM po_distributions_all pd,
1665: mtl_supply ms
1666: WHERE ms.item_id = p_inv_item_id
1667: AND ms.to_organization_id = p_org_id
1668: AND ms.supply_type_code = 'RECEIVING'