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 1505: csi_item_instances csi

1501: csi.serial_number,
1502: csi.lot_number
1503: FROM csi_t_transaction_lines tl,
1504: csi_t_txn_line_details tld,
1505: csi_item_instances csi
1506: WHERE tl.source_transaction_id = c_oe_line_id
1507: AND tl.source_transaction_table = 'OE_ORDER_LINES_ALL'
1508: AND tl.transaction_line_id = tld.transaction_line_id
1509: AND tld.instance_id = csi.instance_id;

Line 1548: FROM csi_item_instances

1544: WHERE osp_order_line_id = c_osp_line_id;
1545:
1546: CURSOR get_instance_id(c_inv_item_id NUMBER, c_serial_number VARCHAR2) IS
1547: SELECT instance_id
1548: FROM csi_item_instances
1549: WHERE inventory_item_id = c_inv_item_id
1550: AND serial_number = c_serial_number;
1551:
1552: -- Cursor to check whether a pending receipt transaction exists for a given order line id.

Line 2831: SELECT 'x' FROM csi_item_instances csi

2827: -- Check if the instance is a valid IB instance
2828: -- Also not part of relationship
2829:
2830: CURSOR val_exg_instance_id_csr(p_instance_id IN NUMBER) IS
2831: SELECT 'x' FROM csi_item_instances csi
2832: WHERE instance_id = p_instance_id
2833: AND nvl(csi.active_end_date, sysdate + 1) > sysdate
2834: AND NOT EXISTS
2835: (select subject_id