DBA Data[Home] [Help]

APPS.GHG_TRANSACTIONS_API_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 450: mtl_system_items_kfv msi,

446: INTO v_item_id
447: , v_emission_source_id
448: , v_emission_source_name
449: FROM GHG_SUPPLIER_ITEMS gsi,
450: mtl_system_items_kfv msi,
451: ghg_sources s
452: WHERE msi.CONCATENATED_SEGMENTS = p_item_number
453: AND msi.INVENTORY_ITEM_ID = gsi.INVENTORY_ITEM_ID
454: and gsi.SOURCE_ID = s.SOURCE_ID;