eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ICX_ITEM_DIAG_PVT dependencies on MTL_PARAMETERS

Line 370: from financials_system_params_all fsp, hr_operating_units org ,org_organization_definitions org1 ,mtl_parameters mparams

366: cursor OU_INV is
367: select ORG_ID, org.SHORT_CODE OU_CODE, org.NAME OU_NAME ,
368: fsp.INVENTORY_ORGANIZATION_ID inventory_ORGANIZATION, org1.ORGANIZATION_CODE INV_ORG_CODE,org1.ORGANIZATION_NAME INV_ORG_NAME
369: ,mparams.MASTER_ORGANIZATION_ID
370: from financials_system_params_all fsp, hr_operating_units org ,org_organization_definitions org1 ,mtl_parameters mparams
371: where fsp.org_id =ICX_ITEM_DIAG_PVT.g_org_id
372: and fsp.org_id =org.ORGANIZATION_ID
373: and fsp.INVENTORY_ORGANIZATION_ID=org1.ORGANIZATION_ID
374: AND mparams.organization_id=fsp.INVENTORY_ORGANIZATION_ID;

Line 1133: mtl_parameters mparams,

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,
1137: financials_system_params_all fsp,

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 1802: mtl_parameters mparams,

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,
1806: financials_system_params_all fsp,