APPS.CSI_PARTY_RELATIONSHIPS_PUB dependencies on CSI_ITEM_INSTANCES

Line 208: ,csi_item_instances cii

204: INTO x_party_header_tbl(i).party_number
205: ,x_party_header_tbl(i).party_type
206: FROM per_all_people_f pf
207: ,csi_lookups cl
208: ,csi_item_instances cii
209: WHERE pf.person_id = x_party_header_tbl(i).party_id
210: AND cl.lookup_type=l_pty_lookup_type
211: AND cl.lookup_code=l_party_source_tbl
212: AND cii.instance_id=x_party_header_tbl(i).instance_id

Line 229: ,csi_item_instances cii

225: ,x_party_header_tbl(i).party_type
226: ,l_pty_name
227: FROM hz_parties hz
228: ,csi_lookups cl
229: ,csi_item_instances cii
230: WHERE party_id = x_party_header_tbl(i).party_id
231: AND cl.lookup_type=l_pty_lookup_type
232: AND cl.lookup_code=l_party_source_tbl
233: AND cii.instance_id=x_party_header_tbl(i).instance_id;

Line 252: ,csi_item_instances cii

248: ,cl.meaning --party_type
249: INTO x_party_header_tbl(i).party_number
250: ,x_party_header_tbl(i).party_type
251: FROM csi_lookups cl
252: ,csi_item_instances cii
253: ,po_vendors po
254: WHERE cl.lookup_type=l_pty_lookup_type
255: AND cl.lookup_code=l_party_source_tbl
256: AND cii.instance_id=x_party_header_tbl(i).instance_id

Line 270: ,csi_item_instances cii

266: INTO x_party_header_tbl(i).party_number
267: ,x_party_header_tbl(i).party_type
268: FROM jtf_rs_teams_vl jt
269: ,csi_lookups cl
270: ,csi_item_instances cii
271: WHERE jt.team_id = x_party_header_tbl(i).party_id
272: and cl.lookup_type=l_pty_lookup_type
273: and cl.lookup_code=l_party_source_tbl
274: and cii.instance_id=x_party_header_tbl(i).instance_id;

Line 287: ,csi_item_instances cii

283: INTO x_party_header_tbl(i).party_number
284: ,x_party_header_tbl(i).party_type
285: FROM jtf_rs_groups_vl jg
286: ,csi_lookups cl
287: ,csi_item_instances cii
288: WHERE jg.group_id = x_party_header_tbl(i).party_id
289: and cl.lookup_type=l_pty_lookup_type
290: and cl.lookup_code=l_party_source_tbl
291: and cii.instance_id=x_party_header_tbl(i).instance_id;

Line 758: FROM csi_item_instances

754: AND pty.instance_party_id= acct.instance_party_id;
755: -- Following cursor has been added for fixing the bug 2151750
756: /* CURSOR party_csr (p_object_id IN NUMBER) IS
757: SELECT instance_id subject_id -- added by sguthiva for 2608706
758: FROM csi_item_instances
759: WHERE instance_id IN(
760: SELECT subject_id
761: FROM csi_ii_relationships
762: WHERE relationship_type_code = 'COMPONENT-OF'

Line 1820: from csi_item_instances

1816: NVL(p_party_account_tbl(1).relationship_type_code,FND_API.G_MISS_CHAR) = 'OWNER' THEN
1817: Begin
1818: select system_id
1819: into l_ip_acct_rec.system_id
1820: from csi_item_instances
1821: where instance_id = l_rel_tbl(j).subject_id
1822: and nvl(system_id,fnd_api.g_miss_num) = p_party_account_tbl(1).system_id;
1823: Exception
1824: when no_data_found then