[Home] [Help] [Dependency Information]

VIEW: APPS.PA_ALLOC_RUNS_V

Object Details

Object Name:	PA_ALLOC_RUNS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_ALLOC_RUNS_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Query Text

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

SELECT RULE_ID
,      RUN_ID
,      RULE_NAME
,      DESCRIPTION
,      RUN_PERIOD
,      EXPND_ITEM_DATE
,      DENOM_CURRENCY_CODE
,      CREATION_DATE
,      CREATED_BY
,      CREATED_BY_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      POOL_PERCENT
,      PERIOD_TYPE
,      SOURCE_AMOUNT_TYPE
,      SOURCE_AMOUNT_TYPE_DISP
,      SOURCE_BALANCE_CATEGORY
,      SOURCE_BALANCE_CATEGORY_DISP
,      SOURCE_BALANCE_TYPE
,      SOURCE_BALANCE_TYPE_DISP
,      SOURCE_RESOURCE_LIST_ID
,      SOURCE_RESOURCE_LIST_NAME
,      AUTO_RELEASE_FLAG
,      ALLOCATION_METHOD
,      ALLOCATION_METHOD_DISP
,      IMP_WITH_EXCEPTION
,      DUP_TARGETS_FLAG
,      TARGET_EXP_TYPE_CLASS
,      TARGET_EXP_TYPE_CLASS_DISP
,      TARGET_EXP_ORG_ID
,      TARGET_EXP_ORG_NAME
,      TARGET_EXP_TYPE
,      TARGET_COST_TYPE
,      TARGET_COST_TYPE_DISP
,      OFFSET_EXP_TYPE_CLASS
,      OFFSET_EXP_TYPE_CLASS_DISP
,      OFFSET_EXP_ORG_ID
,      OFFSET_EXP_ORG_NAME
,      OFFSET_EXP_TYPE
,      OFFSET_COST_TYPE
,      OFFSET_COST_TYPE_DISP
,      OFFSET_METHOD
,      OFFSET_METHOD_DISP
,      OFFSET_PROJECT_NUMBER
,      OFFSET_TASK_NUMBER
,      RUN_STATUS_CODE
,      RUN_STATUS
,      BASIS_RELATIVE_PERIOD
,      BASIS_AMOUNT_TYPE
,      BASIS_AMOUNT_TYPE_DISP
,      BASIS_BALANCE_CATEGORY
,      BASIS_BALANCE_CATEGORY_DISP
,      BASIS_BUDGET_TYPE_CODE
,      BASIS_BUDGET_TYPE_DISP
,      BASIS_FIN_PLAN_TYPE_ID
,      BASIS_FIN_PLAN_TYPE_DISP
,      BASIS_BALANCE_TYPE
,      BASIS_BALANCE_TYPE_DISP
,      BASIS_RESOURCE_LIST_ID
,      BASIS_RESOURCE_LIST_NAME
,      BASIS_BUDGET_ENTRY_METHOD_CODE
,      FISCAL_YEAR
,      QUARTER
,      PERIOD_NUM
,      TARGET_EXP_GROUP
,      OFFSET_EXP_GROUP
,      TOTAL_POOL_AMOUNT
,      ALLOCATED_AMOUNT
,      TOTAL_ALLOCATED_AMOUNT
,      TOTAL_OFFSETTED_AMOUNT
,      MISSING_SOURCE_PROJ_AMT
,      MISSING_TARGET_PROJ_AMT
,      MISSING_OFFSET_PROJ_AMT
,      DRAFT_REQUEST_ID
,      DRAFT_REQUEST_DATE
,      RELEASE_REQUEST_ID
,      RELEASE_REQUEST_DATE
,      REVERSAL_DATE
,      FIXED_AMOUNT
,      FIXED_ELIGIBLE_AMOUNT
,      REV_TARGET_EXP_GROUP
,      REV_OFFSET_EXP_GROUP
,      BASIS_METHOD
,      BASIS_METHOD_DISP
,      RUN_IN_AUTOALLOC
,      CINT_RATE_NAME
,      ALLOC_RESOURCE_STRUCT_TYPE
,      BASIS_RESOURCE_STRUCT_TYPE
,      ALLOC_RBS_VERSION
,      BASIS_RBS_VERSION
,      ORG_ID
FROM APPS.PA_ALLOC_RUNS_V;

Dependencies

[top of page]

APPS

FND_USER

HR_ALL_ORGANIZATION_UNITS

HR_ALL_ORGANIZATION_UNITS_TL

HR_GENERAL - show dependent code

HR_ORG_UNITS_NO_JOIN

HR_SECURITY - show dependent code

PA_ALLOC_RULES_ALL

PA_ALLOC_RUNS

PA_ALLOC_UTILS - show dependent code

PA_AUTOALLOC_UTLS - show dependent code

PA_BUDGET_TYPES

PA_FIN_PLAN_TYPES_TL

PA_LOOKUPS

PA_PROJECTS_ALL

PA_SYSTEM_LINKAGES

PA_TASKS

APPS

PA_PAXALRUN_XMLP_PKG - show dependent code