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_CAT_POPULATE_MI_PVT dependencies on MTL_PARAMETERS

Line 99: mtl_parameters mparams,

95: substr(mitl.long_description,1,2000),
96: mparams.organization_id,
97: mparams.master_organization_id
98: FROM mtl_system_items_b mi,
99: mtl_parameters mparams,
100: mtl_system_items_tl mitl,
101: mtl_item_categories mic,
102: mtl_units_of_measure muom,
103: financials_system_params_all fsp,

Line 180: -- Will use one cursor by joining with mtl_parameters and adding the following where clause

176: END IF;
177:
178: -- Need to consider the following
179: -- 1. populateItemChange with and without master org flag
180: -- Will use one cursor by joining with mtl_parameters and adding the following where clause
181: /*
182: AND mi.organization_id = mparams.organization_id
183: AND mi.inventory_item_id = p_inventory_item_id
184: AND (mparams.organization_id = p_organization_id

Line 229: mtl_parameters mparams,

225: substr(mitl.long_description,1,2000),
226: mparams.organization_id,
227: mparams.master_organization_id
228: FROM mtl_system_items_b mi,
229: mtl_parameters mparams,
230: mtl_system_items_tl mitl,
231: mtl_item_categories mic,
232: mtl_units_of_measure muom,
233: financials_system_params_all fsp,

Line 362: mtl_parameters mparams,

358: substr(mitl.long_description,1,2000),
359: mparams.organization_id,
360: mparams.master_organization_id
361: FROM mtl_system_items_b mi,
362: mtl_parameters mparams,
363: mtl_item_bulkload_recs mbulk,
364: mtl_system_items_tl mitl,
365: mtl_item_categories mic,
366: mtl_units_of_measure muom,

Line 460: mtl_parameters mparams,

456: substr(mitl.long_description,1,2000),
457: mparams.organization_id,
458: mparams.master_organization_id
459: FROM mtl_system_items_b mi,
460: mtl_parameters mparams,
461: mtl_item_bulkload_recs mbulk,
462: mtl_system_items_tl mitl,
463: mtl_item_categories mic,
464: mtl_units_of_measure muom,

Line 542: mtl_parameters mparams,

538: substr(mitl.long_description,1,2000),
539: mparams.organization_id,
540: mparams.master_organization_id
541: FROM mtl_system_items_b mi,
542: mtl_parameters mparams,
543: mtl_item_bulkload_recs mbulk,
544: mtl_system_items_tl mitl,
545: mtl_item_categories mic,
546: mtl_units_of_measure muom,

Line 669: mtl_parameters mparams,

665: substr(mitl.long_description,1,2000),
666: mparams.organization_id,
667: mparams.master_organization_id
668: FROM mtl_system_items_b mi,
669: mtl_parameters mparams,
670: mtl_system_items_tl mitl,
671: mtl_item_categories mic,
672: mtl_units_of_measure muom,
673: financials_system_params_all fsp,

Line 790: mtl_parameters mparams,

786: substr(mitl.long_description,1,2000),
787: mparams.organization_id,
788: mparams.master_organization_id
789: FROM mtl_system_items_b mi,
790: mtl_parameters mparams,
791: mtl_system_items_tl mitl,
792: mtl_item_categories mic,
793: mtl_units_of_measure muom,
794: financials_system_params_all fsp,

Line 867: mtl_parameters mparams,

863: substr(mitl.long_description,1,2000),
864: mparams.organization_id,
865: mparams.master_organization_id
866: FROM mtl_system_items_b mi,
867: mtl_parameters mparams,
868: mtl_system_items_tl mitl,
869: mtl_item_categories mic,
870: mtl_units_of_measure muom,
871: financials_system_params_all fsp,

Line 1429: mtl_parameters mparams

1425: ctx.org_id,
1426: ctx.language
1427: FROM icx_cat_items_ctx_hdrs_tlp ctx,
1428: financials_system_params_all fsp,
1429: mtl_parameters mparams
1430: WHERE ctx.inventory_item_id = P_INVENTORY_ITEM_ID
1431: AND ctx.source_type = 'MASTER_ITEM'
1432: AND (mparams.master_organization_id = P_ORGANIZATION_ID
1433: OR mparams.organization_id = P_ORGANIZATION_ID)