APPS.CSC_SERVICE_KEY_PVT dependencies on CSI_ITEM_INSTANCES

Line 135: FROM csi_item_instances item

131:
132: -- Tag Number
133: CURSOR tag_num_cur IS
134: SELECT item.owner_party_id, item.owner_party_account_id, instance_id
135: FROM csi_item_instances item
136: WHERE item.external_reference IS NOT NULL
137: AND item.external_reference = l_skey_value;
138:
139: -- Serial Number

Line 142: FROM csi_item_instances item

138:
139: -- Serial Number
140: CURSOR serial_num_cur IS
141: SELECT item.owner_party_id, item.owner_party_account_id, instance_id
142: FROM csi_item_instances item
143: WHERE item.serial_number IS NOT NULL
144: AND item.serial_number = l_skey_value;
145:
146: -- Instance Name

Line 149: FROM csi_item_instances

145:
146: -- Instance Name
147: CURSOR instance_name_cur IS
148: SELECT owner_party_id, owner_party_account_id, instance_id
149: FROM csi_item_instances
150: WHERE owner_party_source_table = 'HZ_PARTIES'
151: AND instance_description IS NOT NULL
152: AND instance_description = l_skey_value;
153:

Line 157: FROM csi_item_instances

153:
154: -- Instance Number
155: CURSOR instance_num_cur IS
156: SELECT owner_party_id, owner_party_account_id, instance_id
157: FROM csi_item_instances
158: WHERE owner_party_source_table = 'HZ_PARTIES'
159: AND instance_number IS NOT NULL
160: AND instance_number = l_skey_value;
161: