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_XLA_CP_V

Object Details

Object Name:	DPP_XLA_CP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	DPP.DPP_XLA_CP_V
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
TRANSACTION_HEADER_ID	NUMBER		Yes	Unique identifier for the PP Transaction
BASE_TRANSACTION_HEADER_ID	NVARCHAR2	(300)	Yes	Unique Identifier for the Claim.
PP_TXN_NUMBER	VARCHAR2	(40)	Yes	Default for WebADI transmission. For manual source a number is auto generated.
CLAIM_LINE_AMOUNT	NUMBER			Claim Line Amount
CLAIM_DATE	DATE		Yes	Claim Date
CLAIM_NUMBER	VARCHAR2	(30)		Claim Number
CLAIM_TYPE	VARCHAR2	(80)	Yes	Type of Claim (Supplier/Customer)
CLAIM_CURRENCY_CODE	VARCHAR2	(15)		Currency in which the claim is created

Query Text

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


SELECT TRANSACTION_HEADER_ID
,      BASE_TRANSACTION_HEADER_ID
,      PP_TXN_NUMBER
,      CLAIM_LINE_AMOUNT
,      CLAIM_DATE
,      CLAIM_NUMBER
,      CLAIM_TYPE
,      CLAIM_CURRENCY_CODE
FROM APPS.DPP_XLA_CP_V;

Dependencies

[top of page]

APPS.DPP_XLA_CP_V references the following:

APPS: DPP_TRANSACTION_CLAIMS_ALL; DPP_TRANSACTION_HEADERS_ALL; DPP_XLA_HEADERS; FND_LOOKUP_VALUES_VL; OZF_CLAIMS_ALL

APPS.DPP_XLA_CP_V is not referenced by any database object