APPS.CSI_INV_TXNSTUB_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 61: (SELECT inventory_item_id FROM mtl_material_transactions WHERE transaction_id = pc_transaction_id)

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;
63:
64: r_csi_inv_exist_txns_and_items c_csi_inv_exist_txns_and_items%rowtype;
65: