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

96: mitl.long_description,
97: mparams.organization_id,
98: mparams.master_organization_id
99: FROM mtl_system_items_b mi,
100: mtl_parameters mparams,
101: mtl_system_items_tl mitl,
102: mtl_item_categories mic,
103: mtl_units_of_measure muom,
104: financials_system_params_all fsp,

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

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

Line 231: mtl_parameters mparams,

227: mitl.long_description,
228: mparams.organization_id,
229: mparams.master_organization_id
230: FROM mtl_system_items_b mi,
231: mtl_parameters mparams,
232: mtl_system_items_tl mitl,
233: mtl_item_categories mic,
234: mtl_units_of_measure muom,
235: financials_system_params_all fsp,

Line 365: mtl_parameters mparams,

361: mitl.long_description,
362: mparams.organization_id,
363: mparams.master_organization_id
364: FROM mtl_system_items_b mi,
365: mtl_parameters mparams,
366: mtl_item_bulkload_recs mbulk,
367: mtl_system_items_tl mitl,
368: mtl_item_categories mic,
369: mtl_units_of_measure muom,

Line 464: mtl_parameters mparams,

460: mitl.long_description,
461: mparams.organization_id,
462: mparams.master_organization_id
463: FROM mtl_system_items_b mi,
464: mtl_parameters mparams,
465: mtl_item_bulkload_recs mbulk,
466: mtl_system_items_tl mitl,
467: mtl_item_categories mic,
468: mtl_units_of_measure muom,

Line 547: mtl_parameters mparams,

543: mitl.long_description,
544: mparams.organization_id,
545: mparams.master_organization_id
546: FROM mtl_system_items_b mi,
547: mtl_parameters mparams,
548: mtl_item_bulkload_recs mbulk,
549: mtl_system_items_tl mitl,
550: mtl_item_categories mic,
551: mtl_units_of_measure muom,

Line 675: mtl_parameters mparams,

671: mitl.long_description,
672: mparams.organization_id,
673: mparams.master_organization_id
674: FROM mtl_system_items_b mi,
675: mtl_parameters mparams,
676: mtl_system_items_tl mitl,
677: mtl_item_categories mic,
678: mtl_units_of_measure muom,
679: financials_system_params_all fsp,

Line 796: mtl_parameters mparams,

792: mitl.long_description,
793: mparams.organization_id,
794: mparams.master_organization_id
795: FROM mtl_system_items_b mi,
796: mtl_parameters mparams,
797: mtl_system_items_tl mitl,
798: mtl_item_categories mic,
799: mtl_units_of_measure muom,
800: financials_system_params_all fsp,

Line 873: mtl_parameters mparams,

869: mitl.long_description,
870: mparams.organization_id,
871: mparams.master_organization_id
872: FROM mtl_system_items_b mi,
873: mtl_parameters mparams,
874: mtl_system_items_tl mitl,
875: mtl_item_categories mic,
876: mtl_units_of_measure muom,
877: financials_system_params_all fsp,

Line 1436: mtl_parameters mparams

1432: ctx.org_id,
1433: ctx.language
1434: FROM icx_cat_items_ctx_hdrs_tlp ctx,
1435: financials_system_params_all fsp,
1436: mtl_parameters mparams
1437: WHERE ctx.inventory_item_id = P_INVENTORY_ITEM_ID
1438: AND ctx.source_type = 'MASTER_ITEM'
1439: AND (mparams.master_organization_id = P_ORGANIZATION_ID
1440: OR mparams.organization_id = P_ORGANIZATION_ID)