APPS.CSI_UTILITY_GRP dependencies on CSI_ITEM_INSTANCES

Line 579: from csi_item_instances cii

575:
576: BEGIN
577: select 1
578: into l_record_found
579: from csi_item_instances cii
580: where cii.inventory_item_id = p_item_id
581: and cii.active_end_date IS NULL
582: and rownum < 2;
583:

Line 660: FROM csi_item_instances

656:
657: BEGIN
658: SELECT 1
659: INTO l_record_found
660: FROM csi_item_instances
661: WHERE inventory_item_id = p_inventory_item_id
662: AND serial_number = p_serial_number
663: AND config_inst_hdr_id is NOT NULL
664: AND config_inst_rev_num is NOT NULL

Line 1025: FROM csi_item_instances

1021: dummy_rec dummy_csr%rowtype;
1022:
1023: CURSOR install_date_csr (pc_instance_id IN NUMBER) IS
1024: SELECT install_date
1025: FROM csi_item_instances
1026: WHERE instance_id = pc_instance_id;
1027:
1028: install_date_rec install_date_csr%rowtype;
1029:

Line 1032: FROM csi_item_instances

1028: install_date_rec install_date_csr%rowtype;
1029:
1030: CURSOR parent_child_party_csr (pc_instance_id IN NUMBER) IS
1031: SELECT owner_party_id
1032: FROM csi_item_instances
1033: WHERE instance_id = pc_instance_id;
1034:
1035: parent_child_party_rec parent_child_party_csr%rowtype;
1036:

Line 1105: FROM csi_item_instances

1101:
1102: BEGIN
1103: SELECT owner_party_id,install_date
1104: INTO l_parent_owner_party_id,l_parent_install_date
1105: FROM csi_item_instances
1106: WHERE instance_id = inst_rec.instance_id;
1107:
1108: debug(' Parent Owner Party ('||l_parent_owner_party_id||')');
1109: debug(' Parent Installation Date ('||l_parent_install_date||')');

Line 1137: FROM csi_item_instances

1133:
1134: FOR trf IN l_txn_trf_instances_tbl.FIRST .. l_txn_trf_instances_tbl.LAST LOOP
1135: SELECT owner_party_id
1136: INTO l_owner_party_id
1137: FROM csi_item_instances
1138: WHERE instance_id = l_txn_trf_instances_tbl(trf);
1139:
1140: debug(' Owner Party: '||l_owner_party_id||' of Instance: '||l_txn_trf_instances_tbl(trf));
1141:

Line 1826: FROM csi_item_instances csi

1822: IS
1823:
1824: Cursor c_ib_instance( cp_instance_id NUMBER ) IS
1825: SELECT install_location_type_code install_location_type_code, install_location_id install_location_id, owner_party_id,owner_party_account_id, location_type_code location_type_code, location_id location_id
1826: FROM csi_item_instances csi
1827: WHERE csi.instance_id = cp_instance_id ;
1828:
1829: Cursor c_party_address( cp_location_id NUMBER)
1830: IS