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: TableAMS.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: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AMS_DM_FINNUM_STG_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARTY_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:

SchemaAMS
ViewAMS_DM_FINNUM_STG#