VIEW: PA.PA_PROJECT_ASGMTS_AR#

Source

View Text - Preformatted

select PURGE_BATCH_ID PURGE_BATCH_ID, PURGE_PROJECT_ID PURGE_PROJECT_ID, PURGE_RELEASE PURGE_RELEASE, ADDITIONAL_INFORMATION ADDITIONAL_INFORMATION, APPRVL_STATUS_CODE APPRVL_STATUS_CODE, ASSIGNMENT_EFFORT ASSIGNMENT_EFFORT, ASSIGNMENT_ID ASSIGNMENT_ID, ASSIGNMENT_NAME ASSIGNMENT_NAME, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER, ASSIGNMENT_TEMPLATE_ID ASSIGNMENT_TEMPLATE_ID, ASSIGNMENT_TYPE ASSIGNMENT_TYPE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, AVAILABILITY_MATCH_WEIGHTING AVAILABILITY_MATCH_WEIGHTING, BILL_RATE_CURR_OVERRIDE BILL_RATE_CURR_OVERRIDE, BILL_RATE_OVERRIDE BILL_RATE_OVERRIDE, CALENDAR_ID CALENDAR_ID, CALENDAR_TYPE CALENDAR_TYPE, COMPETENCE_MATCH_WEIGHTING COMPETENCE_MATCH_WEIGHTING, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, DESCRIPTION DESCRIPTION, ENABLE_AUTO_CAND_NOM_FLAG ENABLE_AUTO_CAND_NOM_FLAG, END_DATE END_DATE, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EXPENDITURE_TYPE_CLASS EXPENDITURE_TYPE_CLASS, EXPENSE_LIMIT EXPENSE_LIMIT, EXPENSE_LIMIT_CURRENCY_CODE EXPENSE_LIMIT_CURRENCY_CODE, EXPENSE_OWNER EXPENSE_OWNER, EXTENSION_POSSIBLE EXTENSION_POSSIBLE, FCST_JOB_GROUP_ID FCST_JOB_GROUP_ID, FCST_JOB_ID FCST_JOB_ID, FCST_TP_AMOUNT_TYPE FCST_TP_AMOUNT_TYPE, JOB_LEVEL_MATCH_WEIGHTING JOB_LEVEL_MATCH_WEIGHTING, LAST_AUTO_SEARCH_DATE LAST_AUTO_SEARCH_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LOCATION_ID LOCATION_ID, MARKUP_PERCENT MARKUP_PERCENT, MARKUP_PERCENT_OVERRIDE MARKUP_PERCENT_OVERRIDE, MASS_WF_IN_PROGRESS_FLAG MASS_WF_IN_PROGRESS_FLAG, MAX_RESOURCE_JOB_LEVEL MAX_RESOURCE_JOB_LEVEL, MIN_RESOURCE_JOB_LEVEL MIN_RESOURCE_JOB_LEVEL, MULTIPLE_STATUS_FLAG MULTIPLE_STATUS_FLAG, NOTE_TO_APPROVER NOTE_TO_APPROVER, NO_OF_ACTIVE_CANDIDATES NO_OF_ACTIVE_CANDIDATES, PENDING_APPROVAL_FLAG PENDING_APPROVAL_FLAG, PROJECT_ID PROJECT_ID, PROJECT_PARTY_ID PROJECT_PARTY_ID, PROJECT_ROLE_ID PROJECT_ROLE_ID, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, RESOURCE_CALENDAR_PERCENT RESOURCE_CALENDAR_PERCENT, RESOURCE_ID RESOURCE_ID, REVENUE_BILL_RATE REVENUE_BILL_RATE, REVENUE_CURRENCY_CODE REVENUE_CURRENCY_CODE, SEARCH_COUNTRY_CODE SEARCH_COUNTRY_CODE, SEARCH_EXP_ORG_STRUCT_VER_ID SEARCH_EXP_ORG_STRUCT_VER_ID, SEARCH_EXP_START_ORG_ID SEARCH_EXP_START_ORG_ID, SEARCH_MIN_AVAILABILITY SEARCH_MIN_AVAILABILITY, SEARCH_MIN_CANDIDATE_SCORE SEARCH_MIN_CANDIDATE_SCORE, SOURCE_ASSIGNMENT_ID SOURCE_ASSIGNMENT_ID, STAFFING_PRIORITY_CODE STAFFING_PRIORITY_CODE, START_DATE START_DATE, STATUS_CODE STATUS_CODE, TEMPLATE_FLAG TEMPLATE_FLAG, TP_CALC_BASE_CODE_OVERRIDE TP_CALC_BASE_CODE_OVERRIDE, TP_CURRENCY_OVERRIDE TP_CURRENCY_OVERRIDE, TP_PERCENT_APPLIED_OVERRIDE TP_PERCENT_APPLIED_OVERRIDE, TP_RATE_OVERRIDE TP_RATE_OVERRIDE, WORK_TYPE_ID WORK_TYPE_ID, DISCOUNT_PERCENTAGE DISCOUNT_PERCENTAGE, RATE_DISC_REASON_CODE RATE_DISC_REASON_CODE, STAFFING_OWNER_PERSON_ID STAFFING_OWNER_PERSON_ID, TRANSFER_PRICE_RATE TRANSFER_PRICE_RATE, TRANSFER_PR_RATE_CURR TRANSFER_PR_RATE_CURR, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID from "PA"."PA_PROJECT_ASGMTS_AR"

View Text - HTML Formatted

SELECT PURGE_BATCH_ID PURGE_BATCH_ID
, PURGE_PROJECT_ID PURGE_PROJECT_ID
, PURGE_RELEASE PURGE_RELEASE
, ADDITIONAL_INFORMATION ADDITIONAL_INFORMATION
, APPRVL_STATUS_CODE APPRVL_STATUS_CODE
, ASSIGNMENT_EFFORT ASSIGNMENT_EFFORT
, ASSIGNMENT_ID ASSIGNMENT_ID
, ASSIGNMENT_NAME ASSIGNMENT_NAME
, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, ASSIGNMENT_TEMPLATE_ID ASSIGNMENT_TEMPLATE_ID
, ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, AVAILABILITY_MATCH_WEIGHTING AVAILABILITY_MATCH_WEIGHTING
, BILL_RATE_CURR_OVERRIDE BILL_RATE_CURR_OVERRIDE
, BILL_RATE_OVERRIDE BILL_RATE_OVERRIDE
, CALENDAR_ID CALENDAR_ID
, CALENDAR_TYPE CALENDAR_TYPE
, COMPETENCE_MATCH_WEIGHTING COMPETENCE_MATCH_WEIGHTING
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, DESCRIPTION DESCRIPTION
, ENABLE_AUTO_CAND_NOM_FLAG ENABLE_AUTO_CAND_NOM_FLAG
, END_DATE END_DATE
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EXPENDITURE_TYPE_CLASS EXPENDITURE_TYPE_CLASS
, EXPENSE_LIMIT EXPENSE_LIMIT
, EXPENSE_LIMIT_CURRENCY_CODE EXPENSE_LIMIT_CURRENCY_CODE
, EXPENSE_OWNER EXPENSE_OWNER
, EXTENSION_POSSIBLE EXTENSION_POSSIBLE
, FCST_JOB_GROUP_ID FCST_JOB_GROUP_ID
, FCST_JOB_ID FCST_JOB_ID
, FCST_TP_AMOUNT_TYPE FCST_TP_AMOUNT_TYPE
, JOB_LEVEL_MATCH_WEIGHTING JOB_LEVEL_MATCH_WEIGHTING
, LAST_AUTO_SEARCH_DATE LAST_AUTO_SEARCH_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOCATION_ID LOCATION_ID
, MARKUP_PERCENT MARKUP_PERCENT
, MARKUP_PERCENT_OVERRIDE MARKUP_PERCENT_OVERRIDE
, MASS_WF_IN_PROGRESS_FLAG MASS_WF_IN_PROGRESS_FLAG
, MAX_RESOURCE_JOB_LEVEL MAX_RESOURCE_JOB_LEVEL
, MIN_RESOURCE_JOB_LEVEL MIN_RESOURCE_JOB_LEVEL
, MULTIPLE_STATUS_FLAG MULTIPLE_STATUS_FLAG
, NOTE_TO_APPROVER NOTE_TO_APPROVER
, NO_OF_ACTIVE_CANDIDATES NO_OF_ACTIVE_CANDIDATES
, PENDING_APPROVAL_FLAG PENDING_APPROVAL_FLAG
, PROJECT_ID PROJECT_ID
, PROJECT_PARTY_ID PROJECT_PARTY_ID
, PROJECT_ROLE_ID PROJECT_ROLE_ID
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, RESOURCE_CALENDAR_PERCENT RESOURCE_CALENDAR_PERCENT
, RESOURCE_ID RESOURCE_ID
, REVENUE_BILL_RATE REVENUE_BILL_RATE
, REVENUE_CURRENCY_CODE REVENUE_CURRENCY_CODE
, SEARCH_COUNTRY_CODE SEARCH_COUNTRY_CODE
, SEARCH_EXP_ORG_STRUCT_VER_ID SEARCH_EXP_ORG_STRUCT_VER_ID
, SEARCH_EXP_START_ORG_ID SEARCH_EXP_START_ORG_ID
, SEARCH_MIN_AVAILABILITY SEARCH_MIN_AVAILABILITY
, SEARCH_MIN_CANDIDATE_SCORE SEARCH_MIN_CANDIDATE_SCORE
, SOURCE_ASSIGNMENT_ID SOURCE_ASSIGNMENT_ID
, STAFFING_PRIORITY_CODE STAFFING_PRIORITY_CODE
, START_DATE START_DATE
, STATUS_CODE STATUS_CODE
, TEMPLATE_FLAG TEMPLATE_FLAG
, TP_CALC_BASE_CODE_OVERRIDE TP_CALC_BASE_CODE_OVERRIDE
, TP_CURRENCY_OVERRIDE TP_CURRENCY_OVERRIDE
, TP_PERCENT_APPLIED_OVERRIDE TP_PERCENT_APPLIED_OVERRIDE
, TP_RATE_OVERRIDE TP_RATE_OVERRIDE
, WORK_TYPE_ID WORK_TYPE_ID
, DISCOUNT_PERCENTAGE DISCOUNT_PERCENTAGE
, RATE_DISC_REASON_CODE RATE_DISC_REASON_CODE
, STAFFING_OWNER_PERSON_ID STAFFING_OWNER_PERSON_ID
, TRANSFER_PRICE_RATE TRANSFER_PRICE_RATE
, TRANSFER_PR_RATE_CURR TRANSFER_PR_RATE_CURR
, RESOURCE_LIST_MEMBER_ID RESOURCE_LIST_MEMBER_ID
FROM "PA"."PA_PROJECT_ASGMTS_AR"