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.INV_RCV_COMMON_APIS dependencies on RCV_SUPPLY

Line 5744: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs

5740: WHERE item_id = p_item_id
5741: AND to_organization_id = p_organization_id
5742: AND EXISTS(
5743: SELECT 1
5744: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs
5745: WHERE prl.requisition_header_id = p_requiition_header_id
5746: AND rsl.requisition_line_id = prl.requisition_line_id
5747: AND prl.item_id = p_item_id
5748: AND prl.source_type_code = 'INVENTORY'

Line 5907: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs

5903: WHERE item_id = p_item_id
5904: AND to_organization_id = p_organization_id
5905: AND EXISTS(
5906: SELECT 1
5907: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs
5908: WHERE prl.requisition_header_id = p_requiition_header_id
5909: AND rsl.requisition_line_id = prl.requisition_line_id
5910: AND prl.item_id = p_item_id
5911: AND prl.source_type_code = 'INVENTORY'

Line 7091: FROM rcv_supply

7087: , location_id
7088: INTO l_sub_code
7089: , l_locator_id
7090: , l_location_id
7091: FROM rcv_supply
7092: WHERE lpn_id = p_lpn_id
7093: AND to_organization_id = p_organization_id
7094: AND ROWNUM = 1;
7095: EXCEPTION