APPS.ICX_CAT_POPULATE_MI_PVT dependencies on ICX_CAT_ITEMS_CTX_HDRS_TLP

Line 55: -- and the row is present in icx_cat_items_ctx_hdrs_tlpm then we need to remove these

51:
52: -- Have a different cursor instead of using the cursor for openOnlineItemChangeCursor
53: -- because since the category assignment has deleted, in this case we need to do an
54: -- outer join with mtl_item_categories and check if the po_category_id is null
55: -- and the row is present in icx_cat_items_ctx_hdrs_tlpm then we need to remove these
56: -- items from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp
57:
58: l_err_loc := 300;
59: OPEN l_masterItem_csr FOR

Line 56: -- items from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp

52: -- Have a different cursor instead of using the cursor for openOnlineItemChangeCursor
53: -- because since the category assignment has deleted, in this case we need to do an
54: -- outer join with mtl_item_categories and check if the po_category_id is null
55: -- and the row is present in icx_cat_items_ctx_hdrs_tlpm then we need to remove these
56: -- items from icx_cat_items_ctx_hdrs_tlp and icx_cat_items_ctx_dtls_tlp
57:
58: l_err_loc := 300;
59: OPEN l_masterItem_csr FOR
60: SELECT /*+ LEADING(doc) */

Line 124: icx_cat_items_ctx_hdrs_tlp ctx

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
128: AND doc.inventory_item_id = ctx.inventory_item_id (+)

Line 254: icx_cat_items_ctx_hdrs_tlp ctx

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
258: AND doc.inventory_item_id = ctx.inventory_item_id (+)

Line 390: icx_cat_items_ctx_hdrs_tlp ctx

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
394: AND doc.inventory_item_id = ctx.inventory_item_id (+)

Line 491: icx_cat_items_ctx_hdrs_tlp ctx

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
495: AND doc.inventory_item_id = ctx.inventory_item_id (+)

Line 573: icx_cat_items_ctx_hdrs_tlp ctx

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
577: AND doc.inventory_item_id = ctx.inventory_item_id (+)

Line 693: icx_cat_items_ctx_hdrs_tlp ctx

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
697: AND doc.inventory_item_id = ctx.inventory_item_id (+)

Line 813: icx_cat_items_ctx_hdrs_tlp ctx

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
817: AND doc.inventory_item_id = ctx.inventory_item_id (+)

Line 893: icx_cat_items_ctx_hdrs_tlp ctx

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
897: AND doc.inventory_item_id = ctx.inventory_item_id (+)

Line 1427: FROM icx_cat_items_ctx_hdrs_tlp ctx,

1423: P_ORGANIZATION_ID NUMBER) IS
1424: SELECT ctx.inventory_item_id,
1425: ctx.org_id,
1426: ctx.language
1427: FROM icx_cat_items_ctx_hdrs_tlp ctx,
1428: financials_system_params_all fsp,
1429: mtl_parameters mparams
1430: WHERE ctx.inventory_item_id = P_INVENTORY_ITEM_ID
1431: AND ctx.source_type = 'MASTER_ITEM'