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

TABLE: ZPB.ZPB_SOLVE_ALLOCATION_DEFS

Object Details
Object Name: ZPB_SOLVE_ALLOCATION_DEFS
Object Type: TABLE
Owner: ZPB
Subobject Name:
Status: VALID


Defines allocation rules for a member as primary, secondary and default allocations


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZPB_SOLVE_ALLOCATION_DEFS_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnANALYSIS_CYCLE_ID
ColumnMEMBER
ColumnRULE_NAME
Columns
Name Datatype Length Mandatory Comments
ANALYSIS_CYCLE_ID NUMBER
Yes Business process ID.
MEMBER VARCHAR2 (50) Yes Dimension member ID.
MEMBER_ORDER NUMBER

The order of the allocation
RULE_NAME NUMBER
Yes Allocation type parameter ID
METHOD VARCHAR2 (20) Yes Allocation method
BASIS VARCHAR2 (50)
The allocation basis view, if proportional
QUALIFIER VARCHAR2 (50)
The line member qualifier, if stated
EVALUATION_OPTION VARCHAR2 (20)
CASCADE or DIRECT evaluation
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who 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
ROUND_DECIMALS NUMBER

Rounding Decimal Points
ROUND_ENABLED VARCHAR2 (1)
Round Enabled Flag
Query Text

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


SELECT ANALYSIS_CYCLE_ID
,      MEMBER
,      MEMBER_ORDER
,      RULE_NAME
,      METHOD
,      BASIS
,      QUALIFIER
,      EVALUATION_OPTION
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      ROUND_DECIMALS
,      ROUND_ENABLED
FROM ZPB.ZPB_SOLVE_ALLOCATION_DEFS;

Dependencies

[top of page]

ZPB.ZPB_SOLVE_ALLOCATION_DEFS does not reference any database object

ZPB.ZPB_SOLVE_ALLOCATION_DEFS is referenced by following:

SchemaAPPS
SynonymZPB_SOLVE_ALLOCATION_DEFS