[Home] [Help] [Dependency Information]
Object Name: | DPP_WEBADI_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | DPP.DPP_WEBADI_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REF_DOCUMENT_NUMBER | VARCHAR2 | (40) | Yes | To track internal approval details. Provided by the supplier. |
EFFECTIVE_START_DATE | DATE | Yes | The date from which the PP Transaction will be valid | |
DAYS_COVERED | NUMBER | Number of days covered as per the PP Transaction | ||
ORGANIZATION_NAME | VARCHAR2 | (240) | Yes | Organization Name |
ORG_ID | VARCHAR2 | (150) | Operating Unit | |
CLAIM_NUMBER | VARCHAR2 | (30) | Claim Number | |
CLAIM_TYPE | VARCHAR2 | (80) | Yes | Types of claim for PP (SUPP_DSTR_CL, CUST_CL & SUPP_CUST_CL) |
CLAIM_CURRENCY | VARCHAR2 | (15) | Claim Currency | |
SUPPLIER_NAME | VARCHAR2 | (240) | Supplier Name | |
SUPPLIER_SITE | VARCHAR2 | (15) | Yes | Supplier Site |
SUPPLIER_ID | VARCHAR2 | (150) | Yes | Supplier unique identifier |
SUPPLIER_SITE_ID | VARCHAR2 | (150) | Yes | Supplier site unique identifier |
SUPPLIER_CONTACT_NAME | VARCHAR2 | (50) | Supplier Contact Name | |
SUPPLIER_CONTACT_ID | VARCHAR2 | (150) | Unique Identifier for the supplier's contact person | |
SUPPLIER_CONTACT_EMAIL | VARCHAR2 | (2000) | Supplier contact persons email. | |
SUPPLIER_CONTACT_PHONE | VARCHAR2 | (40) | Supplier contact persons phone. | |
HEADER_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfiled structure defining column | |
HEADER_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flexfield segment | |
HEADER_ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flexfield segment | |
SUPPLIER_APPROVED_BY | VARCHAR2 | (100) | Supplier pre-approver name | |
SUPPLIER_APPROVED_DATE | DATE | Date of Supplier Pre-Approval | ||
SUPPLIER_PART_NUM | VARCHAR2 | (240) | Supplier Part Numer | |
ITEM_NUMBER | VARCHAR2 | (40) | Inventory Item Number | |
UOM | VARCHAR2 | (3) | Unit of Measure | |
PRIOR_PRICE | NUMBER | Yes | The price for which the product was purchased from supplier. This will be equal to list price for that item. | |
SUPPLIER_NEW_PRICE | NUMBER | New Price for the item provided by supplier | ||
DELTA | NUMBER | The field will not be shown in Price Change Details screen. The calculation for this field will be triggered after the line is saved & logic will be driven by CHANGE_TYPE | ||
COVERED_QUANTITY | NUMBER | Covered Inventory calculated from ERP application | ||
CLAIM_AMOUNT | NUMBER | Claim Amount | ||
APPROVED_QUANTITY | NUMBER | Inventory approved by supplier to be covered under the PP Transaction. | ||
LINE_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfiled structure defining column | |
LINE_ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flexfield segment | |
LINE_ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT REF_DOCUMENT_NUMBER
, EFFECTIVE_START_DATE
, DAYS_COVERED
, ORGANIZATION_NAME
, ORG_ID
, CLAIM_NUMBER
, CLAIM_TYPE
, CLAIM_CURRENCY
, SUPPLIER_NAME
, SUPPLIER_SITE
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, SUPPLIER_CONTACT_NAME
, SUPPLIER_CONTACT_ID
, SUPPLIER_CONTACT_EMAIL
, SUPPLIER_CONTACT_PHONE
, HEADER_ATTRIBUTE_CATEGORY
, HEADER_ATTRIBUTE1
, HEADER_ATTRIBUTE2
, HEADER_ATTRIBUTE3
, HEADER_ATTRIBUTE4
, HEADER_ATTRIBUTE5
, HEADER_ATTRIBUTE6
, HEADER_ATTRIBUTE7
, HEADER_ATTRIBUTE8
, HEADER_ATTRIBUTE9
, HEADER_ATTRIBUTE10
, HEADER_ATTRIBUTE11
, HEADER_ATTRIBUTE12
, HEADER_ATTRIBUTE13
, HEADER_ATTRIBUTE14
, HEADER_ATTRIBUTE15
, HEADER_ATTRIBUTE16
, HEADER_ATTRIBUTE17
, HEADER_ATTRIBUTE18
, HEADER_ATTRIBUTE19
, HEADER_ATTRIBUTE20
, HEADER_ATTRIBUTE21
, HEADER_ATTRIBUTE22
, HEADER_ATTRIBUTE23
, HEADER_ATTRIBUTE24
, HEADER_ATTRIBUTE25
, HEADER_ATTRIBUTE26
, HEADER_ATTRIBUTE27
, HEADER_ATTRIBUTE28
, HEADER_ATTRIBUTE29
, HEADER_ATTRIBUTE30
, SUPPLIER_APPROVED_BY
, SUPPLIER_APPROVED_DATE
, SUPPLIER_PART_NUM
, ITEM_NUMBER
, UOM
, PRIOR_PRICE
, SUPPLIER_NEW_PRICE
, DELTA
, COVERED_QUANTITY
, CLAIM_AMOUNT
, APPROVED_QUANTITY
, LINE_ATTRIBUTE_CATEGORY
, LINE_ATTRIBUTE1
, LINE_ATTRIBUTE2
, LINE_ATTRIBUTE3
, LINE_ATTRIBUTE4
, LINE_ATTRIBUTE5
, LINE_ATTRIBUTE6
, LINE_ATTRIBUTE7
, LINE_ATTRIBUTE8
, LINE_ATTRIBUTE9
, LINE_ATTRIBUTE10
, LINE_ATTRIBUTE11
, LINE_ATTRIBUTE12
, LINE_ATTRIBUTE13
, LINE_ATTRIBUTE14
, LINE_ATTRIBUTE15
, LINE_ATTRIBUTE16
, LINE_ATTRIBUTE17
, LINE_ATTRIBUTE18
, LINE_ATTRIBUTE19
, LINE_ATTRIBUTE20
, LINE_ATTRIBUTE21
, LINE_ATTRIBUTE22
, LINE_ATTRIBUTE23
, LINE_ATTRIBUTE24
, LINE_ATTRIBUTE25
, LINE_ATTRIBUTE26
, LINE_ATTRIBUTE27
, LINE_ATTRIBUTE28
, LINE_ATTRIBUTE29
, LINE_ATTRIBUTE30
FROM APPS.DPP_WEBADI_V;
APPS.DPP_WEBADI_V is not referenced by any database object
|
|
|