DBA Data[Home] [Help]

APPS.CSI_INV_TRXS_PKG dependencies on CSI_ITEM_INSTANCES_H

Line 4702: ,csi_item_instances_h ciih

4698: /*CURSOR get_redeploy_flag_cur
4699: IS
4700: SELECT 'Y' redeploy_flag
4701: FROM csi_transactions ct
4702: ,csi_item_instances_h ciih
4703: ,csi_item_instances cii
4704: WHERE ct.transaction_id = ciih.transaction_id
4705: AND ciih.instance_id = cii.instance_id
4706: AND cii.inventory_item_id = p_inventory_item_id

Line 4717: ,csi_item_instances_h ciih

4713: IS
4714: SELECT /*+ ordered */
4715: 'Y' redeploy_flag
4716: FROM csi_item_instances cii
4717: ,csi_item_instances_h ciih
4718: ,csi_transactions ct
4719: WHERE ct.transaction_id = ciih.transaction_id
4720: AND ciih.instance_id = cii.instance_id
4721: AND cii.inventory_item_id = p_inventory_item_id