VIEW: APPS.ASO_OA_QUOTE_ACCESSES_V

Source

View Text - Preformatted

SELECT aqa.access_id, aqa.quote_number, aqa.resource_id, aqa.resource_grp_id, aqa.created_by, aqa.creation_date, aqa.last_updated_by, aqa.last_update_login, aqa.last_update_date, aqa.request_id, aqa.program_application_id, aqa.program_id, aqa.program_update_date, aqa.keep_flag, aqa.update_access_flag, aqa.created_by_tap_flag, aqa.attribute_category, aqa.attribute1, aqa.attribute2, aqa.attribute3, aqa.attribute4, aqa.attribute5, aqa.attribute6, aqa.attribute7, aqa.attribute8, aqa.attribute9, aqa.attribute10, aqa.attribute12, aqa.attribute13, aqa.attribute14, aqa.attribute15, aqa.security_group_id, aqa.attribute11, aqa.territory_id, aqa.territory_source_flag, aqa.role_id, aqa.object_version_number, aqa.attribute16, aqa.attribute17, aqa.attribute18, aqa.attribute19, aqa.attribute20, 'S', aqh.quote_header_id from aso_quote_accesses aqa, aso_quote_headers_all aqh WHERE aqa.quote_number = aqh.quote_number

View Text - HTML Formatted

SELECT AQA.ACCESS_ID
, AQA.QUOTE_NUMBER
, AQA.RESOURCE_ID
, AQA.RESOURCE_GRP_ID
, AQA.CREATED_BY
, AQA.CREATION_DATE
, AQA.LAST_UPDATED_BY
, AQA.LAST_UPDATE_LOGIN
, AQA.LAST_UPDATE_DATE
, AQA.REQUEST_ID
, AQA.PROGRAM_APPLICATION_ID
, AQA.PROGRAM_ID
, AQA.PROGRAM_UPDATE_DATE
, AQA.KEEP_FLAG
, AQA.UPDATE_ACCESS_FLAG
, AQA.CREATED_BY_TAP_FLAG
, AQA.ATTRIBUTE_CATEGORY
, AQA.ATTRIBUTE1
, AQA.ATTRIBUTE2
, AQA.ATTRIBUTE3
, AQA.ATTRIBUTE4
, AQA.ATTRIBUTE5
, AQA.ATTRIBUTE6
, AQA.ATTRIBUTE7
, AQA.ATTRIBUTE8
, AQA.ATTRIBUTE9
, AQA.ATTRIBUTE10
, AQA.ATTRIBUTE12
, AQA.ATTRIBUTE13
, AQA.ATTRIBUTE14
, AQA.ATTRIBUTE15
, AQA.SECURITY_GROUP_ID
, AQA.ATTRIBUTE11
, AQA.TERRITORY_ID
, AQA.TERRITORY_SOURCE_FLAG
, AQA.ROLE_ID
, AQA.OBJECT_VERSION_NUMBER
, AQA.ATTRIBUTE16
, AQA.ATTRIBUTE17
, AQA.ATTRIBUTE18
, AQA.ATTRIBUTE19
, AQA.ATTRIBUTE20
, 'S'
, AQH.QUOTE_HEADER_ID
FROM ASO_QUOTE_ACCESSES AQA
, ASO_QUOTE_HEADERS_ALL AQH
WHERE AQA.QUOTE_NUMBER = AQH.QUOTE_NUMBER