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.WMS_PACKING_WORKBENCH_PVT dependencies on RCV_SERIALS_SUPPLY

Line 3179: AND EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs

3175: wpmg.task_id IS NULL and p_task_id IS NULL) OR
3176: (wpmg.project_id = p_project_id AND wpmg.task_id = p_task_id))
3177: AND ((mol.wms_process_flag = 2 and wpmg.selected_flag='Y') OR
3178: (mol.wms_process_flag <> 2))
3179: AND EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs
3180: WHERE rss.serial_num = p_fm_serial_number AND (rss.supply_type_code = 'SHIPMENT' OR (rss.supply_type_code = 'RECEIVING' AND rss.transaction_id = rs.rcv_transaction_id))
3181: AND rss.shipment_line_id = rs.shipment_line_id
3182: AND ((mol.lpn_id IS NULL AND rs.lpn_id IS NULL) OR rs.lpn_id = mol.lpn_id)
3183: AND ((rs.shipment_line_id = mol.reference_id AND mol.reference='SHIPMENT_LINE_ID')

Line 3222: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs

3218: (wpmg.project_id = p_project_id AND wpmg.task_id = p_task_id))
3219: AND ((mol.wms_process_flag = 2 and wpmg.selected_flag='Y') OR
3220: (mol.wms_process_flag <> 2))
3221:
3222: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs
3223: WHERE rss.serial_num = p_fm_serial_number AND rss.shipment_line_id = rs.shipment_line_id
3224: AND rs.item_id=wpmg.inventory_item_id AND rs.to_organization_id=wpmg.organization_id)
3225:
3226: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs

Line 3226: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs

3222: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs
3223: WHERE rss.serial_num = p_fm_serial_number AND rss.shipment_line_id = rs.shipment_line_id
3224: AND rs.item_id=wpmg.inventory_item_id AND rs.to_organization_id=wpmg.organization_id)
3225:
3226: AND NOT EXISTS (SELECT 1 FROM rcv_serials_supply rss, rcv_supply rs
3227: WHERE (rss.supply_type_code = 'SHIPMENT' OR (rss.supply_type_code = 'RECEIVING' AND rss.transaction_id = rs.rcv_transaction_id))
3228: AND rss.shipment_line_id = rs.shipment_line_id
3229: AND ((mol.lpn_id IS NULL AND rs.lpn_id IS NULL) OR rs.lpn_id = mol.lpn_id)
3230: AND ((rs.shipment_line_id = mol.reference_id AND mol.reference='SHIPMENT_LINE_ID')