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.

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

VIEW: APPS.DPP_WEBADI_V

Object Details

Object Name:	DPP_WEBADI_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

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	(40)		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

Query Text

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;

Dependencies

[top of page]

APPS.DPP_WEBADI_V references the following:

APPS: AP_SUPPLIERS; AP_SUPPLIER_SITES_ALL; DPP_TRANSACTION_CLAIMS_ALL; DPP_TRANSACTION_HEADERS_ALL; DPP_TRANSACTION_LINES_ALL; FND_GLOBAL - show dependent code; FND_LOOKUPS; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MTL_SYSTEM_ITEMS_KFV; ORG_ORGANIZATION_DEFINITIONS; OZF_CLAIMS_ALL

APPS.DPP_WEBADI_V is not referenced by any database object