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 2987: rcv_serials_supply rss,

2983: ,msni.transaction_interface_id transaction_interface_id
2984: ,rsl.asn_line_flag asn_line_flag
2985: FROM rcv_supply rs,
2986: rcv_transactions rt,
2987: rcv_serials_supply rss,
2988: rcv_shipment_lines rsl,
2989: rcv_shipment_headers rsh,
2990: mtl_serial_numbers_interface msni
2991: WHERE rs.item_id = p_item_id

Line 3124: (SELECT '1' FROM rcv_serials_supply rss

3120: ,-1) = nvl(p_inspection_status, -1)
3121: --Bug 5331779 - Begin change
3122: --Adding the following to make sure that we do not pickup RS with serial numbers
3123: AND NOT exists
3124: (SELECT '1' FROM rcv_serials_supply rss
3125: WHERE rss.transaction_id = rs.supply_source_id
3126: AND rss.supply_type_code = 'RECEIVING')
3127: --Bug 5331779-End change
3128: ORDER BY ORDERING1, ORDERING2

Line 3656: FROM rcv_serials_supply rss,

3652: --Added for bug 14269755
3653: SELECT 'Y' INTO l_rss_exist FROM DUAL
3654: WHERE EXISTS
3655: (SELECT 1
3656: FROM rcv_serials_supply rss,
3657: mtl_serial_numbers_interface msni
3658: WHERE msni.product_code = 'RCV'
3659: AND msni.product_transaction_id = p_original_rti_id
3660: AND rss.serial_num between msni.fm_serial_number and msni.to_serial_number