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.AHL_OSP_RCV_PVT dependencies on CSI_ITEM_INSTANCES

Line 1275: csi_item_instances csi

1271: csi.serial_number,
1272: csi.lot_number
1273: FROM csi_t_transaction_lines tl,
1274: csi_t_txn_line_details tld,
1275: csi_item_instances csi
1276: WHERE tl.source_transaction_id = c_oe_line_id
1277: AND tl.source_transaction_table = 'OE_ORDER_LINES_ALL'
1278: AND tl.transaction_line_id = tld.transaction_line_id
1279: AND tld.instance_id = csi.instance_id;

Line 1318: FROM csi_item_instances

1314: WHERE osp_order_line_id = c_osp_line_id;
1315:
1316: CURSOR get_instance_id(c_inv_item_id NUMBER, c_serial_number VARCHAR2) IS
1317: SELECT instance_id
1318: FROM csi_item_instances
1319: WHERE inventory_item_id = c_inv_item_id
1320: AND serial_number = c_serial_number;
1321:
1322: -- Cursor to check whether a pending receipt transaction exists for a given order line id.

Line 2552: SELECT 'x' FROM csi_item_instances csi

2548: -- Check if the instance is a valid IB instance
2549: -- Also not part of relationship
2550:
2551: CURSOR val_exg_instance_id_csr(p_instance_id IN NUMBER) IS
2552: SELECT 'x' FROM csi_item_instances csi
2553: WHERE instance_id = p_instance_id
2554: AND nvl(csi.active_end_date, sysdate + 1) > sysdate
2555: AND NOT EXISTS
2556: (select subject_id