[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_RESOURCE_LIST_MEMBERS |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_RESOURCE_LIST_MEMBERS
|
| Subobject Name: | |
| Status: | VALID |
PA_RESOURCE_LIST_MEMBERS stores information about the individual
members which make up the resource list. All resource groups and
resources are regarded as members.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_RESOURCE_LIST_MEMBERS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 RESOURCE_LIST_MEMBER_ID
ZD_EDITION_NAME
|
| PA_RESOURCE_LIST_MEMBERS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESOURCE_LIST_ID
RESOURCE_ID
|
| PA_RESOURCE_LIST_MEMBERS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_MEMBER_ID
|
| PA_RESOURCE_LIST_MEMBERS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ADW_NOTIFY_FLAG
|
| PA_RESOURCE_LIST_MEMBERS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESOURCE_LIST_ID
OBJECT_ID
OBJECT_TYPE
RESOURCE_CLASS_ID
RES_FORMAT_ID
|
| PA_RESOURCE_LIST_MEMBERS_N6 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RESOURCE_LIST_ID
ALIAS
|
| PA_RESOURCE_LIST_MEMBERS_N7 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_MEMBER_ID
RESOURCE_LIST_ID
RESOURCE_LIST_MEMBER_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RESOURCE_LIST_MEMBER_ID | NUMBER | (15) | Yes | The system-generated number that uniquely identifies the resource list member. |
| RESOURCE_LIST_ID | NUMBER | (15) | Yes | The Identifier of the resource list to which the members belong to. |
| RESOURCE_ID | NUMBER | (15) | Yes | The identifier of the resource that is being used as a member of the resource list |
| ALIAS | VARCHAR2 | (80) | User-defined short name to be used in budgets entry, reports and Project Status Inquiry. | |
| PARENT_MEMBER_ID | NUMBER | Identifier of the resource group to which the member belongs to. This value would be Null in case of (1) resource groups or (2) resource lists which have not been grouped | ||
| SORT_ORDER | NUMBER | The order in which a resource appears in the resource list within its resource group or within the resource list | ||
| MEMBER_LEVEL | NUMBER | The level of the resource within the hierarchy. The value would be 1 for Parent or non grouped resources and 2 for second-level resources | ||
| DISPLAY_FLAG | VARCHAR2 | (1) | This indicates whether the resource is to be displayed to the user when a resource list is queried. All resources created through the resource lists form would have the value set to 'Y' | |
| ENABLED_FLAG | VARCHAR2 | (1) | Indicates whether the resource is to be enabled for use by other modules like Budgets etc. A disabled resource cannot be used. | |
| TRACK_AS_LABOR_FLAG | VARCHAR2 | (1) | This attribute specifies that when the resource is used to Budget it is tracked as labor and quantity is tracked as labor hours | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | Yes | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | Yes | Standard Who Column | |
| ADW_NOTIFY_FLAG | VARCHAR2 | (1) | The flag that indicates whether this row needs to be sent to the interface table or not. This column is required for Oracle Project Analysis Collection Pack. | |
| FUNDS_CONTROL_LEVEL_CODE | VARCHAR2 | (30) | 'The type of funds control for the resource or resource group level. | |
| PERSON_ID | NUMBER | (15) | Holds the identifier of the employee. | |
| JOB_ID | NUMBER | (15) | Holds the identifier of the Job. | |
| ORGANIZATION_ID | NUMBER | (15) | Holds the identifier of the Organization. | |
| VENDOR_ID | NUMBER | (15) | Holds the identifier of the Supplier. | |
| EXPENDITURE_TYPE | VARCHAR2 | (30) | Holds the identifier of the Expenditure Type. | |
| EVENT_TYPE | VARCHAR2 | (30) | Holds the identifier of the Event Type. | |
| NON_LABOR_RESOURCE | VARCHAR2 | (20) | Holds the identifier of the Non Labor Resource. | |
| EXPENDITURE_CATEGORY | VARCHAR2 | (30) | Holds the identifier of the Expenditure Category. | |
| REVENUE_CATEGORY | VARCHAR2 | (30) | Holds the identifier of the Revenue Category | |
| NON_LABOR_RESOURCE_ORG_ID | NUMBER | (15) | Holds the identifier of the Non Labor Resource's Organization. | |
| EVENT_TYPE_CLASSIFICATION | VARCHAR2 | (30) | Holds the identifier of the Event Type Classification. | |
| SYSTEM_LINKAGE_FUNCTION | VARCHAR2 | (30) | Holds the identifier of the System Linkage. | |
| PROJECT_ROLE_ID | NUMBER | (15) | Holds the identifier of project role. | |
| RESOURCE_FORMAT_ID | NUMBER | (15) | Holds the identifier of the Resource Format. | |
| RESOURCE_TYPE_ID | NUMBER | (15) | Holds the identifier of resource type. | |
| RESOURCE_TYPE_CODE | VARCHAR2 | (30) | olds the code used to identify the resource type. | |
| OBJECT_TYPE | VARCHAR2 | (30) | Indicates the resource class, organization or project to which the defaulting is applicable | |
| OBJECT_ID | NUMBER | (15) | Indicates the resource list or project depending upon the object type | |
| RESOURCE_CLASS_ID | NUMBER | (15) | Indicates the resource class | |
| RES_FORMAT_ID | NUMBER | (15) | Indicates the resource format - new resource formats | |
| SPREAD_CURVE_ID | NUMBER | (15) | Indicates the spread curve | |
| ETC_METHOD_CODE | VARCHAR2 | (30) | Indicates the ETC method | |
| MFC_COST_TYPE_ID | NUMBER | (15) | Indicates the manufacturing cost type | |
| PERSON_TYPE_CODE | VARCHAR2 | (30) | Indicates the type of person | |
| RES_TYPE_CODE | VARCHAR2 | (30) | Indicates the resource type code for the resource. | |
| RESOURCE_CLASS_CODE | VARCHAR2 | (30) | Indicates the code of the resource class | |
| RESOURCE_CLASS_FLAG | VARCHAR2 | (1) | Indicates the resource is a resource class | |
| FC_RES_TYPE_CODE | VARCHAR2 | (30) | Indicates the resource type of the financial category element | |
| BOM_RESOURCE_ID | NUMBER | (15) | Indicates the BOM labor resource | |
| INVENTORY_ITEM_ID | NUMBER | (15) | Indicates the inventory item | |
| ITEM_CATEGORY_ID | NUMBER | (15) | Indicates the inventory item category | |
| TEAM_ROLE | VARCHAR2 | (80) | The Team Role of the planning resource. | |
| MIGRATION_CODE | VARCHAR2 | (1) | Indicates whether the resource list member has been migrated - N = New (HTML model), M = Upgraded and NULL = Old. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE21 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE26 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE27 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE28 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE29 | VARCHAR2 | (150) | Descriptive flexfield | |
| ATTRIBUTE30 | VARCHAR2 | (150) | Descriptive flexfield | |
| RECORD_VERSION_NUMBER | NUMBER | (15) | Standard APPS column used for locking | |
| INCURRED_BY_RES_FLAG | VARCHAR2 | (1) | Indicates whether the resource columns(job_id, project_role_id, person_type_code, person_id) are used to track the incurred by Resources on financial element assignments. | |
| INCUR_BY_RES_CLASS_CODE | VARCHAR2 | (30) | Indicates the incurring resource class | |
| INCUR_BY_ROLE_ID | NUMBER | (15) | Indicates the incurring role. | |
| COPY_FROM_RL_FLAG | VARCHAR2 | (1) | Flag that specifies whether the list member was copied from a central resource list. | |
| WP_ELIGIBLE_FLAG | VARCHAR2 | (1) | Flag that specifies whether the list | |
| MIGRATED_RBS_ELEMENT_ID | NUMBER | (15) | The RBS Element ID that was created from the upgrade of this resource list member. | |
| UNIT_OF_MEASURE | VARCHAR2 | (30) | Unit of measure of the resource list | |
| COST_TYPE_ID | NUMBER | (15) | This indicates the cost type id. | |
| EXPENDITURE_TYPE_2 | VARCHAR2 | (30) | This indicates the Expenditure type for the resource. | |
| ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT RESOURCE_LIST_MEMBER_ID
, RESOURCE_LIST_ID
, RESOURCE_ID
, ALIAS
, PARENT_MEMBER_ID
, SORT_ORDER
, MEMBER_LEVEL
, DISPLAY_FLAG
, ENABLED_FLAG
, TRACK_AS_LABOR_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ADW_NOTIFY_FLAG
, FUNDS_CONTROL_LEVEL_CODE
, PERSON_ID
, JOB_ID
, ORGANIZATION_ID
, VENDOR_ID
, EXPENDITURE_TYPE
, EVENT_TYPE
, NON_LABOR_RESOURCE
, EXPENDITURE_CATEGORY
, REVENUE_CATEGORY
, NON_LABOR_RESOURCE_ORG_ID
, EVENT_TYPE_CLASSIFICATION
, SYSTEM_LINKAGE_FUNCTION
, PROJECT_ROLE_ID
, RESOURCE_FORMAT_ID
, RESOURCE_TYPE_ID
, RESOURCE_TYPE_CODE
, OBJECT_TYPE
, OBJECT_ID
, RESOURCE_CLASS_ID
, RES_FORMAT_ID
, SPREAD_CURVE_ID
, ETC_METHOD_CODE
, MFC_COST_TYPE_ID
, PERSON_TYPE_CODE
, RES_TYPE_CODE
, RESOURCE_CLASS_CODE
, RESOURCE_CLASS_FLAG
, FC_RES_TYPE_CODE
, BOM_RESOURCE_ID
, INVENTORY_ITEM_ID
, ITEM_CATEGORY_ID
, TEAM_ROLE
, MIGRATION_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, RECORD_VERSION_NUMBER
, INCURRED_BY_RES_FLAG
, INCUR_BY_RES_CLASS_CODE
, INCUR_BY_ROLE_ID
, COPY_FROM_RL_FLAG
, WP_ELIGIBLE_FLAG
, MIGRATED_RBS_ELEMENT_ID
, UNIT_OF_MEASURE
, COST_TYPE_ID
, EXPENDITURE_TYPE_2
, ZD_EDITION_NAME
FROM PA.PA_RESOURCE_LIST_MEMBERS;
PA.PA_RESOURCE_LIST_MEMBERS does not reference any database object
PA.PA_RESOURCE_LIST_MEMBERS is referenced by following:
PA
PA_RESOURCE_LIST_MEMBERS#
|
|
|
|