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_STD_TRANSFER_APIS dependencies on RCV_SERIALS_SUPPLY

Line 2963: rcv_serials_supply rss,

2959: ,msni.transaction_interface_id transaction_interface_id
2960: ,rsl.asn_line_flag asn_line_flag
2961: FROM rcv_supply rs,
2962: rcv_transactions rt,
2963: rcv_serials_supply rss,
2964: rcv_shipment_lines rsl,
2965: rcv_shipment_headers rsh,
2966: mtl_serial_numbers_interface msni
2967: WHERE rs.item_id = p_item_id

Line 3032: (SELECT '1' FROM rcv_serials_supply rss

3028: ,-1) = nvl(p_inspection_status, -1)
3029: --Bug 5331779 - Begin change
3030: --Adding the following to make sure that we do not pickup RS with serial numbers
3031: AND NOT exists
3032: (SELECT '1' FROM rcv_serials_supply rss
3033: WHERE rss.transaction_id = rs.supply_source_id
3034: AND rss.supply_type_code = 'RECEIVING')
3035: --Bug 5331779-End change
3036: ORDER BY ORDERING1, ORDERING2