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 FINANCIALS_SYSTEM_PARAMS_ALL

Line 104: financials_system_params_all fsp,

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,
105: icx_por_category_data_sources catMap
106: WHERE mi.inventory_item_id = p_inventory_item_id
107: AND mi.organization_id = mparams.organization_id
108: AND (mparams.organization_id = p_organization_id

Line 235: financials_system_params_all fsp,

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,
236: icx_por_category_data_sources catMap
237: WHERE mi.inventory_item_id = p_inventory_item_id
238: AND mi.organization_id = mparams.organization_id
239: AND (mparams.organization_id = p_organization_id

Line 370: financials_system_params_all fsp,

366: mtl_item_bulkload_recs mbulk,
367: mtl_system_items_tl mitl,
368: mtl_item_categories mic,
369: mtl_units_of_measure muom,
370: financials_system_params_all fsp,
371: icx_por_category_data_sources catMap
372: WHERE mbulk.request_id = p_request_id
373: AND mbulk.entity_type = p_entity_type
374: AND mbulk.inventory_item_id >= p_inventory_item_id

Line 470: financials_system_params_all fsp,

466: mtl_system_items_tl mitl,
467: mtl_item_categories mic,
468: mtl_units_of_measure muom,
469: mtl_category_sets msets,
470: financials_system_params_all fsp,
471: icx_por_category_data_sources catMap
472: WHERE mbulk.request_id = p_request_id
473: AND mbulk.entity_type = p_entity_type
474: AND mbulk.inventory_item_id >= p_inventory_item_id

Line 553: financials_system_params_all fsp,

549: mtl_system_items_tl mitl,
550: mtl_item_categories mic,
551: mtl_units_of_measure muom,
552: mtl_category_sets msets,
553: financials_system_params_all fsp,
554: icx_por_category_data_sources catMap
555: WHERE mbulk.request_id = p_request_id
556: AND mbulk.entity_type = p_entity_type
557: AND mbulk.inventory_item_id >= p_inventory_item_id

Line 679: financials_system_params_all fsp,

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,
680: icx_por_category_data_sources catMap
681: WHERE mi.inventory_item_id = mitl.inventory_item_id
682: AND mi.organization_id = mparams.organization_id
683: AND mi.organization_id = mitl.organization_id

Line 800: financials_system_params_all fsp,

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,
801: icx_por_category_data_sources catMap
802: WHERE mi.inventory_item_id = mitl.inventory_item_id
803: AND mi.organization_id = mparams.organization_id
804: AND mi.organization_id = mitl.organization_id

Line 877: financials_system_params_all fsp,

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,
878: icx_por_category_data_sources catMap
879: WHERE mi.inventory_item_id = mitl.inventory_item_id
880: AND mi.organization_id = mparams.organization_id
881: AND mi.organization_id = mitl.organization_id

Line 1435: financials_system_params_all fsp,

1431: SELECT ctx.inventory_item_id,
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