APPS.CSE_FAC_INSERVICE_PKG dependencies on CSI_ITEM_INSTANCES

Line 133: FROM csi_item_instances_h ciih,

129: cii.quantity,
130: cii.location_type_code,
131: cii.location_id,
132: cii.operational_status_code
133: FROM csi_item_instances_h ciih,
134: csi_item_instances cii
135: WHERE ciih.transaction_id = p_csi_txn_id
136: AND cii.instance_id = ciih.instance_id
137: AND (cii.operational_status_code = 'IN_SERVICE' OR ciih.new_operational_status_code = 'IN_SERVICE');

Line 134: csi_item_instances cii

130: cii.location_type_code,
131: cii.location_id,
132: cii.operational_status_code
133: FROM csi_item_instances_h ciih,
134: csi_item_instances cii
135: WHERE ciih.transaction_id = p_csi_txn_id
136: AND cii.instance_id = ciih.instance_id
137: AND (cii.operational_status_code = 'IN_SERVICE' OR ciih.new_operational_status_code = 'IN_SERVICE');
138:

Line 944: FROM csi_item_instances_h ciih,

940: SELECT cii.instance_id,
941: cii.serial_number,
942: cii.last_pa_project_id, --Added for Bug 9326077
943: cii.last_pa_task_id --Added for Bug 9326077
944: FROM csi_item_instances_h ciih,
945: csi_item_instances cii
946: WHERE ciih.transaction_id = p_csi_txn_id
947: AND cii.instance_id = ciih.instance_id
948: AND (ciih.new_operational_status_code = 'IN_SERVICE' OR cii.operational_status_code = 'IN_SERVICE');

Line 945: csi_item_instances cii

941: cii.serial_number,
942: cii.last_pa_project_id, --Added for Bug 9326077
943: cii.last_pa_task_id --Added for Bug 9326077
944: FROM csi_item_instances_h ciih,
945: csi_item_instances cii
946: WHERE ciih.transaction_id = p_csi_txn_id
947: AND cii.instance_id = ciih.instance_id
948: AND (ciih.new_operational_status_code = 'IN_SERVICE' OR cii.operational_status_code = 'IN_SERVICE');
949: