DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_MI_PVT dependencies on ICX_POR_CATEGORY_DATA_SOURCES

Line 105: icx_por_category_data_sources catMap

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
109: OR mparams.master_organization_id = p_organization_id)

Line 236: icx_por_category_data_sources catMap

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
240: OR mparams.master_organization_id = p_organization_id)

Line 371: icx_por_category_data_sources catMap

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
375: AND mbulk.inventory_item_id = mi.inventory_item_id

Line 471: icx_por_category_data_sources catMap

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
475: AND mbulk.inventory_item_id = mi.inventory_item_id

Line 554: icx_por_category_data_sources catMap

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
558: AND mbulk.inventory_item_id = mi.inventory_item_id

Line 680: icx_por_category_data_sources catMap

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
684: AND mitl.language = mitl.source_lang

Line 801: icx_por_category_data_sources catMap

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
805: AND mitl.language = mitl.source_lang

Line 878: icx_por_category_data_sources catMap

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
882: AND mitl.language = mitl.source_lang