VIEW: OZF.OZF_SD_REQUEST_HEADERS_ALL_B#

Source

View Text - Preformatted

select REQUEST_HEADER_ID REQUEST_HEADER_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_ID PROGRAM_ID, CREATED_FROM CREATED_FROM, REQUEST_NUMBER REQUEST_NUMBER, REQUEST_CLASS REQUEST_CLASS, OFFER_TYPE OFFER_TYPE, OFFER_ID OFFER_ID, ROOT_REQUEST_HEADER_ID ROOT_REQUEST_HEADER_ID, LINKED_REQUEST_HEADER_ID LINKED_REQUEST_HEADER_ID, REQUEST_START_DATE REQUEST_START_DATE, REQUEST_END_DATE REQUEST_END_DATE, REQUEST_OUTCOME REQUEST_OUTCOME, DECLINE_REASON_CODE DECLINE_REASON_CODE, RETURN_REASON_CODE RETURN_REASON_CODE, REQUEST_CURRENCY_CODE REQUEST_CURRENCY_CODE, AUTHORIZATION_NUMBER AUTHORIZATION_NUMBER, REQUESTED_BUDGET_AMOUNT REQUESTED_BUDGET_AMOUNT, APPROVED_BUDGET_AMOUNT APPROVED_BUDGET_AMOUNT, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_CONTACT_ID SUPPLIER_CONTACT_ID, INTERNAL_SUBMISSION_DATE INTERNAL_SUBMISSION_DATE, ASIGNEE_RESPONSE_BY_DATE ASIGNEE_RESPONSE_BY_DATE, ASIGNEE_RESPONSE_DATE ASIGNEE_RESPONSE_DATE, SUBMTD_BY_FOR_SUPP_APPROVAL SUBMTD_BY_FOR_SUPP_APPROVAL, SUPPLIER_RESPONSE_BY_DATE SUPPLIER_RESPONSE_BY_DATE, SUPPLIER_RESPONSE_DATE SUPPLIER_RESPONSE_DATE, SUPPLIER_SUBMISSION_DATE SUPPLIER_SUBMISSION_DATE, REQUESTOR_ID REQUESTOR_ID, SUPPLIER_QUOTE_NUMBER SUPPLIER_QUOTE_NUMBER, INTERNAL_ORDER_NUMBER INTERNAL_ORDER_NUMBER, SALES_ORDER_CURRENCY SALES_ORDER_CURRENCY, REQUEST_SOURCE REQUEST_SOURCE, ASIGNEE_RESOURCE_ID ASIGNEE_RESOURCE_ID, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, ACCRUAL_TYPE ACCRUAL_TYPE, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, SUPPLIER_CONTACT_EMAIL_ADDRESS SUPPLIER_CONTACT_EMAIL_ADDRESS, SUPPLIER_CONTACT_PHONE_NUMBER SUPPLIER_CONTACT_PHONE_NUMBER, REQUEST_TYPE_SETUP_ID REQUEST_TYPE_SETUP_ID, REQUEST_BASIS REQUEST_BASIS, USER_STATUS_ID USER_STATUS_ID, SUPPLIER_CONTACT_NAME SUPPLIER_CONTACT_NAME from "OZF"."OZF_SD_REQUEST_HEADERS_ALL_B"

View Text - HTML Formatted

SELECT REQUEST_HEADER_ID REQUEST_HEADER_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_ID PROGRAM_ID
, CREATED_FROM CREATED_FROM
, REQUEST_NUMBER REQUEST_NUMBER
, REQUEST_CLASS REQUEST_CLASS
, OFFER_TYPE OFFER_TYPE
, OFFER_ID OFFER_ID
, ROOT_REQUEST_HEADER_ID ROOT_REQUEST_HEADER_ID
, LINKED_REQUEST_HEADER_ID LINKED_REQUEST_HEADER_ID
, REQUEST_START_DATE REQUEST_START_DATE
, REQUEST_END_DATE REQUEST_END_DATE
, REQUEST_OUTCOME REQUEST_OUTCOME
, DECLINE_REASON_CODE DECLINE_REASON_CODE
, RETURN_REASON_CODE RETURN_REASON_CODE
, REQUEST_CURRENCY_CODE REQUEST_CURRENCY_CODE
, AUTHORIZATION_NUMBER AUTHORIZATION_NUMBER
, REQUESTED_BUDGET_AMOUNT REQUESTED_BUDGET_AMOUNT
, APPROVED_BUDGET_AMOUNT APPROVED_BUDGET_AMOUNT
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_CONTACT_ID SUPPLIER_CONTACT_ID
, INTERNAL_SUBMISSION_DATE INTERNAL_SUBMISSION_DATE
, ASIGNEE_RESPONSE_BY_DATE ASIGNEE_RESPONSE_BY_DATE
, ASIGNEE_RESPONSE_DATE ASIGNEE_RESPONSE_DATE
, SUBMTD_BY_FOR_SUPP_APPROVAL SUBMTD_BY_FOR_SUPP_APPROVAL
, SUPPLIER_RESPONSE_BY_DATE SUPPLIER_RESPONSE_BY_DATE
, SUPPLIER_RESPONSE_DATE SUPPLIER_RESPONSE_DATE
, SUPPLIER_SUBMISSION_DATE SUPPLIER_SUBMISSION_DATE
, REQUESTOR_ID REQUESTOR_ID
, SUPPLIER_QUOTE_NUMBER SUPPLIER_QUOTE_NUMBER
, INTERNAL_ORDER_NUMBER INTERNAL_ORDER_NUMBER
, SALES_ORDER_CURRENCY SALES_ORDER_CURRENCY
, REQUEST_SOURCE REQUEST_SOURCE
, ASIGNEE_RESOURCE_ID ASIGNEE_RESOURCE_ID
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ACCRUAL_TYPE ACCRUAL_TYPE
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, SUPPLIER_CONTACT_EMAIL_ADDRESS SUPPLIER_CONTACT_EMAIL_ADDRESS
, SUPPLIER_CONTACT_PHONE_NUMBER SUPPLIER_CONTACT_PHONE_NUMBER
, REQUEST_TYPE_SETUP_ID REQUEST_TYPE_SETUP_ID
, REQUEST_BASIS REQUEST_BASIS
, USER_STATUS_ID USER_STATUS_ID
, SUPPLIER_CONTACT_NAME SUPPLIER_CONTACT_NAME
FROM "OZF"."OZF_SD_REQUEST_HEADERS_ALL_B"