DBA Data[Home] [Help]

APPS.WIP_WS_SHORTAGE dependencies on PO_DISTRIBUTIONS_ALL

Line 1524: FROM po_distributions_all pd,

1520: where mr.supply_source_type_id = 1 --po supply
1521: and mr.supply_source_header_id = ms.po_header_id
1522: and mr.supply_source_line_id = ms.po_line_id ) reservation_qty,
1523: pd.PO_HEADER_ID --added for bug 6886708 for logging
1524: FROM po_distributions_all pd,
1525: mtl_supply ms
1526: WHERE ms.item_id = p_inv_item_id
1527: AND ms.to_organization_id = p_org_id
1528: AND ( ms.supply_type_code = 'PO' or

Line 1735: FROM po_distributions_all pd,

1731: where mr.supply_source_type_id = 18 --todo, need to check source type id
1732: and mr.supply_source_header_id = ms.shipment_header_id
1733: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty,
1734: pd.PO_HEADER_ID --added for bug 6886708 for logging
1735: FROM po_distributions_all pd,
1736: mtl_supply ms
1737: WHERE ms.item_id = p_inv_item_id
1738: AND ms.to_organization_id = p_org_id
1739: AND ms.supply_type_code = 'RECEIVING'