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 6276: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs

6272: WHERE item_id = p_item_id
6273: AND to_organization_id = p_organization_id
6274: AND EXISTS(
6275: SELECT 1
6276: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs
6277: WHERE prl.requisition_header_id = p_requiition_header_id
6278: AND rsl.requisition_line_id = prl.requisition_line_id
6279: AND prl.item_id = p_item_id
6280: AND prl.source_type_code = 'INVENTORY'

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

6435: WHERE item_id = p_item_id
6436: AND to_organization_id = p_organization_id
6437: AND EXISTS(
6438: SELECT 1
6439: FROM po_requisition_lines prl, rcv_transactions rt, rcv_supply rs
6440: WHERE prl.requisition_header_id = p_requiition_header_id
6441: AND rsl.requisition_line_id = prl.requisition_line_id
6442: AND prl.item_id = p_item_id
6443: AND prl.source_type_code = 'INVENTORY'

Line 7623: FROM rcv_supply

7619: , location_id
7620: INTO l_sub_code
7621: , l_locator_id
7622: , l_location_id
7623: FROM rcv_supply
7624: WHERE lpn_id = p_lpn_id
7625: AND to_organization_id = p_organization_id
7626: AND ROWNUM = 1;
7627: EXCEPTION