APPS.CSI_INV_TXNSTUB_PKG dependencies on CSI_ITEM_INSTANCES

Line 57: SELECT instance_id FROM csi_item_instances WHERE instance_id IN

53:
54: r_csi_inv_exist_txns c_csi_inv_exist_txns%rowtype;
55:
56: CURSOR c_csi_inv_exist_txns_and_items (pc_transaction_id IN NUMBER) IS
57: SELECT instance_id FROM csi_item_instances WHERE instance_id IN
58: (SELECT instance_id FROM csi_item_instances_h WHERE transaction_id IN
59: (SELECT transaction_id FROM csi_transactions WHERE inv_material_transaction_id = pc_transaction_id))
60: AND inventory_item_id IN
61: (SELECT inventory_item_id FROM mtl_material_transactions WHERE transaction_id = pc_transaction_id)

Line 58: (SELECT instance_id FROM csi_item_instances_h WHERE transaction_id IN

54: r_csi_inv_exist_txns c_csi_inv_exist_txns%rowtype;
55:
56: CURSOR c_csi_inv_exist_txns_and_items (pc_transaction_id IN NUMBER) IS
57: SELECT instance_id FROM csi_item_instances WHERE instance_id IN
58: (SELECT instance_id FROM csi_item_instances_h WHERE transaction_id IN
59: (SELECT transaction_id FROM csi_transactions WHERE inv_material_transaction_id = pc_transaction_id))
60: AND inventory_item_id IN
61: (SELECT inventory_item_id FROM mtl_material_transactions WHERE transaction_id = pc_transaction_id)
62: AND ROWNUM = 1;