APPS.ICX_CAT_POPULATE_MI_PVT dependencies on ICX_CAT_CATEGORIES_TL

Line 123: icx_cat_categories_tl ic1,

119: AND mi.organization_id = fsp.inventory_organization_id
120: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
121: AND catMap.external_source (+) = 'Oracle'
122: ) doc,
123: icx_cat_categories_tl ic1,
124: icx_cat_items_ctx_hdrs_tlp ctx
125: WHERE ic1.key (+) = doc.category_key
126: AND ic1.type (+) = 2
127: AND ic1.language (+) = doc.language

Line 253: icx_cat_categories_tl ic1,

249: AND mi.organization_id = fsp.inventory_organization_id
250: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
251: AND catMap.external_source (+) = 'Oracle'
252: ) doc,
253: icx_cat_categories_tl ic1,
254: icx_cat_items_ctx_hdrs_tlp ctx
255: WHERE ic1.key (+) = doc.category_key
256: AND ic1.type (+) = 2
257: AND ic1.language (+) = doc.language

Line 389: icx_cat_categories_tl ic1,

385: AND mi.organization_id = fsp.inventory_organization_id
386: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
387: AND catMap.external_source (+) = 'Oracle'
388: ) doc,
389: icx_cat_categories_tl ic1,
390: icx_cat_items_ctx_hdrs_tlp ctx
391: WHERE ic1.key (+) = doc.category_key
392: AND ic1.type (+) = 2
393: AND ic1.language (+) = doc.language

Line 490: icx_cat_categories_tl ic1,

486: AND mi.organization_id = fsp.inventory_organization_id
487: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
488: AND catMap.external_source (+) = 'Oracle'
489: ) doc,
490: icx_cat_categories_tl ic1,
491: icx_cat_items_ctx_hdrs_tlp ctx
492: WHERE ic1.key (+) = doc.category_key
493: AND ic1.type (+) = 2
494: AND ic1.language (+) = doc.language

Line 572: icx_cat_categories_tl ic1,

568: AND mi.organization_id = fsp.inventory_organization_id
569: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
570: AND catMap.external_source (+) = 'Oracle'
571: ) doc,
572: icx_cat_categories_tl ic1,
573: icx_cat_items_ctx_hdrs_tlp ctx
574: WHERE ic1.key (+) = doc.category_key
575: AND ic1.type (+) = 2
576: AND ic1.language (+) = doc.language

Line 692: icx_cat_categories_tl ic1,

688: AND mi.organization_id = fsp.inventory_organization_id
689: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
690: AND catMap.external_source (+) = 'Oracle'
691: ) doc,
692: icx_cat_categories_tl ic1,
693: icx_cat_items_ctx_hdrs_tlp ctx
694: WHERE ic1.key (+) = doc.category_key
695: AND ic1.type (+) = 2
696: AND ic1.language (+) = doc.language

Line 812: icx_cat_categories_tl ic1,

808: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
809: AND catMap.external_source (+) = 'Oracle'
810: AND mi.rowid BETWEEN g_start_rowid and g_end_rowid
811: ) doc,
812: icx_cat_categories_tl ic1,
813: icx_cat_items_ctx_hdrs_tlp ctx
814: WHERE ic1.key (+) = doc.category_key
815: AND ic1.type (+) = 2
816: AND ic1.language (+) = doc.language

Line 892: icx_cat_categories_tl ic1,

888: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
889: AND catMap.external_source (+) = 'Oracle'
890: AND mi.rowid BETWEEN g_start_rowid and g_end_rowid
891: ) doc,
892: icx_cat_categories_tl ic1,
893: icx_cat_items_ctx_hdrs_tlp ctx
894: WHERE ic1.key (+) = doc.category_key
895: AND ic1.type (+) = 2
896: AND ic1.language (+) = doc.language