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

VIEW: APPS.AMS_DM_PARTY_PROFIT_V

Object Details
Object Name: AMS_DM_PARTY_PROFIT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAMS.AMS_DM_PARTY_PROFIT_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
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
Query Text

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;

Dependencies

[top of page]

APPS.AMS_DM_PARTY_PROFIT_V references the following:

SchemaAPPS
SynonymFEM_CUSTOMER_PROFIT

APPS.AMS_DM_PARTY_PROFIT_V is not referenced by any database object