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

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

Line 233: financials_system_params_all fsp,

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

Line 367: financials_system_params_all fsp,

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

Line 466: financials_system_params_all fsp,

462: mtl_system_items_tl mitl,
463: mtl_item_categories mic,
464: mtl_units_of_measure muom,
465: mtl_category_sets msets,
466: financials_system_params_all fsp,
467: icx_por_category_data_sources catMap
468: WHERE mbulk.request_id = p_request_id
469: AND mbulk.entity_type = p_entity_type
470: AND mbulk.inventory_item_id >= p_inventory_item_id

Line 548: financials_system_params_all fsp,

544: mtl_system_items_tl mitl,
545: mtl_item_categories mic,
546: mtl_units_of_measure muom,
547: mtl_category_sets msets,
548: financials_system_params_all fsp,
549: icx_por_category_data_sources catMap
550: WHERE mbulk.request_id = p_request_id
551: AND mbulk.entity_type = p_entity_type
552: AND mbulk.inventory_item_id >= p_inventory_item_id

Line 673: financials_system_params_all fsp,

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,
674: icx_por_category_data_sources catMap
675: WHERE mi.inventory_item_id = mitl.inventory_item_id
676: AND mi.organization_id = mparams.organization_id
677: AND mi.organization_id = mitl.organization_id

Line 794: financials_system_params_all fsp,

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,
795: icx_por_category_data_sources catMap
796: WHERE mi.inventory_item_id = mitl.inventory_item_id
797: AND mi.organization_id = mparams.organization_id
798: AND mi.organization_id = mitl.organization_id

Line 871: financials_system_params_all fsp,

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,
872: icx_por_category_data_sources catMap
873: WHERE mi.inventory_item_id = mitl.inventory_item_id
874: AND mi.organization_id = mparams.organization_id
875: AND mi.organization_id = mitl.organization_id

Line 1428: financials_system_params_all fsp,

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