[Home] [Help] [Dependency Information]
Object Name: | OZF_SD_REQUEST_HEADERS_ALL_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
Stores information about Ship and debit requests
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 |
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;
APPS.OZF_SD_REQUEST_HEADERS_ALL_VL is not referenced by any database object
|
|
|