eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_WS_SHORTAGE dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1501: FROM po_req_distributions_all pd,

1497: and mr.supply_source_header_id = ms.req_header_id
1498: and mr.supply_source_line_id = ms.req_line_id ) reservation_qty,
1499: pd.requisition_line_id, --added for bug 6886708 for logging
1500: prl.REQUISITION_HEADER_ID --added for bug 6886708 for logging
1501: FROM po_req_distributions_all pd,
1502: po_requisition_lines_all prl,
1503: mtl_supply ms
1504: WHERE ms.item_id = p_inv_item_id
1505: AND ms.to_organization_id = p_org_id

Line 1549: FROM po_req_distributions_all pd,

1545: and mr.supply_source_header_id = ms.shipment_header_id
1546: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty,
1547: pd.requisition_line_id, --added for bug 6886708 for logging
1548: pl.REQUISITION_HEADER_ID --added for bug 6886708 for logging
1549: FROM po_req_distributions_all pd,
1550: po_requisition_lines_all pl,
1551: mtl_supply ms
1552: WHERE ms.item_id = p_inv_item_id
1553: AND ms.to_organization_id = p_org_id

Line 1598: po_req_distributions_all pd,

1594: where mr.supply_source_type_id = 18 --todo, need to check source type id
1595: and mr.supply_source_header_id = ms.shipment_header_id
1596: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty
1597: FROM po_requisition_lines_all pl,
1598: po_req_distributions_all pd,
1599: mtl_supply ms
1600: WHERE ms.item_id = p_inv_item_id
1601: AND ms.to_organization_id = p_org_id
1602: AND ms.supply_type_code = 'RECEIVING'