APPS.ICX_ITEM_DIAG_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 436: FROM mtl_system_items_b

432: AND auto_created_config_flag = 'Y'), 'Valid Record') RULE_1_ISVALID ,
433: nvl( ( select 'Not Valid Record' from dual
434: where nvl(internal_order_enabled_flag,'N') ='N'
435: and ( list_price_per_unit is null or nvl(outside_operation_flag,'Y') ='Y' ) ),'Valid Record') RULE_2_ISVALID
436: FROM mtl_system_items_b
437: WHERE inventory_item_id = g_source_ids(j)
438: AND organization_id =nvl(g_organization_id,organization_id) ;
439:
440: cursor mtl(j number) is

Line 461: FROM mtl_units_of_measure muom,mtl_system_items_b mi

457: order by mic.inventory_item_id,mic.organization_id;
458:
459: cursor muom(j number) is
460: SELECT mi.inventory_item_id ,mi.organization_id , muom.unit_of_measure,muom.uom_code
461: FROM mtl_units_of_measure muom,mtl_system_items_b mi
462: WHERE mi.inventory_item_id = g_source_ids(j)
463: AND mi.organization_id = nvl(g_organization_id,mi.organization_id)
464: AND muom.uom_code = mi.primary_uom_code ;
465:

Line 545: if p_table_name = 'MTL_SYSTEM_ITEMS_B' then

541: l_api_name VARCHAR2 (20):='get_IDs_values';
542:
543: begin
544: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'start');
545: if p_table_name = 'MTL_SYSTEM_ITEMS_B' then
546: ICX_ITEM_DIAG_PVT.logStatement(g_pkg_name, l_api_name,'1');
547: p_col_val(1):= 'INVENTORY_ITEM_ID';
548: p_col_val(2):= 'ORGANIZATION_ID';
549: p_col_val(3):= 'SEGMENT1';

Line 1132: FROM mtl_system_items_b mi,

1128: mitl.description,
1129: mitl.long_description,
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,

Line 1455: FROM mtl_parameters mparams,financials_system_params_all fsp, mtl_system_items_b mtlb

1451: SELECT organization_id, master_organization_id
1452: INTO l_organization_id,l_master_organization_id
1453: FROM(
1454: SELECT mparams.organization_id organization_id, mparams.master_organization_id master_organization_id
1455: FROM mtl_parameters mparams,financials_system_params_all fsp, mtl_system_items_b mtlb
1456: WHERE fsp.ORG_ID = rec_MI.ORG_ID
1457: AND mtlb.inventory_item_id = rec_MI.inventory_item_id
1458: AND mtlb.organization_id = mparams.organization_id
1459: AND (mparams.organization_id = fsp.INVENTORY_ORGANIZATION_ID

Line 1481: FROM mtl_system_items_b

1477: l_item_invalid := FALSE;
1478: BEGIN
1479: SELECT 1
1480: INTO l_dummy
1481: FROM mtl_system_items_b
1482: WHERE inventory_item_id = rec_MI.INVENTORY_ITEM_ID
1483: AND organization_id = l_organization_id;
1484: EXCEPTION
1485: WHEN No_Data_Found THEN

Line 1801: FROM mtl_system_items_b mi,

1797: mitl.description,
1798: mitl.long_description,
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,