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]

TABLE: FEM.FEM_PARTY_PROFITABILITY

Object Details

Object Name:	FEM_PARTY_PROFITABILITY
Object Type:	TABLE
Owner:	FEM
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FEM_PARTY_PROFITABILITY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTY_ID

Columns

Name	Datatype	Length	Mandatory
PARTY_ID	NUMBER		Yes
PROFIT	NUMBER
PROFIT_PCT	NUMBER
RELATIONSHIP_EXPENSE	NUMBER
TOTAL_EQUITY	NUMBER
TOTAL_GROSS_CONTRIB	NUMBER
TOTAL_ROE	NUMBER
CONTRIB_AFTER_CPTL_CHG	NUMBER
PARTNER_VALUE_INDEX	NUMBER
ISO_CURRENCY_CD	VARCHAR2	(3)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
REVENUE1	NUMBER
REVENUE2	NUMBER
REVENUE3	NUMBER
REVENUE4	NUMBER
REVENUE5	NUMBER
REVENUE_TOTAL	NUMBER
EXPENSE1	NUMBER
EXPENSE2	NUMBER
EXPENSE3	NUMBER
EXPENSE4	NUMBER
EXPENSE5	NUMBER
EXPENSE_TOTAL	NUMBER
PROFIT1	NUMBER
PROFIT2	NUMBER
PROFIT3	NUMBER
PROFIT4	NUMBER
PROFIT5	NUMBER
PROFIT_TOTAL	NUMBER
CACC1	NUMBER
CACC2	NUMBER
CACC3	NUMBER
CACC4	NUMBER
CACC5	NUMBER
CACC_TOTAL	NUMBER
BALANCE1	NUMBER
BALANCE2	NUMBER
BALANCE3	NUMBER
BALANCE4	NUMBER
BALANCE5	NUMBER
ACCOUNTS1	NUMBER
ACCOUNTS2	NUMBER
ACCOUNTS3	NUMBER
ACCOUNTS4	NUMBER
ACCOUNTS5	NUMBER
TRANSACTION1	NUMBER
TRANSACTION2	NUMBER
TRANSACTION3	NUMBER
TRANSACTION4	NUMBER
TRANSACTION5	NUMBER
RATIO1	NUMBER
RATIO2	NUMBER
RATIO3	NUMBER
RATIO4	NUMBER
RATIO5	NUMBER
VALUE1	NUMBER
VALUE2	NUMBER
VALUE3	NUMBER
VALUE4	NUMBER
VALUE5	NUMBER
YTD1	NUMBER
YTD2	NUMBER
YTD3	NUMBER
YTD4	NUMBER
YTD5	NUMBER
LTD1	NUMBER
LTD2	NUMBER
LTD3	NUMBER
LTD4	NUMBER
LTD5	NUMBER

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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      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 FEM.FEM_PARTY_PROFITABILITY;

Dependencies

[top of page]

FEM.FEM_PARTY_PROFITABILITY does not reference any database object

FEM.FEM_PARTY_PROFITABILITY is referenced by following:

APPS: FEM_PARTY_PROFITABILITY