APPS.ICX_ITEM_DIAG_PVT dependencies on MTL_SYSTEM_ITEMS_TL

Line 445: FROM mtl_system_items_tl mtl

441: SELECT inventory_item_id,organization_id,language
442: ,source_lang ,description ,long_description
443: ,nvl(( select 'Not Valid Record' from dual
444: where mtl.language <> mtl.source_lang), 'Valid Record') RULE_1_ISVALID
445: FROM mtl_system_items_tl mtl
446: WHERE mtl.inventory_item_id = g_source_ids(j)
447: AND mtl.organization_id = nvl(g_organization_id,organization_id) ;
448:
449: cursor mic(j number) is

Line 470: ,mtl_system_items_tl mtl

466: cursor ip_cat(j number) is
467: SELECT mtl.inventory_item_id ,mtl.organization_id, i.language,
468: nvl (i.rt_category_id,- 2) ip_category_id,i.category_name ip_category_name
469: FROM icx_cat_categories_tl i
470: ,mtl_system_items_tl mtl
471: WHERE mtl.inventory_item_id = g_source_ids(j)
472: AND mtl.organization_id = nvl(g_organization_id,mtl.organization_id)
473: AND i.key = g_category_key(j)
474: AND i.type = 2

Line 595: elsif p_table_name = 'MTL_SYSTEM_ITEMS_TL' then

591: p_col_num :=14;
592: p_row_num:=p_row_num-1;
593: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'p_row_num='||p_row_num || ' p_col_num='||p_col_num);
594:
595: elsif p_table_name = 'MTL_SYSTEM_ITEMS_TL' then
596: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'2');
597: p_col_val(1):= 'INVENTORY_ITEM_ID';
598: p_col_val(2):= 'ORGANIZATION_ID';
599: p_col_val(3):= 'LANGUAGE';

Line 1134: mtl_system_items_tl mitl,

1130: mparams.organization_id,
1131: mparams.master_organization_id
1132: FROM mtl_system_items_b mi,
1133: mtl_parameters mparams,
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

Line 1507: FROM MTL_SYSTEM_ITEMS_TL

1503:
1504: Begin
1505: SELECT LONG_DESCRIPTION
1506: INTO l_long_description
1507: FROM MTL_SYSTEM_ITEMS_TL
1508: WHERE inventory_item_id = rec_MI.INVENTORY_ITEM_ID
1509: AND organization_id = l_master_organization_id
1510: AND LANGUAGE = rec_MI.LANGUAGE;
1511: EXCEPTION

Line 1803: mtl_system_items_tl mitl,

1799: mparams.organization_id,
1800: mparams.master_organization_id
1801: FROM mtl_system_items_b mi,
1802: mtl_parameters mparams,
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