DBA Data[Home] [Help]

APPS.GHG_PO_EMISSIONS_PKG dependencies on GHG_SOURCES

Line 294: , GHG_SOURCES s

290: INTO v_emission_source,
291: v_location_code,
292: v_emission_scope_lookup_code
293: FROM GHG_SUPPLIER_ITEMS def
294: , GHG_SOURCES s
295: WHERE def.source_id = s.source_id
296: AND def.inventory_item_id = dist_rec.item_id
297: AND s.enabled = 'Y'
298: -- AND def.group_default = 'Y'

Line 310: , GHG_SOURCES s

306: INTO v_emission_source,
307: v_location_code,
308: v_emission_scope_lookup_code
309: FROM GHG_SUPPLIER_ITEMS def
310: , GHG_SOURCES s
311: WHERE def.source_id = s.source_id
312: AND def.supplier_id = x_vendor_id
313: and def.supplier_site_id = x_vendor_site_id
314: AND s.enabled = 'Y'