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_TXN_DASHBOARD_V

Object Details

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

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

View for the Dashboard page in DPP

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OPERATING_UNIT	VARCHAR2	(240)	Yes	Operating Unit Name
REF_DOCUMENT_NUMBER	VARCHAR2	(40)	Yes	To track internal approval details. Provided by the supplier.
SUPPLIER_NAME	VARCHAR2	(240)		Supplier Name
TRANSACTION_HEADER_ID	NUMBER		Yes	Unique identifier for the PP Transaction
TRANSACTION_NUMBER	VARCHAR2	(40)	Yes	Transaction Number.Default for WebADI transmission. For manual source a number is auto generated.
CREATION_DATE	DATE		Yes	Creation Date
EFFECTIVE_START_DATE	DATE		Yes	The date from which the PP Transaction will be valid
TRANSACTION_SOURCE	VARCHAR2	(40)	Yes	Transaction Source: WebADI, XML, Script
TRANSACTION_STATUS	VARCHAR2	(20)	Yes	New, Pending Approval, Active, Rejected, Cancelled, Closed
MEANING	VARCHAR2	(80)	Yes	QuickCode meaning
CLAIMED_AMOUNT	NUMBER			Sum of the line level claim amount of a PP Transaction
ONHAND_INV_CURRENCY	VARCHAR2	(15)	Yes	Transactional currency
CUST_CLAIM_AMOUNT	NUMBER			Customer Claim Amount
CLAIM_CURRENCY	VARCHAR2	(15)	Yes	Claim Currency

Query Text

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


SELECT OPERATING_UNIT
,      REF_DOCUMENT_NUMBER
,      SUPPLIER_NAME
,      TRANSACTION_HEADER_ID
,      TRANSACTION_NUMBER
,      CREATION_DATE
,      EFFECTIVE_START_DATE
,      TRANSACTION_SOURCE
,      TRANSACTION_STATUS
,      MEANING
,      CLAIMED_AMOUNT
,      ONHAND_INV_CURRENCY
,      CUST_CLAIM_AMOUNT
,      CLAIM_CURRENCY
FROM APPS.DPP_TXN_DASHBOARD_V;

Dependencies

[top of page]

APPS.DPP_TXN_DASHBOARD_V references the following:

APPS: AP_SUPPLIERS; DPP_CUSTOMER_CLAIMS_ALL; DPP_TRANSACTION_HEADERS; DPP_TRANSACTION_LINES_ALL; FND_LOOKUP_VALUES_VL; FND_PROFILE - show dependent code; GL_CURRENCY_API - show dependent code; HR_ALL_ORGANIZATION_UNITS

APPS.DPP_TXN_DASHBOARD_V is not referenced by any database object