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_REQUISITION_LINES_ALL

Line 1573: po_requisition_lines_all prl,

1569: and mr.supply_source_line_id = ms.req_line_id ) reservation_qty,
1570: pd.requisition_line_id, --added for bug 6886708 for logging
1571: prl.REQUISITION_HEADER_ID --added for bug 6886708 for logging
1572: FROM po_req_distributions_all pd,
1573: po_requisition_lines_all prl,
1574: mtl_supply ms
1575: WHERE ms.item_id = p_inv_item_id
1576: AND ms.to_organization_id = p_org_id
1577: AND ms.supply_type_code = 'REQ'

Line 1621: po_requisition_lines_all pl,

1617: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty,
1618: pd.requisition_line_id, --added for bug 6886708 for logging
1619: pl.REQUISITION_HEADER_ID --added for bug 6886708 for logging
1620: FROM po_req_distributions_all pd,
1621: po_requisition_lines_all pl,
1622: mtl_supply ms
1623: WHERE ms.item_id = p_inv_item_id
1624: AND ms.to_organization_id = p_org_id
1625: AND ms.supply_type_code = 'SHIPMENT'

Line 1668: FROM po_requisition_lines_all pl,

1664: from mtl_reservations mr
1665: where mr.supply_source_type_id = 18 --todo, need to check source type id
1666: and mr.supply_source_header_id = ms.shipment_header_id
1667: and mr.supply_source_line_id = ms.shipment_line_id ) reservation_qty
1668: FROM po_requisition_lines_all pl,
1669: po_req_distributions_all pd,
1670: mtl_supply ms
1671: WHERE ms.item_id = p_inv_item_id
1672: AND ms.to_organization_id = p_org_id