[Home] [Help] [Dependency Information]
Object Name: | AMS_DM_PARTY_PROFIT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_DM_PARTY_PROFIT_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 |
---|---|---|---|---|
PARTY_ID | NUMBER | Yes | Party Id | |
PROFIT | NUMBER | Profit | ||
PROFIT_PCT | NUMBER | Profit Pct | ||
RELATIONSHIP_EXPENSE | NUMBER | Relationship Expense | ||
TOTAL_EQUITY | NUMBER | Total Equity | ||
TOTAL_GROSS_CONTRIB | NUMBER | Total Gross Contrib | ||
TOTAL_ROE | NUMBER | Total ROE | ||
CONTRIB_AFTER_CPTL_CHG | NUMBER | Contrib After Cptl Chg | ||
PARTNER_VALUE_INDEX | NUMBER | Partner Value Index | ||
ISO_CURRENCY_CD | VARCHAR2 | (15) | Yes | ISO Currency Code |
REVENUE1 | NUMBER | Revenue1 | ||
REVENUE2 | NUMBER | Revenue2 | ||
REVENUE3 | NUMBER | Revenue3 | ||
REVENUE4 | NUMBER | Revenue4 | ||
REVENUE5 | NUMBER | Revenue5 | ||
REVENUE_TOTAL | NUMBER | Revenue Total | ||
EXPENSE1 | NUMBER | Expense1 | ||
EXPENSE2 | NUMBER | Expense2 | ||
EXPENSE3 | NUMBER | Expense3 | ||
EXPENSE4 | NUMBER | Expense4 | ||
EXPENSE5 | NUMBER | Expense5 | ||
EXPENSE_TOTAL | NUMBER | Expense Total | ||
PROFIT1 | NUMBER | Profit1 | ||
PROFIT2 | NUMBER | Profit2 | ||
PROFIT3 | NUMBER | Profit3 | ||
PROFIT4 | NUMBER | Profit4 | ||
PROFIT5 | NUMBER | Profit5 | ||
PROFIT_TOTAL | NUMBER | Profit Total | ||
CACC1 | NUMBER | CACC1 | ||
CACC2 | NUMBER | CACC2 | ||
CACC3 | NUMBER | CACC3 | ||
CACC4 | NUMBER | CACC4 | ||
CACC5 | NUMBER | CACC5 | ||
CACC_TOTAL | NUMBER | CACC Total | ||
BALANCE1 | NUMBER | Balance1 | ||
BALANCE2 | NUMBER | Balance2 | ||
BALANCE3 | NUMBER | Balance3 | ||
BALANCE4 | NUMBER | Balance4 | ||
BALANCE5 | NUMBER | Balance5 | ||
ACCOUNTS1 | NUMBER | Accounts1 | ||
ACCOUNTS2 | NUMBER | Accounts2 | ||
ACCOUNTS3 | NUMBER | Accounts3 | ||
ACCOUNTS4 | NUMBER | Accounts4 | ||
ACCOUNTS5 | NUMBER | Accounts5 | ||
TRANSACTION1 | NUMBER | Transaction1 | ||
TRANSACTION2 | NUMBER | Transaction2 | ||
TRANSACTION3 | NUMBER | Transaction3 | ||
TRANSACTION4 | NUMBER | Transaction4 | ||
TRANSACTION5 | NUMBER | Transaction5 | ||
RATIO1 | NUMBER | Ratio1 | ||
RATIO2 | NUMBER | Ratio2 | ||
RATIO3 | NUMBER | Ratio3 | ||
RATIO4 | NUMBER | Ratio4 | ||
RATIO5 | NUMBER | Ratio5 | ||
VALUE1 | NUMBER | Value1 | ||
VALUE2 | NUMBER | Value2 | ||
VALUE3 | NUMBER | Value3 | ||
VALUE4 | NUMBER | Value4 | ||
VALUE5 | NUMBER | Value5 | ||
YTD1 | NUMBER | YTD1 | ||
YTD2 | NUMBER | YTD2 | ||
YTD3 | NUMBER | YTD3 | ||
YTD4 | NUMBER | YTD4 | ||
YTD5 | NUMBER | YTD5 | ||
LTD1 | NUMBER | LTD1 | ||
LTD2 | NUMBER | LTD2 | ||
LTD3 | NUMBER | LTD3 | ||
LTD4 | NUMBER | LTD4 | ||
LTD5 | NUMBER | LTD5 |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_ID
, PROFIT
, PROFIT_PCT
, RELATIONSHIP_EXPENSE
, TOTAL_EQUITY
, TOTAL_GROSS_CONTRIB
, TOTAL_ROE
, CONTRIB_AFTER_CPTL_CHG
, PARTNER_VALUE_INDEX
, ISO_CURRENCY_CD
, REVENUE1
, REVENUE2
, REVENUE3
, REVENUE4
, REVENUE5
, REVENUE_TOTAL
, EXPENSE1
, EXPENSE2
, EXPENSE3
, EXPENSE4
, EXPENSE5
, EXPENSE_TOTAL
, PROFIT1
, PROFIT2
, PROFIT3
, PROFIT4
, PROFIT5
, PROFIT_TOTAL
, CACC1
, CACC2
, CACC3
, CACC4
, CACC5
, CACC_TOTAL
, BALANCE1
, BALANCE2
, BALANCE3
, BALANCE4
, BALANCE5
, ACCOUNTS1
, ACCOUNTS2
, ACCOUNTS3
, ACCOUNTS4
, ACCOUNTS5
, TRANSACTION1
, TRANSACTION2
, TRANSACTION3
, TRANSACTION4
, TRANSACTION5
, RATIO1
, RATIO2
, RATIO3
, RATIO4
, RATIO5
, VALUE1
, VALUE2
, VALUE3
, VALUE4
, VALUE5
, YTD1
, YTD2
, YTD3
, YTD4
, YTD5
, LTD1
, LTD2
, LTD3
, LTD4
, LTD5
FROM APPS.AMS_DM_PARTY_PROFIT_V;
APPS.AMS_DM_PARTY_PROFIT_V is not referenced by any database object
|
|
|