VIEW: PA.PA_RESOURCE_LIST_MEMBERS#

Source

View Text - Preformatted

select RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, RESOURCE_LIST_ID RESOURCE_LIST_ID, RESOURCE_ID RESOURCE_ID, ALIAS ALIAS, PARENT_MEMBER_ID PARENT_MEMBER_ID, SORT_ORDER SORT_ORDER, MEMBER_LEVEL MEMBER_LEVEL, DISPLAY_FLAG DISPLAY_FLAG, ENABLED_FLAG ENABLED_FLAG, TRACK_AS_LABOR_FLAG TRACK_AS_LABOR_FLAG, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG, FUNDS_CONTROL_LEVEL_CODE FUNDS_CONTROL_LEVEL_CODE, PERSON_ID PERSON_ID, JOB_ID JOB_ID, ORGANIZATION_ID ORGANIZATION_ID, VENDOR_ID VENDOR_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EVENT_TYPE EVENT_TYPE, NON_LABOR_RESOURCE NON_LABOR_RESOURCE, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY, REVENUE_CATEGORY REVENUE_CATEGORY, NON_LABOR_RESOURCE_ORG_ID NON_LABOR_RESOURCE_ORG_ID, EVENT_TYPE_CLASSIFICATION EVENT_TYPE_CLASSIFICATION, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION, PROJECT_ROLE_ID PROJECT_ROLE_ID, RESOURCE_FORMAT_ID RESOURCE_FORMAT_ID, RESOURCE_TYPE_ID RESOURCE_TYPE_ID, RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, RESOURCE_CLASS_ID RESOURCE_CLASS_ID, RES_FORMAT_ID RES_FORMAT_ID, SPREAD_CURVE_ID SPREAD_CURVE_ID, ETC_METHOD_CODE ETC_METHOD_CODE, MFC_COST_TYPE_ID MFC_COST_TYPE_ID, PERSON_TYPE_CODE PERSON_TYPE_CODE, RES_TYPE_CODE RES_TYPE_CODE, RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE, RESOURCE_CLASS_FLAG RESOURCE_CLASS_FLAG, FC_RES_TYPE_CODE FC_RES_TYPE_CODE, BOM_RESOURCE_ID BOM_RESOURCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ITEM_CATEGORY_ID ITEM_CATEGORY_ID, TEAM_ROLE TEAM_ROLE, MIGRATION_CODE MIGRATION_CODE, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ATTRIBUTE21 ATTRIBUTE21, ATTRIBUTE22 ATTRIBUTE22, ATTRIBUTE23 ATTRIBUTE23, ATTRIBUTE24 ATTRIBUTE24, ATTRIBUTE25 ATTRIBUTE25, ATTRIBUTE26 ATTRIBUTE26, ATTRIBUTE27 ATTRIBUTE27, ATTRIBUTE28 ATTRIBUTE28, ATTRIBUTE29 ATTRIBUTE29, ATTRIBUTE30 ATTRIBUTE30, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, INCURRED_BY_RES_FLAG INCURRED_BY_RES_FLAG, INCUR_BY_RES_CLASS_CODE INCUR_BY_RES_CLASS_CODE, INCUR_BY_ROLE_ID INCUR_BY_ROLE_ID, COPY_FROM_RL_FLAG COPY_FROM_RL_FLAG, WP_ELIGIBLE_FLAG WP_ELIGIBLE_FLAG, MIGRATED_RBS_ELEMENT_ID MIGRATED_RBS_ELEMENT_ID, UNIT_OF_MEASURE UNIT_OF_MEASURE, COST_TYPE_ID COST_TYPE_ID, EXPENDITURE_TYPE_2 EXPENDITURE_TYPE_2, ZD_EDITION_NAME ZD_EDITION_NAME from "PA"."PA_RESOURCE_LIST_MEMBERS"

View Text - HTML Formatted

SELECT RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, RESOURCE_LIST_ID RESOURCE_LIST_ID
, RESOURCE_ID RESOURCE_ID
, ALIAS ALIAS
, PARENT_MEMBER_ID PARENT_MEMBER_ID
, SORT_ORDER SORT_ORDER
, MEMBER_LEVEL MEMBER_LEVEL
, DISPLAY_FLAG DISPLAY_FLAG
, ENABLED_FLAG ENABLED_FLAG
, TRACK_AS_LABOR_FLAG TRACK_AS_LABOR_FLAG
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG
, FUNDS_CONTROL_LEVEL_CODE FUNDS_CONTROL_LEVEL_CODE
, PERSON_ID PERSON_ID
, JOB_ID JOB_ID
, ORGANIZATION_ID ORGANIZATION_ID
, VENDOR_ID VENDOR_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EVENT_TYPE EVENT_TYPE
, NON_LABOR_RESOURCE NON_LABOR_RESOURCE
, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, REVENUE_CATEGORY REVENUE_CATEGORY
, NON_LABOR_RESOURCE_ORG_ID NON_LABOR_RESOURCE_ORG_ID
, EVENT_TYPE_CLASSIFICATION EVENT_TYPE_CLASSIFICATION
, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, PROJECT_ROLE_ID PROJECT_ROLE_ID
, RESOURCE_FORMAT_ID RESOURCE_FORMAT_ID
, RESOURCE_TYPE_ID RESOURCE_TYPE_ID
, RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, RESOURCE_CLASS_ID RESOURCE_CLASS_ID
, RES_FORMAT_ID RES_FORMAT_ID
, SPREAD_CURVE_ID SPREAD_CURVE_ID
, ETC_METHOD_CODE ETC_METHOD_CODE
, MFC_COST_TYPE_ID MFC_COST_TYPE_ID
, PERSON_TYPE_CODE PERSON_TYPE_CODE
, RES_TYPE_CODE RES_TYPE_CODE
, RESOURCE_CLASS_CODE RESOURCE_CLASS_CODE
, RESOURCE_CLASS_FLAG RESOURCE_CLASS_FLAG
, FC_RES_TYPE_CODE FC_RES_TYPE_CODE
, BOM_RESOURCE_ID BOM_RESOURCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ITEM_CATEGORY_ID ITEM_CATEGORY_ID
, TEAM_ROLE TEAM_ROLE
, MIGRATION_CODE MIGRATION_CODE
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ATTRIBUTE21 ATTRIBUTE21
, ATTRIBUTE22 ATTRIBUTE22
, ATTRIBUTE23 ATTRIBUTE23
, ATTRIBUTE24 ATTRIBUTE24
, ATTRIBUTE25 ATTRIBUTE25
, ATTRIBUTE26 ATTRIBUTE26
, ATTRIBUTE27 ATTRIBUTE27
, ATTRIBUTE28 ATTRIBUTE28
, ATTRIBUTE29 ATTRIBUTE29
, ATTRIBUTE30 ATTRIBUTE30
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, INCURRED_BY_RES_FLAG INCURRED_BY_RES_FLAG
, INCUR_BY_RES_CLASS_CODE INCUR_BY_RES_CLASS_CODE
, INCUR_BY_ROLE_ID INCUR_BY_ROLE_ID
, COPY_FROM_RL_FLAG COPY_FROM_RL_FLAG
, WP_ELIGIBLE_FLAG WP_ELIGIBLE_FLAG
, MIGRATED_RBS_ELEMENT_ID MIGRATED_RBS_ELEMENT_ID
, UNIT_OF_MEASURE UNIT_OF_MEASURE
, COST_TYPE_ID COST_TYPE_ID
, EXPENDITURE_TYPE_2 EXPENDITURE_TYPE_2
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "PA"."PA_RESOURCE_LIST_MEMBERS"