VIEW: APPS.GHG_ORGANIZATIONS_V

Source

View Text - Preformatted

SELECT xnfa.rowid row_id, xnfa.GHG_ORGANIZATION_ID, xnfa.GHG_ORGANIZATION_CODE, xnfa.description, xnfa.ORGANIZATION_SIZE_LOOKUP_CODE, xnfa.location_id, hl.location_code, xnfa.start_date, xnfa.end_date, xnfa.attribute1, xnfa.attribute2, xnfa.attribute3, xnfa.attribute4, xnfa.attribute5, xnfa.attribute6, xnfa.attribute7, xnfa.attribute8, xnfa.attribute9, xnfa.attribute10, xnfa.attribute11, xnfa.attribute12, xnfa.attribute13, xnfa.attribute14, xnfa.attribute15, xnfa.attribute16, xnfa.attribute17, xnfa.attribute18, xnfa.attribute19, xnfa.attribute20, xnfa.attribute_category, xnfa.org_id, xnfa.set_of_books_id, xnfa.created_by, xnfa.creation_date, xnfa.last_updated_by, xnfa.last_update_date, xnfa.last_update_login, xnfa.latitude, xnfa.longitude, xnfa.ORGANIZATION_TYPE, xxn.meaning ORGANIZATION_type_description, xnfa.allow_transactions, xnfa.ceo_name, xnfa.COMPANY_IDENTIFIER FROM GHG_ORGANIZATIONS xnfa, hr_locations_v hl, FND_lookup_values xxn WHERE hl.location_id = xnfa.location_id AND xxn.lookup_type = 'GHG_ORGANIZATION_TYPES' AND xxn.lookup_code = xnfa.ORGANIZATION_TYPE AND LANGUAGE = UserEnv('LANG')

View Text - HTML Formatted

SELECT XNFA.ROWID ROW_ID
, XNFA.GHG_ORGANIZATION_ID
, XNFA.GHG_ORGANIZATION_CODE
, XNFA.DESCRIPTION
, XNFA.ORGANIZATION_SIZE_LOOKUP_CODE
, XNFA.LOCATION_ID
, HL.LOCATION_CODE
, XNFA.START_DATE
, XNFA.END_DATE
, XNFA.ATTRIBUTE1
, XNFA.ATTRIBUTE2
, XNFA.ATTRIBUTE3
, XNFA.ATTRIBUTE4
, XNFA.ATTRIBUTE5
, XNFA.ATTRIBUTE6
, XNFA.ATTRIBUTE7
, XNFA.ATTRIBUTE8
, XNFA.ATTRIBUTE9
, XNFA.ATTRIBUTE10
, XNFA.ATTRIBUTE11
, XNFA.ATTRIBUTE12
, XNFA.ATTRIBUTE13
, XNFA.ATTRIBUTE14
, XNFA.ATTRIBUTE15
, XNFA.ATTRIBUTE16
, XNFA.ATTRIBUTE17
, XNFA.ATTRIBUTE18
, XNFA.ATTRIBUTE19
, XNFA.ATTRIBUTE20
, XNFA.ATTRIBUTE_CATEGORY
, XNFA.ORG_ID
, XNFA.SET_OF_BOOKS_ID
, XNFA.CREATED_BY
, XNFA.CREATION_DATE
, XNFA.LAST_UPDATED_BY
, XNFA.LAST_UPDATE_DATE
, XNFA.LAST_UPDATE_LOGIN
, XNFA.LATITUDE
, XNFA.LONGITUDE
, XNFA.ORGANIZATION_TYPE
, XXN.MEANING ORGANIZATION_TYPE_DESCRIPTION
, XNFA.ALLOW_TRANSACTIONS
, XNFA.CEO_NAME
, XNFA.COMPANY_IDENTIFIER
FROM GHG_ORGANIZATIONS XNFA
, HR_LOCATIONS_V HL
, FND_LOOKUP_VALUES XXN
WHERE HL.LOCATION_ID = XNFA.LOCATION_ID
AND XXN.LOOKUP_TYPE = 'GHG_ORGANIZATION_TYPES'
AND XXN.LOOKUP_CODE = XNFA.ORGANIZATION_TYPE
AND LANGUAGE = USERENV('LANG')