VIEW: APPS.OZF_SD_REQUEST_HEADERS_ALL_VL

Source

View Text - Preformatted

SELECT B.ROWID as ROW_ID , B.REQUEST_HEADER_ID , B.OBJECT_VERSION_NUMBER , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.CREATION_DATE , B.CREATED_BY , B.LAST_UPDATE_LOGIN , B.REQUEST_ID , B.PROGRAM_APPLICATION_ID , B.PROGRAM_UPDATE_DATE , B.PROGRAM_ID , B.CREATED_FROM , B.REQUEST_NUMBER , B.REQUEST_CLASS , B.REQUEST_TYPE_SETUP_ID , B.OFFER_TYPE , B.OFFER_ID , B.ROOT_REQUEST_HEADER_ID , B.LINKED_REQUEST_HEADER_ID , B.REQUEST_START_DATE , B.REQUEST_END_DATE , B.USER_STATUS_ID , B.REQUEST_OUTCOME , B.DECLINE_REASON_CODE , B.RETURN_REASON_CODE , B.REQUEST_CURRENCY_CODE , B.AUTHORIZATION_NUMBER , B.REQUESTED_BUDGET_AMOUNT , B.APPROVED_BUDGET_AMOUNT , B.ATTRIBUTE_CATEGORY , B.ATTRIBUTE1 , B.ATTRIBUTE2 , B.ATTRIBUTE3 , B.ATTRIBUTE4 , B.ATTRIBUTE5 , B.ATTRIBUTE6 , B.ATTRIBUTE7 , B.ATTRIBUTE8 , B.ATTRIBUTE9 , B.ATTRIBUTE10 , B.ATTRIBUTE11 , B.ATTRIBUTE12 , B.ATTRIBUTE13 , B.ATTRIBUTE14 , B.ATTRIBUTE15 , B.SUPPLIER_ID , B.SUPPLIER_SITE_ID , B.SUPPLIER_CONTACT_ID , B.INTERNAL_SUBMISSION_DATE , B.ASIGNEE_RESPONSE_BY_DATE , B.ASIGNEE_RESPONSE_DATE , B.SUBMTD_BY_FOR_SUPP_APPROVAL , B.SUPPLIER_RESPONSE_BY_DATE , B.SUPPLIER_RESPONSE_DATE , B.SUPPLIER_SUBMISSION_DATE , B.REQUESTOR_ID , B.SUPPLIER_QUOTE_NUMBER , B.INTERNAL_ORDER_NUMBER , B.SALES_ORDER_CURRENCY , B.REQUEST_SOURCE , B.ASIGNEE_RESOURCE_ID , B.ORG_ID , B.SECURITY_GROUP_ID , B.ACCRUAL_TYPE , B.CUST_ACCOUNT_ID , B.SUPPLIER_CONTACT_EMAIL_ADDRESS , B.SUPPLIER_CONTACT_PHONE_NUMBER , B.REQUEST_BASIS , B.SUPPLIER_CONTACT_NAME, TL.REQUEST_DESCRIPTION FROM OZF_SD_REQUEST_HEADERS B, OZF_SD_REQUEST_HEADERS_ALL_TL TL WHERE B.REQUEST_HEADER_ID = TL.REQUEST_HEADER_ID AND TL.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT B.ROWID AS ROW_ID
, B.REQUEST_HEADER_ID
, B.OBJECT_VERSION_NUMBER
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.REQUEST_ID
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_UPDATE_DATE
, B.PROGRAM_ID
, B.CREATED_FROM
, B.REQUEST_NUMBER
, B.REQUEST_CLASS
, B.REQUEST_TYPE_SETUP_ID
, B.OFFER_TYPE
, B.OFFER_ID
, B.ROOT_REQUEST_HEADER_ID
, B.LINKED_REQUEST_HEADER_ID
, B.REQUEST_START_DATE
, B.REQUEST_END_DATE
, B.USER_STATUS_ID
, B.REQUEST_OUTCOME
, B.DECLINE_REASON_CODE
, B.RETURN_REASON_CODE
, B.REQUEST_CURRENCY_CODE
, B.AUTHORIZATION_NUMBER
, B.REQUESTED_BUDGET_AMOUNT
, B.APPROVED_BUDGET_AMOUNT
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.SUPPLIER_ID
, B.SUPPLIER_SITE_ID
, B.SUPPLIER_CONTACT_ID
, B.INTERNAL_SUBMISSION_DATE
, B.ASIGNEE_RESPONSE_BY_DATE
, B.ASIGNEE_RESPONSE_DATE
, B.SUBMTD_BY_FOR_SUPP_APPROVAL
, B.SUPPLIER_RESPONSE_BY_DATE
, B.SUPPLIER_RESPONSE_DATE
, B.SUPPLIER_SUBMISSION_DATE
, B.REQUESTOR_ID
, B.SUPPLIER_QUOTE_NUMBER
, B.INTERNAL_ORDER_NUMBER
, B.SALES_ORDER_CURRENCY
, B.REQUEST_SOURCE
, B.ASIGNEE_RESOURCE_ID
, B.ORG_ID
, B.SECURITY_GROUP_ID
, B.ACCRUAL_TYPE
, B.CUST_ACCOUNT_ID
, B.SUPPLIER_CONTACT_EMAIL_ADDRESS
, B.SUPPLIER_CONTACT_PHONE_NUMBER
, B.REQUEST_BASIS
, B.SUPPLIER_CONTACT_NAME
, TL.REQUEST_DESCRIPTION
FROM OZF_SD_REQUEST_HEADERS B
, OZF_SD_REQUEST_HEADERS_ALL_TL TL
WHERE B.REQUEST_HEADER_ID = TL.REQUEST_HEADER_ID
AND TL.LANGUAGE = USERENV('LANG')