APPS.ICX_ITEM_DIAG_PVT dependencies on ICX_POR_CATEGORY_DATA_SOURCES

Line 451: FROM mtl_item_categories mic , icx_por_category_data_sources i

447: AND mtl.organization_id = nvl(g_organization_id,organization_id) ;
448:
449: cursor mic(j number) is
450: select inventory_item_id ,organization_id,category_set_id, mic.category_id PO_CATEGORY, nvl(i.category_key ,-2) category_key,'Validate'
451: FROM mtl_item_categories mic , icx_por_category_data_sources i
452: WHERE mic.inventory_item_id = g_source_ids(j)
453: AND mic.organization_id = nvl(g_organization_id,mic.organization_id)
454: AND mic.category_set_id = g_category_set_id
455: and i.external_source(+) = 'Oracle'

Line 1138: icx_por_category_data_sources catMap

1134: mtl_system_items_tl mitl,
1135: mtl_item_categories mic,
1136: mtl_units_of_measure muom,
1137: financials_system_params_all fsp,
1138: icx_por_category_data_sources catMap
1139: WHERE mi.inventory_item_id = g_source_ids(j)
1140: AND mi.organization_id = mparams.organization_id
1141: AND (mparams.organization_id = nvl(g_organization_id,mparams.organization_id)
1142: OR mparams.master_organization_id =nvl(g_organization_id,mparams.master_organization_id))

Line 1807: icx_por_category_data_sources catMap

1803: mtl_system_items_tl mitl,
1804: mtl_item_categories mic,
1805: mtl_units_of_measure muom,
1806: financials_system_params_all fsp,
1807: icx_por_category_data_sources catMap
1808: WHERE
1809: mi.organization_id = mparams.organization_id
1810: AND (mparams.organization_id = nvl(p_org_id,mparams.organization_id)
1811: OR mparams.master_organization_id = nvl(p_org_id,mparams.master_organization_id))