[Home] [Help] [Dependency Information]
Object Name: | DPP_TXN_DASHBOARD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | DPP.DPP_TXN_DASHBOARD_V |
Subobject Name: | |
Status: | VALID |
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
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 |
FOLLOWUP_ACTION | VARCHAR2 | (150) | ||
MEANING | VARCHAR2 | (80) | Yes | QuickCode meaning |
TXNFOLLOWUPACTION | VARCHAR2 | (80) | ||
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 |
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
, FOLLOWUP_ACTION
, MEANING
, TXNFOLLOWUPACTION
, CLAIMED_AMOUNT
, ONHAND_INV_CURRENCY
, CUST_CLAIM_AMOUNT
, CLAIM_CURRENCY
FROM APPS.DPP_TXN_DASHBOARD_V;
APPS.DPP_TXN_DASHBOARD_V is not referenced by any database object
|
|
|