APPS.ICX_CAT_POPULATE_MI_PVT dependencies on ICX_CAT_CATEGORIES_TL

Line 124: icx_cat_categories_tl ic1,

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

Line 255: icx_cat_categories_tl ic1,

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

Line 392: icx_cat_categories_tl ic1,

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

Line 494: icx_cat_categories_tl ic1,

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

Line 577: icx_cat_categories_tl ic1,

573: AND mi.organization_id = fsp.inventory_organization_id
574: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
575: AND catMap.external_source (+) = 'Oracle'
576: ) doc,
577: icx_cat_categories_tl ic1,
578: icx_cat_items_ctx_hdrs_tlp ctx
579: WHERE ic1.key (+) = doc.category_key
580: AND ic1.type (+) = 2
581: AND ic1.language (+) = doc.language

Line 698: icx_cat_categories_tl ic1,

694: AND mi.organization_id = fsp.inventory_organization_id
695: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
696: AND catMap.external_source (+) = 'Oracle'
697: ) doc,
698: icx_cat_categories_tl ic1,
699: icx_cat_items_ctx_hdrs_tlp ctx
700: WHERE ic1.key (+) = doc.category_key
701: AND ic1.type (+) = 2
702: AND ic1.language (+) = doc.language

Line 818: icx_cat_categories_tl ic1,

814: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
815: AND catMap.external_source (+) = 'Oracle'
816: AND mi.rowid BETWEEN g_start_rowid and g_end_rowid
817: ) doc,
818: icx_cat_categories_tl ic1,
819: icx_cat_items_ctx_hdrs_tlp ctx
820: WHERE ic1.key (+) = doc.category_key
821: AND ic1.type (+) = 2
822: AND ic1.language (+) = doc.language

Line 898: icx_cat_categories_tl ic1,

894: AND catMap.external_source_key (+) = TO_CHAR(mic.category_id)
895: AND catMap.external_source (+) = 'Oracle'
896: AND mi.rowid BETWEEN g_start_rowid and g_end_rowid
897: ) doc,
898: icx_cat_categories_tl ic1,
899: icx_cat_items_ctx_hdrs_tlp ctx
900: WHERE ic1.key (+) = doc.category_key
901: AND ic1.type (+) = 2
902: AND ic1.language (+) = doc.language