VIEW: APPS.AST_WEB_SWITCH_DETAILS_V

Source

View Text - Preformatted

SELECT SD.ROWID, CS.CGI_SWITCH_ID, CS.QUERY_STRING_ID, CS.SWITCH_CODE, CS.SWITCH_TYPE, CS.IS_REQUIRED_YN, CS.SORT_ORDER, CS.DATA_SEPARATOR, SD.SWITCH_DATA_ID, SD.ENABLED_FLAG, SD.FIRST_NAME_YN, SD.LAST_NAME_YN, SD.CITY_YN, SD.STATE_YN, SD.ZIP_YN, SD.COUNTRY_YN, SD.ADDRESS_YN, SD.LAST_UPDATE_DATE, SD.LAST_UPDATED_BY, SD.CREATION_DATE, SD.CREATED_BY, SD.LAST_UPDATE_LOGIN, SD.ATTRIBUTE_CATEGORY, SD.ATTRIBUTE1, SD.ATTRIBUTE2, SD.ATTRIBUTE3, SD.ATTRIBUTE4, SD.ATTRIBUTE5, SD.ATTRIBUTE6, SD.ATTRIBUTE7, SD.ATTRIBUTE8, SD.ATTRIBUTE9, SD.ATTRIBUTE10, SD.ATTRIBUTE11, SD.ATTRIBUTE12, SD.ATTRIBUTE13, SD.ATTRIBUTE14, SD.ATTRIBUTE15 FROM AST_CGI_SWITCHES CS,AST_SWITCH_DATA SD WHERE CS.CGI_SWITCH_ID = SD.CGI_SWITCH_ID

View Text - HTML Formatted

SELECT SD.ROWID
, CS.CGI_SWITCH_ID
, CS.QUERY_STRING_ID
, CS.SWITCH_CODE
, CS.SWITCH_TYPE
, CS.IS_REQUIRED_YN
, CS.SORT_ORDER
, CS.DATA_SEPARATOR
, SD.SWITCH_DATA_ID
, SD.ENABLED_FLAG
, SD.FIRST_NAME_YN
, SD.LAST_NAME_YN
, SD.CITY_YN
, SD.STATE_YN
, SD.ZIP_YN
, SD.COUNTRY_YN
, SD.ADDRESS_YN
, SD.LAST_UPDATE_DATE
, SD.LAST_UPDATED_BY
, SD.CREATION_DATE
, SD.CREATED_BY
, SD.LAST_UPDATE_LOGIN
, SD.ATTRIBUTE_CATEGORY
, SD.ATTRIBUTE1
, SD.ATTRIBUTE2
, SD.ATTRIBUTE3
, SD.ATTRIBUTE4
, SD.ATTRIBUTE5
, SD.ATTRIBUTE6
, SD.ATTRIBUTE7
, SD.ATTRIBUTE8
, SD.ATTRIBUTE9
, SD.ATTRIBUTE10
, SD.ATTRIBUTE11
, SD.ATTRIBUTE12
, SD.ATTRIBUTE13
, SD.ATTRIBUTE14
, SD.ATTRIBUTE15
FROM AST_CGI_SWITCHES CS
, AST_SWITCH_DATA SD
WHERE CS.CGI_SWITCH_ID = SD.CGI_SWITCH_ID