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: AMS.AMS_DM_FINNUM_STG

Object Details

Object Name:	AMS_DM_FINNUM_STG
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_DM_FINNUM_STG
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_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_DM_FINNUM_STG_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PARTY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER		Yes	Column used to join with AMS_DM_DRV_STG.
GROSS_ANNUAL_INCOME	NUMBER			Gross annual income.
DEBT_TO_INCOME_RATIO	NUMBER			Debt to income ratio.
NUM_CREDIT_LINES	NUMBER			Number of credit lines.
NUM_TRADE_LINES	NUMBER			Number of trade lines.
NET_WORTH	NUMBER			Net worth.
TOTAL_ASSETS	NUMBER			Total assets.
TOT_DEBT_OUTSTANDING	NUMBER			Total debt outstanding.
BANKRUPTCY_FLAG	VARCHAR2	(1)		Bankruptcy indicatory.
HIGH_RISK_FRAUD_FLAG	VARCHAR2	(1)		High risk for fraud indicator.
GROSS_ANNUAL_SALES	NUMBER			Gross annual sales.
GROWTH_RATE_SALES_YEAR	NUMBER			Growth rate of sales in the past year.
GROWTH_RATE_NET_PROF_YEAR	NUMBER			Growth rate of net profit in the past year.
CURRENT_ASSETS	NUMBER			Current assets.
CURRENT_LIABILITIES	NUMBER			Current liabilities.
TOTAL_DEBTS	NUMBER			Total debts.
NET_PROFIT	NUMBER			Net profit.
TANGIBLE_NET_PROFIT	NUMBER			Tangible net profit.
CAPITAL_AMOUNT	NUMBER			Capital amount.
CAPITAL_TYPE_INDICATOR	VARCHAR2	(30)		Capital type indicator.
ACCOUNTS_RECEIVABLE	NUMBER			Accounts receivable.
RETAINED_EARNINGS	NUMBER			Retained earnings.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARTY_ID
,      GROSS_ANNUAL_INCOME
,      DEBT_TO_INCOME_RATIO
,      NUM_CREDIT_LINES
,      NUM_TRADE_LINES
,      NET_WORTH
,      TOTAL_ASSETS
,      TOT_DEBT_OUTSTANDING
,      BANKRUPTCY_FLAG
,      HIGH_RISK_FRAUD_FLAG
,      GROSS_ANNUAL_SALES
,      GROWTH_RATE_SALES_YEAR
,      GROWTH_RATE_NET_PROF_YEAR
,      CURRENT_ASSETS
,      CURRENT_LIABILITIES
,      TOTAL_DEBTS
,      NET_PROFIT
,      TANGIBLE_NET_PROFIT
,      CAPITAL_AMOUNT
,      CAPITAL_TYPE_INDICATOR
,      ACCOUNTS_RECEIVABLE
,      RETAINED_EARNINGS
FROM AMS.AMS_DM_FINNUM_STG;

Dependencies

[top of page]

AMS.AMS_DM_FINNUM_STG does not reference any database object

AMS.AMS_DM_FINNUM_STG is referenced by following:

APPS: AMS_DM_FINNUM_STG