DBA Data[Home] [Help] [Dependency Information]

TABLE: OZF.OZF_REQUEST_HEADERS_ALL_B

Object Details
Object Name: OZF_REQUEST_HEADERS_ALL_B
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_REQUEST_HEADERS_ALL_B
Subobject Name:
Status: VALID


This table stores the request headers information for soft fund and special pricing


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_REQUEST_HEADERS_ALL_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_HEADER_ID
OZF_REQUEST_HEADERS_ALL_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_CLASS
OZF_REQUEST_HEADERS_ALL_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREQUEST_NUMBER
OZF_REQUEST_HEADERS_ALL_B_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOFFER_ID
OZF_REQUEST_HEADERS_ALL_B_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTNER_ID
OZF_REQUEST_HEADERS_ALL_B_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROOT_REQUEST_HEADER_ID
OZF_REQUEST_HEADERS_ALL_B_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAGREEMENT_NUMBER
Columns
Name Datatype Length Mandatory Comments
REQUEST_HEADER_ID NUMBER
Yes Unique Identifier
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number used for database locking control when using HTML as a user interface
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
REQUEST_ID NUMBER

Standard WHO column
PROGRAM_APPLICATION_ID NUMBER

Standard WHO column
PROGRAM_UPDATE_DATE DATE

Standard WHO column
PROGRAM_ID NUMBER

Standard WHO column
CREATED_FROM VARCHAR2 (30)
Standard WHO column
REQUEST_NUMBER VARCHAR2 (30) Yes Request Number
SHIP_FROM_STOCK_FLAG VARCHAR2 (1)
Indicates if the Stock would be shipped from Partner or Reseller
REQUEST_CLASS VARCHAR2 (30)
Request classification
REQUEST_TYPE_CODE VARCHAR2 (30)
Request Type Code
BENEFIT_ID NUMBER

Benefit Identifier
ACTIVITY_MEDIA_ID NUMBER

Marketing Activity Identifier
SUBMITTED_BY NUMBER

Resource Submitting the Request
SUBMITTED_DATE DATE

Date Request is Submitted
PARTNER_CONTACT_ID NUMBER

Partner Requestor Resource Identifier
PARTNER_CONTACT_PHONE_NUMBER VARCHAR2 (40)
Partner Contact Phone Number
PARTNER_CONTACT_EMAIL_ADDRESS VARCHAR2 (2000)
Partner Contact Email Address
OFFER_TYPE VARCHAR2 (30)
Promotional Offer Type
OFFER_ID NUMBER

Promotional Offer Identifier
ROOT_REQUEST_HEADER_ID NUMBER

Root Request Header Identifier
LINKED_REQUEST_HEADER_ID NUMBER

Identifier of the Similar Request linked to this Request
START_DATE DATE

Request start date
END_DATE DATE

Request end date
STATUS_CODE VARCHAR2 (30) Yes Status Code of the Request
REQUEST_OUTCOME VARCHAR2 (30)
Outcome code for the Request
DECLINE_REASON_CODE VARCHAR2 (30)
Reason Code for Declining a Request
RETURN_REASON_CODE VARCHAR2 (30)
Reason Code for Returning a Request back to filer
CURRENCY_CODE VARCHAR2 (30)
Currency Code
PARTNER_AMOUNT NUMBER

Partner Contribution Amount for Partner Funds
REQUESTED_AMOUNT NUMBER

Requested Amount
APPROVED_AMOUNT NUMBER

Approved Amount
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Exchange Rate Type
EXCHANGE_RATE_DATE DATE

Exchange Rate Date
EXCHANGE_RATE NUMBER

Exchange Rate
PARTNER_ACCTD_AMOUNT NUMBER

Partner amount in account currency
REQUESTED_ACCTD_AMOUNT NUMBER

Requested amount in account currency
APPROVED_ACCTD_AMOUNT NUMBER

Approved amount in account currency
APPROVED_BY NUMBER

Last Approver
APPROVED_DATE DATE

Last Approval Date
AGREEMENT_NUMBER VARCHAR2 (30)
Deal Number
AUTHORIZATION_CODE VARCHAR2 (30)
Authorization Code (Offer Code)
PARTNER_ID NUMBER
Yes Partner Identifier
PARTNER_SITE_USE_ID NUMBER

Partner Location Identifier
END_CUST_PARTY_ID NUMBER

End Customer Party Identifier
END_CUST_SITE_USE_ID NUMBER

End Customer Location Identifier
END_CUST_DUNS_NUMBER NUMBER

Duns number for end customer
END_CUST_NAME VARCHAR2 (240)
End Customer Name
END_CUST_ADDRESS1 VARCHAR2 (240)
End Customer Address
END_CUST_ADDRESS2 VARCHAR2 (240)
End Customer Address
END_CUST_ADDRESS3 VARCHAR2 (240)
End Customer Address
END_CUST_ADDRESS4 VARCHAR2 (240)
End Customer Address
END_CUST_CITY VARCHAR2 (60)
End Customer City
END_CUST_STATE VARCHAR2 (60)
End Customer State
END_CUST_PROVINCE VARCHAR2 (60)
End Customer Province
END_CUST_COUNTY VARCHAR2 (60)
End Customer county
END_CUST_POSTAL_CODE VARCHAR2 (60)
End Customer Postal Code
END_CUST_COUNTRY VARCHAR2 (60)
End Customer Country
END_CUST_ADDR_LINES_PHONETIC VARCHAR2 (560)
End Customer Address Lines Phoenetic
END_CUST_CONTACT_FIRST_NAME VARCHAR2 (150)
End Customer Contact First Name
END_CUST_CONTACT_LAST_NAME VARCHAR2 (150)
End Customer Contact Last Name
END_CUST_CONTACT_TITLE VARCHAR2 (60)
End Customer Contact title
END_CUST_CONTACT_EMAIL_ADDRESS VARCHAR2 (2000)
End Customer Contact Email Address
END_CUST_CONTACT_PHONE_TYPE VARCHAR2 (30)
End Customer Contact Phone Type
END_CUST_CONTACT_PHONE_NUMBER VARCHAR2 (40)
End Customer Contact Phone Number
END_CUST_CONTACT_PHONE_EXTN VARCHAR2 (20)
End Customer Contact Phone Extension
RESELLER_PARTY_ID NUMBER

Reseller Party Identifier
RESELLER_DUNS_NUMBER NUMBER

Reseller Duns Number
RESELLER_SITE_USE_ID NUMBER

Reseller Location Identifier
RESELLER_NAME VARCHAR2 (240)
Reseller name
RESELLER_ADDRESS1 VARCHAR2 (240)
Reseller Address
RESELLER_ADDRESS2 VARCHAR2 (240)
Reseller Address
RESELLER_ADDRESS3 VARCHAR2 (240)
Reseller Address
RESELLER_ADDRESS4 VARCHAR2 (240)
Reseller Address
RESELLER_COUNTY VARCHAR2 (60)
Reseller county
RESELLER_CITY VARCHAR2 (60)
Reseller City
RESELLER_STATE VARCHAR2 (60)
Reseller State
RESELLER_PROVINCE VARCHAR2 (240)
Reseller Province
RESELLER_POSTAL_CODE VARCHAR2 (60)
Reseller Postal Code
RESELLER_COUNTRY VARCHAR2 (60)
Reseller Country
RESELLER_ADDR_LINES_PHONETIC VARCHAR2 (560)
Reseller Address Lines Phonetic
RESELLER_CONTACT_FIRST_NAME VARCHAR2 (150)
Reseller Contact First Name
RESELLER_CONTACT_LAST_NAME VARCHAR2 (150)
Reseller Contact Last Name
RESELLER_CONTACT_TITLE VARCHAR2 (60)
Reseller Contact title
RESELLER_CONTACT_EMAIL_ADDRESS VARCHAR2 (2000)
Reseller Contact Email Address
RESELLER_CONTACT_PHONE_TYPE VARCHAR2 (30)
Reseller Contact Phone type
RESELLER_CONTACT_PHONE_NUMBER VARCHAR2 (40)
Reseller Contact Phone Number
RESELLER_CONTACT_PHONE_EXTN VARCHAR2 (20)
Reseller Contact Phone Extension
CUSTOMER_MERGE_FLAG VARCHAR2 (1)
flag used to indicate customer merge
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining Column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield segment
ORG_ID NUMBER

Organization Identifier
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT REQUEST_HEADER_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_ID
,      CREATED_FROM
,      REQUEST_NUMBER
,      SHIP_FROM_STOCK_FLAG
,      REQUEST_CLASS
,      REQUEST_TYPE_CODE
,      BENEFIT_ID
,      ACTIVITY_MEDIA_ID
,      SUBMITTED_BY
,      SUBMITTED_DATE
,      PARTNER_CONTACT_ID
,      PARTNER_CONTACT_PHONE_NUMBER
,      PARTNER_CONTACT_EMAIL_ADDRESS
,      OFFER_TYPE
,      OFFER_ID
,      ROOT_REQUEST_HEADER_ID
,      LINKED_REQUEST_HEADER_ID
,      START_DATE
,      END_DATE
,      STATUS_CODE
,      REQUEST_OUTCOME
,      DECLINE_REASON_CODE
,      RETURN_REASON_CODE
,      CURRENCY_CODE
,      PARTNER_AMOUNT
,      REQUESTED_AMOUNT
,      APPROVED_AMOUNT
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      PARTNER_ACCTD_AMOUNT
,      REQUESTED_ACCTD_AMOUNT
,      APPROVED_ACCTD_AMOUNT
,      APPROVED_BY
,      APPROVED_DATE
,      AGREEMENT_NUMBER
,      AUTHORIZATION_CODE
,      PARTNER_ID
,      PARTNER_SITE_USE_ID
,      END_CUST_PARTY_ID
,      END_CUST_SITE_USE_ID
,      END_CUST_DUNS_NUMBER
,      END_CUST_NAME
,      END_CUST_ADDRESS1
,      END_CUST_ADDRESS2
,      END_CUST_ADDRESS3
,      END_CUST_ADDRESS4
,      END_CUST_CITY
,      END_CUST_STATE
,      END_CUST_PROVINCE
,      END_CUST_COUNTY
,      END_CUST_POSTAL_CODE
,      END_CUST_COUNTRY
,      END_CUST_ADDR_LINES_PHONETIC
,      END_CUST_CONTACT_FIRST_NAME
,      END_CUST_CONTACT_LAST_NAME
,      END_CUST_CONTACT_TITLE
,      END_CUST_CONTACT_EMAIL_ADDRESS
,      END_CUST_CONTACT_PHONE_TYPE
,      END_CUST_CONTACT_PHONE_NUMBER
,      END_CUST_CONTACT_PHONE_EXTN
,      RESELLER_PARTY_ID
,      RESELLER_DUNS_NUMBER
,      RESELLER_SITE_USE_ID
,      RESELLER_NAME
,      RESELLER_ADDRESS1
,      RESELLER_ADDRESS2
,      RESELLER_ADDRESS3
,      RESELLER_ADDRESS4
,      RESELLER_COUNTY
,      RESELLER_CITY
,      RESELLER_STATE
,      RESELLER_PROVINCE
,      RESELLER_POSTAL_CODE
,      RESELLER_COUNTRY
,      RESELLER_ADDR_LINES_PHONETIC
,      RESELLER_CONTACT_FIRST_NAME
,      RESELLER_CONTACT_LAST_NAME
,      RESELLER_CONTACT_TITLE
,      RESELLER_CONTACT_EMAIL_ADDRESS
,      RESELLER_CONTACT_PHONE_TYPE
,      RESELLER_CONTACT_PHONE_NUMBER
,      RESELLER_CONTACT_PHONE_EXTN
,      CUSTOMER_MERGE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      SECURITY_GROUP_ID
FROM OZF.OZF_REQUEST_HEADERS_ALL_B;

Dependencies

[top of page]

OZF.OZF_REQUEST_HEADERS_ALL_B does not reference any database object

OZF.OZF_REQUEST_HEADERS_ALL_B is referenced by following:

SchemaOZF
ViewOZF_REQUEST_HEADERS_ALL_B#