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


VIEW: APPS.PA_RESOURCE_LISTS

Object Details
Object Name: PA_RESOURCE_LISTS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPA.PA_RESOURCE_LISTS
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.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
RESOURCE_LIST_ID NUMBER (15) Yes
NAME VARCHAR2 (240) Yes
DESCRIPTION VARCHAR2 (2000)

PUBLIC_FLAG VARCHAR2 (1)

GROUP_RESOURCE_TYPE_ID NUMBER


START_DATE_ACTIVE DATE
Yes
END_DATE_ACTIVE DATE


UNCATEGORIZED_FLAG VARCHAR2 (1)

LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
BUSINESS_GROUP_ID NUMBER (15) Yes
ADW_NOTIFY_FLAG VARCHAR2 (1)

JOB_GROUP_ID NUMBER (15)
RESOURCE_LIST_TYPE VARCHAR2 (30)
Indicates the type of Resource List; valid values are Automatically generated and User-defined
CONTROL_FLAG VARCHAR2 (1)
USE_FOR_WP_FLAG VARCHAR2 (1)
MIGRATION_CODE VARCHAR2 (1)
RECORD_VERSION_NUMBER NUMBER (15)
MIGRATED_RBS_VERSION_ID NUMBER (15)
Query Text

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


SELECT RESOURCE_LIST_ID
,      NAME
,      DESCRIPTION
,      PUBLIC_FLAG
,      GROUP_RESOURCE_TYPE_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      UNCATEGORIZED_FLAG
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BUSINESS_GROUP_ID
,      ADW_NOTIFY_FLAG
,      JOB_GROUP_ID
,      RESOURCE_LIST_TYPE
,      CONTROL_FLAG
,      USE_FOR_WP_FLAG
,      MIGRATION_CODE
,      RECORD_VERSION_NUMBER
,      MIGRATED_RBS_VERSION_ID
FROM APPS.PA_RESOURCE_LISTS;

Dependencies

[top of page]

APPS.PA_RESOURCE_LISTS references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackagePA_CROSS_BUSINESS_GRP - show dependent code
SynonymPA_RESOURCE_LISTS_ALL_BG
SynonymPA_RESOURCE_LISTS_TL
APPS.PA_RESOURCE_LISTS is referenced by following:

SchemaAPPS
ViewGMS_BUDGETARY_CONTROL_AWARD_V
ViewGMS_BUDGETARY_CONTROL_PROJ_V
Package BodyGMS_BUDGET_BALANCE - show dependent code
Package BodyGMS_BUDGET_CORE - show dependent code
Package BodyGMS_BUDGET_PUB - show dependent code
ViewGMS_BUDGET_VERSIONS_BASELND_V
ViewGMS_BUDGET_VERSIONS_DRAFT_V
ViewGMS_BUDG_CONTROL_RES_GRP_V
Package BodyGMS_CLIENT_EXTN_BUDGET_WF - show dependent code
Package BodyGMS_MULTI_FUNDING - show dependent code
ViewGMS_RESG_V
Package BodyGMS_RES_MAP - show dependent code
ViewGMS_RES_V
Package BodyGMS_SUMMARIZE_BUDGETS - show dependent code
Package BodyGMS_WF_PKG - show dependent code
Package BodyPA_ADW_COLLECT_DIMENSIONS - show dependent code
Package BodyPA_ADW_COLLECT_MAIN - show dependent code
ViewPA_ADW_RES_LISTS_B_V
Package BodyPA_AGREEMENT_PUB - show dependent code
Package BodyPA_BASELINE_FUNDING_PKG - show dependent code
ViewPA_BUDGETARY_CONTROL_PROJ_V
Package BodyPA_BUDGET_CORE1 - show dependent code
PL/SQL PackagePA_BUDGET_PUB - show dependent code
Package BodyPA_BUDGET_PUB - show dependent code
Package BodyPA_BUDGET_PVT - show dependent code
ViewPA_BUDGET_RESOURCE_LISTS_V
Package BodyPA_BUDGET_UTILS - show dependent code
ViewPA_BUDGET_VERSIONS_BASELINED_V
ViewPA_BUDGET_VERSIONS_DRAFT_V
ViewPA_BUDG_CONTROL_RES_GRP_V
ViewPA_BURDEN_COMPONENT_CMT_V
ViewPA_BURDEN_COMPONENT_COST_V
ViewPA_CHILD_RESOURCES_V
Package BodyPA_CLIENT_EXTN_BUDGET_WF - show dependent code
Package BodyPA_CREATE_RESOURCE - show dependent code
Package BodyPA_FIN_PLAN_CREATE_VER_GLOBAL - show dependent code
PL/SQL PackagePA_FIN_PLAN_CREATE_VER_GLOBAL - show dependent code
PL/SQL PackagePA_FIN_PLAN_UTILS - show dependent code
Package BodyPA_FIN_PLAN_UTILS - show dependent code
PL/SQL PackagePA_FORECAST_GLOBAL - show dependent code
Package BodyPA_FP_CONTROL_ITEMS_UTILS - show dependent code
Package BodyPA_FP_EDIT_LINE_PKG - show dependent code
PL/SQL PackagePA_FP_EDIT_LINE_PKG - show dependent code
Package BodyPA_FP_ELEMENTS_PUB - show dependent code
PL/SQL PackagePA_FP_ELEMENTS_PUB - show dependent code
Package BodyPA_FP_GEN_AMOUNT_UTILS - show dependent code
Package BodyPA_FP_ROLLUP_PKG - show dependent code
Package BodyPA_FP_VIEW_PLANS_PUB - show dependent code
Package BodyPA_FP_VIEW_PLANS_TXN_PUB - show dependent code
Package BodyPA_FP_VIEW_PLANS_UTIL - show dependent code
ViewPA_FP_WEBADI_CONTENTS_V
ViewPA_FP_WEBADI_NON_PERIODIC_V
Package BodyPA_FP_WEBADI_UTILS - show dependent code
Package BodyPA_GET_RESOURCE - show dependent code
ViewPA_LOWEST_LEVEL_RESOURCES_V
Package BodyPA_PAUPGRRL_XMLP_PKG - show dependent code
Package BodyPA_PLANNING_ELEMENT_UTILS - show dependent code
ViewPA_QRY_RESOURCE_LISTS_V
ViewPA_QUERY_RES_LIST_MEMBERS_V
ViewPA_RESOURCE_LISTS_ACTIVE_V
ViewPA_RESOURCE_LIST_GROUPS_V
ViewPA_RESOURCE_LIST_USES_V
ViewPA_RESOURCE_LIST_V
Package BodyPA_RESOURCE_PUB - show dependent code
Package BodyPA_RES_LIST_ASSIGNMENTS - show dependent code
Package BodyPA_RES_LIST_UPGRADE_PKG - show dependent code
Package BodyPA_TASK_ASSIGNMENTS_PUB - show dependent code
Package BodyPA_TASK_ASSIGNMENTS_PVT - show dependent code
Package BodyPA_TASK_ASSIGNMENT_UTILS - show dependent code