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 125: icx_cat_items_ctx_hdrs_tlp ctx

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

Line 256: icx_cat_items_ctx_hdrs_tlp ctx

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

Line 393: icx_cat_items_ctx_hdrs_tlp ctx

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

Line 495: icx_cat_items_ctx_hdrs_tlp ctx

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

Line 578: icx_cat_items_ctx_hdrs_tlp ctx

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

Line 699: icx_cat_items_ctx_hdrs_tlp ctx

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

Line 819: icx_cat_items_ctx_hdrs_tlp ctx

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

Line 899: icx_cat_items_ctx_hdrs_tlp ctx

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

Line 1434: FROM icx_cat_items_ctx_hdrs_tlp ctx,

1430: P_ORGANIZATION_ID NUMBER) IS
1431: SELECT ctx.inventory_item_id,
1432: ctx.org_id,
1433: ctx.language
1434: FROM icx_cat_items_ctx_hdrs_tlp ctx,
1435: financials_system_params_all fsp,
1436: mtl_parameters mparams
1437: WHERE ctx.inventory_item_id = P_INVENTORY_ITEM_ID
1438: AND ctx.source_type = 'MASTER_ITEM'