APPS.CSE_ASSET_CREATION_PKG dependencies on CSI_ITEM_INSTANCES_H

Line 330: csi_item_instances_h ciih

326:
327: CURSOR deploy_cur IS
328: SELECT 'Y'
329: FROM csi_transactions ct,
330: csi_item_instances_h ciih
331: WHERE ciih.instance_id = p_instance_id
332: AND ct.transaction_id = ciih.transaction_id
333: AND ct.transaction_date < p_transaction_date
334: AND ct.transaction_type_id in (110, 108, 132, 133);

Line 362: csi_item_instances_h ciih

358: IS
359: CURSOR txn_cur IS
360: SELECT ct.transaction_id
361: FROM csi_transactions ct,
362: csi_item_instances_h ciih
363: WHERE ciih.instance_id = p_instance_id
364: AND ct.transaction_id = ciih.transaction_id
365: AND ct.transaction_id < p_csi_txn_id
366: AND ct.transaction_status_code = 'PENDING';

Line 2103: FROM csi_item_instances_h ciih,

2099: cii.instance_usage_code,
2100: cii.quantity,
2101: nvl(ciih.old_quantity,0) old_quantity,
2102: ciih.new_quantity
2103: FROM csi_item_instances_h ciih,
2104: csi_item_instances cii
2105: WHERE ciih.transaction_id = p_csi_txn_id
2106: AND cii.instance_id = ciih.instance_id
2107: AND cii.inventory_item_id = p_inventory_item_id