Product: | AMS - Marketing |
---|---|
Description: | View used by the seeded data mining profitability data source for parties in the Trading Community Architecture. |
Implementation/DBA Data: | APPS.AMS_DM_PARTY_PROFIT_V |
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 FEM_PARTY_PROFITABILITY