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

TABLE: PA.PA_AMOUNT_TYPES_B

Object Details
Object Name: PA_AMOUNT_TYPES_B
Object Type: TABLE
Owner: PA
FND Design Data: TablePA.PA_AMOUNT_TYPES_B
Subobject Name:
Status: VALID


PA_AMOUNT_TYPES_B stores the amount types used in summarization


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 40
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_AMOUNT_TYPES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAMOUNT_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
AMOUNT_TYPE_ID NUMBER (15) Yes The system generated number that uniquely identifies the amount type
AMOUNT_TYPE_CODE VARCHAR2 (30) Yes The amount type code associated with the amount type
AMOUNT_TYPE_CLASS VARCHAR2 (2) Yes The amount type class associated with the amount type. Values can be R (raw column) D (derived column)
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
PLAN_ADJUSTABLE_FLAG VARCHAR2 (1)
Indicates that the amount type is an adjustable amount type
PLAN_ADJ_AMOUNT_FLAG VARCHAR2 (1)
Indicates that the amount type is an adjustment amount type
Query Text

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


SELECT AMOUNT_TYPE_ID
,      AMOUNT_TYPE_CODE
,      AMOUNT_TYPE_CLASS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PLAN_ADJUSTABLE_FLAG
,      PLAN_ADJ_AMOUNT_FLAG
FROM PA.PA_AMOUNT_TYPES_B;

Dependencies

[top of page]

PA.PA_AMOUNT_TYPES_B does not reference any database object

PA.PA_AMOUNT_TYPES_B is referenced by following:

SchemaAPPS
SynonymPA_AMOUNT_TYPES_B