VIEW: PA.PA_RESOURCE_MAPS#

Source

View Text - Preformatted

select 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, RESOURCE_LIST_ASSIGNMENT_ID RESOURCE_LIST_ASSIGNMENT_ID, RESOURCE_LIST_ID RESOURCE_LIST_ID, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID, RESOURCE_ID RESOURCE_ID, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "PA"."PA_RESOURCE_MAPS"

View Text - HTML Formatted

SELECT 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
, RESOURCE_LIST_ASSIGNMENT_ID RESOURCE_LIST_ASSIGNMENT_ID
, RESOURCE_LIST_ID RESOURCE_LIST_ID
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
, RESOURCE_ID RESOURCE_ID
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "PA"."PA_RESOURCE_MAPS"