[Home] [Help]
223: ,cii.install_location_id install_location_id
224: ,cii.install_location_type_code install_location_type_code
225: ,cip.party_id party_id
226: ,cip.party_source_table party_source_table
227: FROM csi_item_instances cii
228: ,csi_i_parties cip
229: WHERE cii.instance_id = p_instance_id
230: AND cip.instance_id = cii.instance_id
231: AND cip.relationship_type_code = 'OWNER';
411: ,nvl(ctld.install_location_type_code, FND_API.G_MISS_CHAR) install_location_type_code
412: ,cii.object_version_number
413: ,cii.instance_usage_code
414: FROM csi_t_txn_line_details ctld,
415: csi_item_instances cii
416: WHERE ctld.transaction_line_id = p_txn_line_id
417: AND ctld.INSTANCE_ID is not null
418: AND ctld.preserve_detail_flag = 'Y'
419: AND cii.instance_id = ctld.instance_id;
2633: -- Cursors
2634: CURSOR distinct_system_cur (txn_line_id IN NUMBER) IS
2635: SELECT distinct cii.system_id system_id
2636: FROM csi_t_txn_line_details ctld,
2637: csi_item_instances cii
2638: WHERE ctld.transaction_line_id = txn_line_id
2639: AND ctld.INSTANCE_ID is not null
2640: AND ctld.preserve_detail_flag = 'Y'
2641: AND cii.instance_id = ctld.instance_id;
2656: IF l_mu_systems_csr.system_id IS NOT NULL THEN
2657: -- To get the count of active item instances in the system
2658: SELECT COUNT(1)
2659: INTO l_active_instance_count
2660: FROM csi_item_instances cisv,
2661: CSI_SYSTEMS_B csb
2662: WHERE cisv.SYSTEM_ID = l_mu_systems_csr.system_id
2663: AND cisv.system_id = csb.system_id
2664: AND NVL(cisv.ACTIVE_END_DATE,sysdate+1) > sysdate
2669: -- To get total instances included in the mass update batch belonging to the system
2670: SELECT COUNT(1)
2671: INTO l_mu_instance_count
2672: FROM csi_t_txn_line_details ctld,
2673: csi_item_instances cii
2674: WHERE ctld.transaction_line_id = p_txn_line_id
2675: AND cii.system_id = l_mu_systems_csr.system_id
2676: AND ctld.INSTANCE_ID IS NOT NULL
2677: AND ctld.preserve_detail_flag = 'Y'