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

TABLE: PA.PA_ALLOC_RULES_ALL

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


PA_ALLOC_RULES_ALL stores the information related to an allocation rule.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PA_ALLOC_RULES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_ID
PA_ALLOC_RULES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRULE_NAME
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes Allocation rule identification number
RULE_NAME VARCHAR2 (60) Yes Allocation rule name
ALLOCATION_METHOD VARCHAR2 (1) Yes Allocation method It can be F (full allocation) or I (incremental allocation)
TARGET_EXP_TYPE_CLASS VARCHAR2 (30) Yes Expenditure type class of allocation transactions
TARGET_EXP_ORG_ID NUMBER
Yes Expenditure organization of allocation transactions
TARGET_EXP_TYPE VARCHAR2 (30) Yes Expenditure type of allocation transactions
TARGET_COST_TYPE VARCHAR2 (1) Yes Cost type of allocation transactions It can be R(raw) or B (burdened)
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
DESCRIPTION VARCHAR2 (240)
Allocation rule description
POOL_PERCENT NUMBER

Allocation percentage specified at rule leveL
PERIOD_TYPE VARCHAR2 (2)
Period type of GL (General Ledger) or PA (Oracle Projects)
SOURCE_AMOUNT_TYPE VARCHAR2 (4)
If the period type is PA, source_amount_type can be ITD or PTD If the period type is GL, source _amount_type can be FYTD, QTD, or PTD
SOURCE_BALANCE_CATEGORY VARCHAR2 (1)
Source balance category A (Actuals) is only supported
SOURCE_BALANCE_TYPE VARCHAR2 (30)
Source balance type If the source category is actual, then actual balance type can be TOT_RAW_COST, TOT_BURDENED_COST, TOT_BILLABLE_RAW_COST or TOT_BILLABLE_BURDENED_COST
ALLOC_RESOURCE_LIST_ID NUMBER

Resource List Identifier
AUTO_RELEASE_FLAG VARCHAR2 (1)
The flag indicates whether to create expenditure items automatically Y means release automatically
IMP_WITH_EXCEPTION VARCHAR2 (1)
Default to N Not currently used
DUP_TARGETS_FLAG VARCHAR2 (1)
The flag indicates whether to allow duplicate target projects and tasksY means to allow duplicate target projects and tasks
OFFSET_EXP_TYPE_CLASS VARCHAR2 (30)
Expenditure type class of offset transactions
OFFSET_EXP_ORG_ID NUMBER

Expenditure organization id of offset transactions
OFFSET_EXP_TYPE VARCHAR2 (30)
Expenditure type of offset transactions
OFFSET_COST_TYPE VARCHAR2 (1)
Cost type of offset transactions It can be B (burdened) or R (raw)
OFFSET_METHOD VARCHAR2 (1)
Offset method It can be N (none), A (source project and task), B (source project, use client extension for task), C (specific project and task) or D(use client extension for project and task)
OFFSET_PROJECT_ID NUMBER

Offset project id
OFFSET_TASK_ID NUMBER

Offset task id
BASIS_METHOD VARCHAR2 (2)
Basis method It can be S(spread evenly),P(prorate),C(use client extension basis),FS(target% and spread evenly) or FP(target% and prorate)
BASIS_RELATIVE_PERIOD NUMBER

Relative basis period
BASIS_AMOUNT_TYPE VARCHAR2 (4)
If the period type is PA, source_amount_type can be ITD or PTD If the period type is GL, source_amount_type can be FYTD, QTD, or PTD
BASIS_BALANCE_CATEGORY VARCHAR2 (1)
Basis balance category It can be A (actuals) or B (budgets)
BASIS_BUDGET_TYPE_CODE VARCHAR2 (30)
Basis budget type code
BASIS_BUDGET_ENTRY_METHOD_CODE VARCHAR2 (30)
Basis budget entry method code Not in use
BASIS_BALANCE_TYPE VARCHAR2 (30)
Basis balance type If basis category is actual, then actual balance type can be TOT_RAW_COST, TOT_BURDENED_COST, TOT_BILLABLE_RAW_COST, TOT_BILLABLE_BURDENED_COST, TOT_QUANTITY or TOT_LABOR_HOURS If the basis category is budget, then budget balance type c
BASIS_RESOURCE_LIST_ID NUMBER

Basis resource list identifier
SOURCE_EXTN_FLAG VARCHAR2 (1)
The flag indicates whether source extension exists Y means exist
TARGET_EXTN_FLAG VARCHAR2 (1)
The flag indicates whether target client extension exists Y means exist
FIXED_AMOUNT NUMBER

Fixed source amount
START_DATE_ACTIVE DATE

The date when the rule becomes effective
END_DATE_ACTIVE DATE

The date when the rule becomes ineffective
ORG_ID NUMBER

Operating unit identifier for multi_organization installations
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield context field
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column
LIMIT_TARGET_PROJECTS_CODE VARCHAR2 (1) Yes Business organization level code that limits the selection of target projects
BASIS_FIN_PLAN_TYPE_ID NUMBER (15)
Fin plan type populated when allocation basis is Fin Plan
ALLOC_RESOURCE_STRUCT_TYPE VARCHAR2 (3)
Resource Structure type idendifier for the allocation source resources
BASIS_RESOURCE_STRUCT_TYPE VARCHAR2 (3)
Resource Structure type idendifier for the allocation basis resources
ALLOC_RBS_VERSION NUMBER

RBS structure version for allocation source resources.
BASIS_RBS_VERSION NUMBER

RBS structure version for allocation basis resources.
Query Text

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


SELECT RULE_ID
,      RULE_NAME
,      ALLOCATION_METHOD
,      TARGET_EXP_TYPE_CLASS
,      TARGET_EXP_ORG_ID
,      TARGET_EXP_TYPE
,      TARGET_COST_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      POOL_PERCENT
,      PERIOD_TYPE
,      SOURCE_AMOUNT_TYPE
,      SOURCE_BALANCE_CATEGORY
,      SOURCE_BALANCE_TYPE
,      ALLOC_RESOURCE_LIST_ID
,      AUTO_RELEASE_FLAG
,      IMP_WITH_EXCEPTION
,      DUP_TARGETS_FLAG
,      OFFSET_EXP_TYPE_CLASS
,      OFFSET_EXP_ORG_ID
,      OFFSET_EXP_TYPE
,      OFFSET_COST_TYPE
,      OFFSET_METHOD
,      OFFSET_PROJECT_ID
,      OFFSET_TASK_ID
,      BASIS_METHOD
,      BASIS_RELATIVE_PERIOD
,      BASIS_AMOUNT_TYPE
,      BASIS_BALANCE_CATEGORY
,      BASIS_BUDGET_TYPE_CODE
,      BASIS_BUDGET_ENTRY_METHOD_CODE
,      BASIS_BALANCE_TYPE
,      BASIS_RESOURCE_LIST_ID
,      SOURCE_EXTN_FLAG
,      TARGET_EXTN_FLAG
,      FIXED_AMOUNT
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ORG_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LIMIT_TARGET_PROJECTS_CODE
,      BASIS_FIN_PLAN_TYPE_ID
,      ALLOC_RESOURCE_STRUCT_TYPE
,      BASIS_RESOURCE_STRUCT_TYPE
,      ALLOC_RBS_VERSION
,      BASIS_RBS_VERSION
FROM PA.PA_ALLOC_RULES_ALL;

Dependencies

[top of page]

PA.PA_ALLOC_RULES_ALL does not reference any database object

PA.PA_ALLOC_RULES_ALL is referenced by following:

SchemaPA
ViewPA_ALLOC_RULES_ALL#