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

TABLE: AMS.AMS_DM_PARTY_PROFILE_STG

Object Details
Object Name: AMS_DM_PARTY_PROFILE_STG
Object Type: TABLE
Owner: AMS
FND Design Data: TableAMS.AMS_DM_PARTY_PROFILE_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_PARTY_PROFILE_STG_U1 NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnPARTY_ID
Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Yes Party identifier.
CREDIT_CHECK_FLAG VARCHAR2 (1)
Credit check indicator.
TOLERANCE NUMBER

Tolerance.
DISCOUNT_TERMS_FLAG VARCHAR2 (1)
Discount terms indicator.
DUNNING_LETTERS_FLAG VARCHAR2 (1)
Dunning letters indicator.
INTEREST_CHARGES_FLAG VARCHAR2 (1)
Interest charges indicator.
SEND_STATEMENTS_FLAG VARCHAR2 (1)
Send statements indicator.
CREDIT_HOLD_FLAG VARCHAR2 (1)
Credit hold indicator.
CREDIT_RATING VARCHAR2 (60)
Credit rating.
RISK_CODE VARCHAR2 (60)
Risk code.
INTEREST_PERIOD_DAYS NUMBER

Interest period days.
PAYMENT_GRACE_DAYS NUMBER

Payment grace days.
Query Text

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


SELECT PARTY_ID
,      CREDIT_CHECK_FLAG
,      TOLERANCE
,      DISCOUNT_TERMS_FLAG
,      DUNNING_LETTERS_FLAG
,      INTEREST_CHARGES_FLAG
,      SEND_STATEMENTS_FLAG
,      CREDIT_HOLD_FLAG
,      CREDIT_RATING
,      RISK_CODE
,      INTEREST_PERIOD_DAYS
,      PAYMENT_GRACE_DAYS
FROM AMS.AMS_DM_PARTY_PROFILE_STG;

Dependencies

[top of page]

AMS.AMS_DM_PARTY_PROFILE_STG does not reference any database object

AMS.AMS_DM_PARTY_PROFILE_STG is referenced by following:

SchemaAMS
ViewAMS_DM_PARTY_PROFILE_STG#