eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: OZF.OZF_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, SHIP_FROM_STOCK_FLAG SHIP_FROM_STOCK_FLAG, REQUEST_CLASS REQUEST_CLASS, REQUEST_TYPE_CODE REQUEST_TYPE_CODE, BENEFIT_ID BENEFIT_ID, ACTIVITY_MEDIA_ID ACTIVITY_MEDIA_ID, SUBMITTED_BY SUBMITTED_BY, SUBMITTED_DATE SUBMITTED_DATE, PARTNER_CONTACT_ID PARTNER_CONTACT_ID, PARTNER_CONTACT_PHONE_NUMBER PARTNER_CONTACT_PHONE_NUMBER, PARTNER_CONTACT_EMAIL_ADDRESS PARTNER_CONTACT_EMAIL_ADDRESS, OFFER_TYPE OFFER_TYPE, OFFER_ID OFFER_ID, ROOT_REQUEST_HEADER_ID ROOT_REQUEST_HEADER_ID, LINKED_REQUEST_HEADER_ID LINKED_REQUEST_HEADER_ID, START_DATE START_DATE, END_DATE END_DATE, STATUS_CODE STATUS_CODE, REQUEST_OUTCOME REQUEST_OUTCOME, DECLINE_REASON_CODE DECLINE_REASON_CODE, RETURN_REASON_CODE RETURN_REASON_CODE, CURRENCY_CODE CURRENCY_CODE, PARTNER_AMOUNT PARTNER_AMOUNT, REQUESTED_AMOUNT REQUESTED_AMOUNT, APPROVED_AMOUNT APPROVED_AMOUNT, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE, EXCHANGE_RATE EXCHANGE_RATE, PARTNER_ACCTD_AMOUNT PARTNER_ACCTD_AMOUNT, REQUESTED_ACCTD_AMOUNT REQUESTED_ACCTD_AMOUNT, APPROVED_ACCTD_AMOUNT APPROVED_ACCTD_AMOUNT, APPROVED_BY APPROVED_BY, APPROVED_DATE APPROVED_DATE, AGREEMENT_NUMBER AGREEMENT_NUMBER, AUTHORIZATION_CODE AUTHORIZATION_CODE, PARTNER_ID PARTNER_ID, PARTNER_SITE_USE_ID PARTNER_SITE_USE_ID, END_CUST_PARTY_ID END_CUST_PARTY_ID, END_CUST_SITE_USE_ID END_CUST_SITE_USE_ID, END_CUST_DUNS_NUMBER END_CUST_DUNS_NUMBER, END_CUST_NAME END_CUST_NAME, END_CUST_ADDRESS1 END_CUST_ADDRESS1, END_CUST_ADDRESS2 END_CUST_ADDRESS2, END_CUST_ADDRESS3 END_CUST_ADDRESS3, END_CUST_ADDRESS4 END_CUST_ADDRESS4, END_CUST_CITY END_CUST_CITY, END_CUST_STATE END_CUST_STATE, END_CUST_PROVINCE END_CUST_PROVINCE, END_CUST_COUNTY END_CUST_COUNTY, END_CUST_POSTAL_CODE END_CUST_POSTAL_CODE, END_CUST_COUNTRY END_CUST_COUNTRY, END_CUST_ADDR_LINES_PHONETIC END_CUST_ADDR_LINES_PHONETIC, END_CUST_CONTACT_FIRST_NAME END_CUST_CONTACT_FIRST_NAME, END_CUST_CONTACT_LAST_NAME END_CUST_CONTACT_LAST_NAME, END_CUST_CONTACT_TITLE END_CUST_CONTACT_TITLE, END_CUST_CONTACT_EMAIL_ADDRESS END_CUST_CONTACT_EMAIL_ADDRESS, END_CUST_CONTACT_PHONE_TYPE END_CUST_CONTACT_PHONE_TYPE, END_CUST_CONTACT_PHONE_NUMBER END_CUST_CONTACT_PHONE_NUMBER, END_CUST_CONTACT_PHONE_EXTN END_CUST_CONTACT_PHONE_EXTN, RESELLER_PARTY_ID RESELLER_PARTY_ID, RESELLER_DUNS_NUMBER RESELLER_DUNS_NUMBER, RESELLER_SITE_USE_ID RESELLER_SITE_USE_ID, RESELLER_NAME RESELLER_NAME, RESELLER_ADDRESS1 RESELLER_ADDRESS1, RESELLER_ADDRESS2 RESELLER_ADDRESS2, RESELLER_ADDRESS3 RESELLER_ADDRESS3, RESELLER_ADDRESS4 RESELLER_ADDRESS4, RESELLER_COUNTY RESELLER_COUNTY, RESELLER_CITY RESELLER_CITY, RESELLER_STATE RESELLER_STATE, RESELLER_PROVINCE RESELLER_PROVINCE, RESELLER_POSTAL_CODE RESELLER_POSTAL_CODE, RESELLER_COUNTRY RESELLER_COUNTRY, RESELLER_ADDR_LINES_PHONETIC RESELLER_ADDR_LINES_PHONETIC, RESELLER_CONTACT_FIRST_NAME RESELLER_CONTACT_FIRST_NAME, RESELLER_CONTACT_LAST_NAME RESELLER_CONTACT_LAST_NAME, RESELLER_CONTACT_TITLE RESELLER_CONTACT_TITLE, RESELLER_CONTACT_EMAIL_ADDRESS RESELLER_CONTACT_EMAIL_ADDRESS, RESELLER_CONTACT_PHONE_TYPE RESELLER_CONTACT_PHONE_TYPE, RESELLER_CONTACT_PHONE_NUMBER RESELLER_CONTACT_PHONE_NUMBER, RESELLER_CONTACT_PHONE_EXTN RESELLER_CONTACT_PHONE_EXTN, CUSTOMER_MERGE_FLAG CUSTOMER_MERGE_FLAG, 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, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID from "OZF"."OZF_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
, SHIP_FROM_STOCK_FLAG SHIP_FROM_STOCK_FLAG
, REQUEST_CLASS REQUEST_CLASS
, REQUEST_TYPE_CODE REQUEST_TYPE_CODE
, BENEFIT_ID BENEFIT_ID
, ACTIVITY_MEDIA_ID ACTIVITY_MEDIA_ID
, SUBMITTED_BY SUBMITTED_BY
, SUBMITTED_DATE SUBMITTED_DATE
, PARTNER_CONTACT_ID PARTNER_CONTACT_ID
, PARTNER_CONTACT_PHONE_NUMBER PARTNER_CONTACT_PHONE_NUMBER
, PARTNER_CONTACT_EMAIL_ADDRESS PARTNER_CONTACT_EMAIL_ADDRESS
, OFFER_TYPE OFFER_TYPE
, OFFER_ID OFFER_ID
, ROOT_REQUEST_HEADER_ID ROOT_REQUEST_HEADER_ID
, LINKED_REQUEST_HEADER_ID LINKED_REQUEST_HEADER_ID
, START_DATE START_DATE
, END_DATE END_DATE
, STATUS_CODE STATUS_CODE
, REQUEST_OUTCOME REQUEST_OUTCOME
, DECLINE_REASON_CODE DECLINE_REASON_CODE
, RETURN_REASON_CODE RETURN_REASON_CODE
, CURRENCY_CODE CURRENCY_CODE
, PARTNER_AMOUNT PARTNER_AMOUNT
, REQUESTED_AMOUNT REQUESTED_AMOUNT
, APPROVED_AMOUNT APPROVED_AMOUNT
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, PARTNER_ACCTD_AMOUNT PARTNER_ACCTD_AMOUNT
, REQUESTED_ACCTD_AMOUNT REQUESTED_ACCTD_AMOUNT
, APPROVED_ACCTD_AMOUNT APPROVED_ACCTD_AMOUNT
, APPROVED_BY APPROVED_BY
, APPROVED_DATE APPROVED_DATE
, AGREEMENT_NUMBER AGREEMENT_NUMBER
, AUTHORIZATION_CODE AUTHORIZATION_CODE
, PARTNER_ID PARTNER_ID
, PARTNER_SITE_USE_ID PARTNER_SITE_USE_ID
, END_CUST_PARTY_ID END_CUST_PARTY_ID
, END_CUST_SITE_USE_ID END_CUST_SITE_USE_ID
, END_CUST_DUNS_NUMBER END_CUST_DUNS_NUMBER
, END_CUST_NAME END_CUST_NAME
, END_CUST_ADDRESS1 END_CUST_ADDRESS1
, END_CUST_ADDRESS2 END_CUST_ADDRESS2
, END_CUST_ADDRESS3 END_CUST_ADDRESS3
, END_CUST_ADDRESS4 END_CUST_ADDRESS4
, END_CUST_CITY END_CUST_CITY
, END_CUST_STATE END_CUST_STATE
, END_CUST_PROVINCE END_CUST_PROVINCE
, END_CUST_COUNTY END_CUST_COUNTY
, END_CUST_POSTAL_CODE END_CUST_POSTAL_CODE
, END_CUST_COUNTRY END_CUST_COUNTRY
, END_CUST_ADDR_LINES_PHONETIC END_CUST_ADDR_LINES_PHONETIC
, END_CUST_CONTACT_FIRST_NAME END_CUST_CONTACT_FIRST_NAME
, END_CUST_CONTACT_LAST_NAME END_CUST_CONTACT_LAST_NAME
, END_CUST_CONTACT_TITLE END_CUST_CONTACT_TITLE
, END_CUST_CONTACT_EMAIL_ADDRESS END_CUST_CONTACT_EMAIL_ADDRESS
, END_CUST_CONTACT_PHONE_TYPE END_CUST_CONTACT_PHONE_TYPE
, END_CUST_CONTACT_PHONE_NUMBER END_CUST_CONTACT_PHONE_NUMBER
, END_CUST_CONTACT_PHONE_EXTN END_CUST_CONTACT_PHONE_EXTN
, RESELLER_PARTY_ID RESELLER_PARTY_ID
, RESELLER_DUNS_NUMBER RESELLER_DUNS_NUMBER
, RESELLER_SITE_USE_ID RESELLER_SITE_USE_ID
, RESELLER_NAME RESELLER_NAME
, RESELLER_ADDRESS1 RESELLER_ADDRESS1
, RESELLER_ADDRESS2 RESELLER_ADDRESS2
, RESELLER_ADDRESS3 RESELLER_ADDRESS3
, RESELLER_ADDRESS4 RESELLER_ADDRESS4
, RESELLER_COUNTY RESELLER_COUNTY
, RESELLER_CITY RESELLER_CITY
, RESELLER_STATE RESELLER_STATE
, RESELLER_PROVINCE RESELLER_PROVINCE
, RESELLER_POSTAL_CODE RESELLER_POSTAL_CODE
, RESELLER_COUNTRY RESELLER_COUNTRY
, RESELLER_ADDR_LINES_PHONETIC RESELLER_ADDR_LINES_PHONETIC
, RESELLER_CONTACT_FIRST_NAME RESELLER_CONTACT_FIRST_NAME
, RESELLER_CONTACT_LAST_NAME RESELLER_CONTACT_LAST_NAME
, RESELLER_CONTACT_TITLE RESELLER_CONTACT_TITLE
, RESELLER_CONTACT_EMAIL_ADDRESS RESELLER_CONTACT_EMAIL_ADDRESS
, RESELLER_CONTACT_PHONE_TYPE RESELLER_CONTACT_PHONE_TYPE
, RESELLER_CONTACT_PHONE_NUMBER RESELLER_CONTACT_PHONE_NUMBER
, RESELLER_CONTACT_PHONE_EXTN RESELLER_CONTACT_PHONE_EXTN
, CUSTOMER_MERGE_FLAG CUSTOMER_MERGE_FLAG
, 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
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "OZF"."OZF_REQUEST_HEADERS_ALL_B"