DBA Data[Home] [Help]

APPS.CSE_UTIL_PKG dependencies on CSI_ITEM_INSTANCES

Line 1302: ,csi_item_instances_h ciih

1298: CURSOR get_redeploy_flag_cur
1299: IS
1300: SELECT 'Y' redeploy_flag
1301: FROM csi_transactions ct
1302: ,csi_item_instances_h ciih
1303: ,csi_item_instances cii
1304: WHERE ct.transaction_id = ciih.transaction_id
1305: AND ciih.instance_id = cii.instance_id
1306: AND cii.inventory_item_id = p_inventory_item_id

Line 1303: ,csi_item_instances cii

1299: IS
1300: SELECT 'Y' redeploy_flag
1301: FROM csi_transactions ct
1302: ,csi_item_instances_h ciih
1303: ,csi_item_instances cii
1304: WHERE ct.transaction_id = ciih.transaction_id
1305: AND ciih.instance_id = cii.instance_id
1306: AND cii.inventory_item_id = p_inventory_item_id
1307: AND cii.serial_number = p_serial_number