DBA Data[Home] [Help]

APPS.ICX_POR_EXT_DIAG dependencies on MTL_ITEM_CATEGORIES

Line 873: mtl_item_categories mic,

869: FROM po_approved_supplier_list pasl,
870: po_vendors pv,
871: financials_system_params_all fsp,
872: mtl_system_items_kfv mi,
873: mtl_item_categories mic,
874: hr_all_organization_units hr
875: WHERE pasl.asl_id = pASLId
876: AND (fsp.org_id is null and pOperatingUnitId is null or fsp.org_id = pOperatingUnitId)
877: AND fsp.inventory_organization_id = pasl.owning_organization_id

Line 963: mtl_item_categories mic,

959: xCategoryId,
960: xOrgName
961: FROM financials_system_params_all fsp,
962: mtl_system_items_kfv mi,
963: mtl_item_categories mic,
964: hr_all_organization_units hr
965: WHERE (fsp.org_id is null and pOperatingUnitId is null or fsp.org_id = pOperatingUnitId)
966: AND fsp.inventory_organization_id = mi.organization_id
967: AND mi.concatenated_segments = pItemNum