VIEW: PA.PA_RESOURCE_TXN_ATTRIBUTES#

Source

View Text - Preformatted

select RESOURCE_TXN_ATTRIBUTE_ID RESOURCE_TXN_ATTRIBUTE_ID, RESOURCE_ID RESOURCE_ID, 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_FORMAT_ID RESOURCE_FORMAT_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_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROJECT_ROLE_ID PROJECT_ROLE_ID, PARTY_ID PARTY_ID from "PA"."PA_RESOURCE_TXN_ATTRIBUTES"

View Text - HTML Formatted

SELECT RESOURCE_TXN_ATTRIBUTE_ID RESOURCE_TXN_ATTRIBUTE_ID
, RESOURCE_ID RESOURCE_ID
, 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_FORMAT_ID RESOURCE_FORMAT_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_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROJECT_ROLE_ID PROJECT_ROLE_ID
, PARTY_ID PARTY_ID
FROM "PA"."PA_RESOURCE_TXN_ATTRIBUTES"