VIEW: APPS.GHG_SOURCE_COMB_MEANING_V

Source

View Text - Preformatted

SELECT sc.ROWID row_id, SC.source_combination_id, sc.source_combination_code, sc.source_combination_description, sc.source_id, sc.start_date, sc.end_date, sc.created_by, sc.creation_date, sc.last_updated_by, sc.last_update_date, sc.last_update_login, sc.code_combination_id, sc.scope_lookup_code, sc.method_lookup_code, sc.rate_override_type, sc.supplier_id, sc.supplier_site_id, sc.item_id, sc.method_justification, sc.ghg_organization_id, sc.supplier_type, sc.item_type, sc.location_code, sc.transport_type_lookup_code, sc.org_id, sup.vendor_name supplier_name, sup_site.vendor_site_code supplier_site, item_details.item_number, item_details.item_description, scope.meaning Scope, method.meaning Method, trans_type.meaning Transport_Type, loc.meaning Location, Decode(sc.rate_override_type, NULL, NULL, (SELECT ov_type.meaning FROM fnd_lookup_values ov_type WHERE ov_type.lookup_type = 'GHG_RATE_OVERRIDE_TYPES' AND ov_type.lookup_code = sc.rate_override_type AND LANGUAGE = UserEnv('LANG'))) Rate_Override_Type_Meaning, Decode(sc.item_type, NULL, NULL, (SELECT item_type.meaning FROM fnd_lookup_values item_type WHERE item_type.lookup_type = 'GHG_ITEM_TYPE' AND item_type.lookup_code = sc.item_type AND LANGUAGE = UserEnv('LANG'))) Item_Type_Meaning, Decode(sc.supplier_type, NULL, NULL, (SELECT supplier_type.meaning FROM fnd_lookup_values supplier_type WHERE supplier_type.lookup_type = 'GHG_SUPPLIER_TYPES' AND supplier_type.lookup_code = sc.supplier_type AND LANGUAGE = UserEnv('LANG'))) Supplier_Type_Meaning, ghg_orgs.GHG_ORGANIZATION_CODE, ghg_orgs.DESCRIPTION FROM ghg_source_combinations_all sc, fnd_lookup_values scope, fnd_lookup_values method, fnd_lookup_values trans_type, fnd_lookup_values loc, ap_suppliers sup, po_vendor_sites sup_site, (SELECT DISTINCT ood.operating_unit org_id, msi.inventory_item_id item_id, msi.concatenated_segments item_number, msi.description item_description FROM org_organization_definitions ood, mtl_system_items_kfv msi, mtl_units_of_measure_vl muom WHERE msi.organization_id = ood.organization_id AND Nvl(msi.approval_status, 'A') = 'A' AND muom.unit_of_measure = msi.primary_unit_of_measure) item_details, ghg_organizations_all ghg_orgs WHERE sc.scope_lookup_code = scope.lookup_code AND scope.lookup_type = 'GHG_EMISSION_SCOPE' AND scope.LANGUAGE = UserEnv('LANG') AND sc.method_lookup_code = method.lookup_code AND method.lookup_type = 'GHG_METHOD_TYPE' AND method.LANGUAGE = UserEnv('LANG') AND sc.TRANSPORT_TYPE_LOOKUP_CODE = trans_type.lookup_code AND trans_type.lookup_type = 'GHG_TRANSPORT_TYPE' AND trans_type.LANGUAGE = UserEnv('LANG') AND sc.LOCATION_CODE = loc.lookup_code AND loc.lookup_type = 'GHG_LOCATION' AND loc.LANGUAGE = UserEnv('LANG') AND sc.supplier_id = sup.vendor_id (+) AND sc.supplier_id = sup_site.vendor_id (+) AND sc.supplier_site_id = sup_site.vendor_site_id (+) AND sc.org_id = item_details.org_id (+) AND sc.item_id = item_details.item_id (+) AND sc.ghg_organization_id = ghg_orgs.ghg_organization_id (+)

View Text - HTML Formatted

SELECT SC.ROWID ROW_ID
, SC.SOURCE_COMBINATION_ID
, SC.SOURCE_COMBINATION_CODE
, SC.SOURCE_COMBINATION_DESCRIPTION
, SC.SOURCE_ID
, SC.START_DATE
, SC.END_DATE
, SC.CREATED_BY
, SC.CREATION_DATE
, SC.LAST_UPDATED_BY
, SC.LAST_UPDATE_DATE
, SC.LAST_UPDATE_LOGIN
, SC.CODE_COMBINATION_ID
, SC.SCOPE_LOOKUP_CODE
, SC.METHOD_LOOKUP_CODE
, SC.RATE_OVERRIDE_TYPE
, SC.SUPPLIER_ID
, SC.SUPPLIER_SITE_ID
, SC.ITEM_ID
, SC.METHOD_JUSTIFICATION
, SC.GHG_ORGANIZATION_ID
, SC.SUPPLIER_TYPE
, SC.ITEM_TYPE
, SC.LOCATION_CODE
, SC.TRANSPORT_TYPE_LOOKUP_CODE
, SC.ORG_ID
, SUP.VENDOR_NAME SUPPLIER_NAME
, SUP_SITE.VENDOR_SITE_CODE SUPPLIER_SITE
, ITEM_DETAILS.ITEM_NUMBER
, ITEM_DETAILS.ITEM_DESCRIPTION
, SCOPE.MEANING SCOPE
, METHOD.MEANING METHOD
, TRANS_TYPE.MEANING TRANSPORT_TYPE
, LOC.MEANING LOCATION
, DECODE(SC.RATE_OVERRIDE_TYPE
, NULL
, NULL
, (SELECT OV_TYPE.MEANING
FROM FND_LOOKUP_VALUES OV_TYPE
WHERE OV_TYPE.LOOKUP_TYPE = 'GHG_RATE_OVERRIDE_TYPES'
AND OV_TYPE.LOOKUP_CODE = SC.RATE_OVERRIDE_TYPE
AND LANGUAGE = USERENV('LANG'))) RATE_OVERRIDE_TYPE_MEANING
, DECODE(SC.ITEM_TYPE
, NULL
, NULL
, (SELECT ITEM_TYPE.MEANING
FROM FND_LOOKUP_VALUES ITEM_TYPE
WHERE ITEM_TYPE.LOOKUP_TYPE = 'GHG_ITEM_TYPE'
AND ITEM_TYPE.LOOKUP_CODE = SC.ITEM_TYPE
AND LANGUAGE = USERENV('LANG'))) ITEM_TYPE_MEANING
, DECODE(SC.SUPPLIER_TYPE
, NULL
, NULL
, (SELECT SUPPLIER_TYPE.MEANING
FROM FND_LOOKUP_VALUES SUPPLIER_TYPE
WHERE SUPPLIER_TYPE.LOOKUP_TYPE = 'GHG_SUPPLIER_TYPES'
AND SUPPLIER_TYPE.LOOKUP_CODE = SC.SUPPLIER_TYPE
AND LANGUAGE = USERENV('LANG'))) SUPPLIER_TYPE_MEANING
, GHG_ORGS.GHG_ORGANIZATION_CODE
, GHG_ORGS.DESCRIPTION
FROM GHG_SOURCE_COMBINATIONS_ALL SC
, FND_LOOKUP_VALUES SCOPE
, FND_LOOKUP_VALUES METHOD
, FND_LOOKUP_VALUES TRANS_TYPE
, FND_LOOKUP_VALUES LOC
, AP_SUPPLIERS SUP
, PO_VENDOR_SITES SUP_SITE
, (SELECT DISTINCT OOD.OPERATING_UNIT ORG_ID
, MSI.INVENTORY_ITEM_ID ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NUMBER
, MSI.DESCRIPTION ITEM_DESCRIPTION
FROM ORG_ORGANIZATION_DEFINITIONS OOD
, MTL_SYSTEM_ITEMS_KFV MSI
, MTL_UNITS_OF_MEASURE_VL MUOM
WHERE MSI.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND NVL(MSI.APPROVAL_STATUS
, 'A') = 'A'
AND MUOM.UNIT_OF_MEASURE = MSI.PRIMARY_UNIT_OF_MEASURE) ITEM_DETAILS
, GHG_ORGANIZATIONS_ALL GHG_ORGS
WHERE SC.SCOPE_LOOKUP_CODE = SCOPE.LOOKUP_CODE
AND SCOPE.LOOKUP_TYPE = 'GHG_EMISSION_SCOPE'
AND SCOPE.LANGUAGE = USERENV('LANG')
AND SC.METHOD_LOOKUP_CODE = METHOD.LOOKUP_CODE
AND METHOD.LOOKUP_TYPE = 'GHG_METHOD_TYPE'
AND METHOD.LANGUAGE = USERENV('LANG')
AND SC.TRANSPORT_TYPE_LOOKUP_CODE = TRANS_TYPE.LOOKUP_CODE
AND TRANS_TYPE.LOOKUP_TYPE = 'GHG_TRANSPORT_TYPE'
AND TRANS_TYPE.LANGUAGE = USERENV('LANG')
AND SC.LOCATION_CODE = LOC.LOOKUP_CODE
AND LOC.LOOKUP_TYPE = 'GHG_LOCATION'
AND LOC.LANGUAGE = USERENV('LANG')
AND SC.SUPPLIER_ID = SUP.VENDOR_ID (+)
AND SC.SUPPLIER_ID = SUP_SITE.VENDOR_ID (+)
AND SC.SUPPLIER_SITE_ID = SUP_SITE.VENDOR_SITE_ID (+)
AND SC.ORG_ID = ITEM_DETAILS.ORG_ID (+)
AND SC.ITEM_ID = ITEM_DETAILS.ITEM_ID (+)
AND SC.GHG_ORGANIZATION_ID = GHG_ORGS.GHG_ORGANIZATION_ID (+)