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

VIEW: APPS.OZF_SD_REQUEST_HEADERS_ALL_VL

Object Details
Object Name: OZF_SD_REQUEST_HEADERS_ALL_VL
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)


Stores information about Ship and debit requests


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
REQUEST_HEADER_ID NUMBER
Yes Request header ID
OBJECT_VERSION_NUMBER NUMBER
Yes object version number
LAST_UPDATE_DATE DATE
Yes Std. WHO column
LAST_UPDATED_BY NUMBER
Yes Std. WHO column
CREATION_DATE DATE
Yes Std. WHO column
CREATED_BY NUMBER
Yes Std. WHO column
LAST_UPDATE_LOGIN NUMBER

Std. WHO column
REQUEST_ID NUMBER

Std. WHO column
PROGRAM_APPLICATION_ID NUMBER

Std. WHO column
PROGRAM_UPDATE_DATE DATE

Std. WHO column
PROGRAM_ID NUMBER

Std. WHO column
CREATED_FROM VARCHAR2 (30)
Std. WHO column
REQUEST_NUMBER VARCHAR2 (30) Yes Request number
REQUEST_CLASS VARCHAR2 (30)
Request classification. This col value will classify the SD request. May be used for future use.
REQUEST_TYPE_SETUP_ID NUMBER

indicates the custom setup of Ship and Debit request
OFFER_TYPE VARCHAR2 (30)
Type of offer submitted to TM module
OFFER_ID NUMBER

Promotional Offer Identifier. Foreign key for ozf_offers.
ROOT_REQUEST_HEADER_ID NUMBER

For Future Use
LINKED_REQUEST_HEADER_ID NUMBER

For Future Use
REQUEST_START_DATE DATE

SD Request start date. Corresponds to start date filed on SDR Header creation page
REQUEST_END_DATE DATE

SD Request end date. Corresponds to end date filed on SDR Header creation page
USER_STATUS_ID NUMBER

id indicating the user status of the Ship and debit request
REQUEST_OUTCOME VARCHAR2 (30)
Outcome code for the SD Request. possible values : IN PROGRESS / REJECTED / ACCEPTED
DECLINE_REASON_CODE VARCHAR2 (30)
Can be derived from Lookups.
RETURN_REASON_CODE VARCHAR2 (30)
Can be derived from Lookups.
REQUEST_CURRENCY_CODE VARCHAR2 (15)
Currency Code
AUTHORIZATION_NUMBER VARCHAR2 (30)
Authorization number of SD request
REQUESTED_BUDGET_AMOUNT NUMBER

Requested budget amount. For future use.
APPROVED_BUDGET_AMOUNT NUMBER

Approved budget amount. For future use.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield segment
SUPPLIER_ID NUMBER

supplier id
SUPPLIER_SITE_ID NUMBER

site id of the supplier
SUPPLIER_CONTACT_ID NUMBER

contact id of the supplier
INTERNAL_SUBMISSION_DATE DATE

SDR submission date internal approval
ASIGNEE_RESPONSE_BY_DATE DATE

Expected internal Response Date. Set at the time of creation of the SDR.(For internal approval purpose)
ASIGNEE_RESPONSE_DATE DATE

Date responded.
SUBMTD_BY_FOR_SUPP_APPROVAL NUMBER

SDR Request submitted for Supplier approval purpose.
SUPPLIER_RESPONSE_BY_DATE DATE

Date at which the supplier has to respond to the SDR. Set at the time of creation of the SDR.
SUPPLIER_RESPONSE_DATE DATE

Supplier responded date
SUPPLIER_SUBMISSION_DATE DATE

Date at which the distributor had submitted the SDR to supplier for approval.
REQUESTOR_ID NUMBER
Yes Requestor's resource id
SUPPLIER_QUOTE_NUMBER VARCHAR2 (30)
Quote Number of the supplier.
INTERNAL_ORDER_NUMBER NUMBER

Internal order number. This col shlould be used as qualifier.
SALES_ORDER_CURRENCY VARCHAR2 (15)
Sales order currency code
REQUEST_SOURCE VARCHAR2 (30)
Request Source
ASIGNEE_RESOURCE_ID NUMBER

resource id to whom the request has been assigned
ORG_ID NUMBER

Organization ID of the requestor (Distributor)
SECURITY_GROUP_ID NUMBER

Std WHO col.
ACCRUAL_TYPE VARCHAR2 (30) Yes Supplier/Internal
CUST_ACCOUNT_ID NUMBER

Cost center info.
SUPPLIER_CONTACT_EMAIL_ADDRESS VARCHAR2 (2000)
Email Address of supplier contact
SUPPLIER_CONTACT_PHONE_NUMBER VARCHAR2 (60)
Phone number of supplier contact
REQUEST_BASIS VARCHAR2 (1)
flag indicates whether ship and debit request is request only or not
SUPPLIER_CONTACT_NAME VARCHAR2 (360)
Name of the supplier contact
REQUEST_DESCRIPTION VARCHAR2 (4000)
Description of the request
Query Text

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


SELECT ROW_ID
,      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
,      REQUEST_CLASS
,      REQUEST_TYPE_SETUP_ID
,      OFFER_TYPE
,      OFFER_ID
,      ROOT_REQUEST_HEADER_ID
,      LINKED_REQUEST_HEADER_ID
,      REQUEST_START_DATE
,      REQUEST_END_DATE
,      USER_STATUS_ID
,      REQUEST_OUTCOME
,      DECLINE_REASON_CODE
,      RETURN_REASON_CODE
,      REQUEST_CURRENCY_CODE
,      AUTHORIZATION_NUMBER
,      REQUESTED_BUDGET_AMOUNT
,      APPROVED_BUDGET_AMOUNT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      SUPPLIER_CONTACT_ID
,      INTERNAL_SUBMISSION_DATE
,      ASIGNEE_RESPONSE_BY_DATE
,      ASIGNEE_RESPONSE_DATE
,      SUBMTD_BY_FOR_SUPP_APPROVAL
,      SUPPLIER_RESPONSE_BY_DATE
,      SUPPLIER_RESPONSE_DATE
,      SUPPLIER_SUBMISSION_DATE
,      REQUESTOR_ID
,      SUPPLIER_QUOTE_NUMBER
,      INTERNAL_ORDER_NUMBER
,      SALES_ORDER_CURRENCY
,      REQUEST_SOURCE
,      ASIGNEE_RESOURCE_ID
,      ORG_ID
,      SECURITY_GROUP_ID
,      ACCRUAL_TYPE
,      CUST_ACCOUNT_ID
,      SUPPLIER_CONTACT_EMAIL_ADDRESS
,      SUPPLIER_CONTACT_PHONE_NUMBER
,      REQUEST_BASIS
,      SUPPLIER_CONTACT_NAME
,      REQUEST_DESCRIPTION
FROM APPS.OZF_SD_REQUEST_HEADERS_ALL_VL;

Dependencies

[top of page]

APPS.OZF_SD_REQUEST_HEADERS_ALL_VL references the following:

SchemaAPPS
SynonymOZF_SD_REQUEST_HEADERS
SynonymOZF_SD_REQUEST_HEADERS_ALL_TL

APPS.OZF_SD_REQUEST_HEADERS_ALL_VL is not referenced by any database object