View: PA_PROJECTS_PRM_V

Product:	PA - Projects
Description:	Single-Org
Implementation/DBA Data:	APPS.PA_PROJECTS_PRM_V

View Text

SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.LONG_NAME
, PPA.SEGMENT1
, PPA.LAST_UPDATE_DATE
, PPA.LAST_UPDATED_BY
, PPA.CREATION_DATE
, PPA.CREATED_BY
, PPA.LAST_UPDATE_LOGIN
, PPA.PROJECT_TYPE
, PPT.PROJECT_TYPE_CLASS_CODE
, PPA.CARRYING_OUT_ORGANIZATION_ID
, HOU.NAME
, PPA.PUBLIC_SECTOR_FLAG
, FL.MEANING
, PPA.PROJECT_STATUS_CODE
, PPS.PROJECT_STATUS_NAME
, PPS.PROJECT_SYSTEM_STATUS_CODE
, PPA.DESCRIPTION
, PPA.START_DATE
, PPA.COMPLETION_DATE
, PPA.CLOSED_DATE
, PPA.DISTRIBUTION_RULE
, PPA.LABOR_INVOICE_FORMAT_ID
, PPA.NON_LABOR_INVOICE_FORMAT_ID
, PPA.RETENTION_INVOICE_FORMAT_ID
, PPA.RETENTION_PERCENTAGE
, PPA.BILLING_OFFSET
, PPA.BILLING_CYCLE
, PPA.BILLING_CYCLE_ID
, PPA.LABOR_STD_BILL_RATE_SCHDL
, PPA.LABOR_BILL_RATE_ORG_ID
, PPA.LABOR_SCHEDULE_FIXED_DATE
, PPA.LABOR_SCHEDULE_DISCOUNT
, PPA.TEMPLATE_FLAG
, PPA.VERIFICATION_DATE
, PPA.CREATED_FROM_PROJECT_ID
, PPA2.NAME
, PPA.TEMPLATE_START_DATE_ACTIVE
, PPA.NON_LABOR_STD_BILL_RATE_SCHDL
, PPA.TEMPLATE_END_DATE_ACTIVE
, PPA.NON_LABOR_BILL_RATE_ORG_ID
, PPA.NON_LABOR_SCHEDULE_FIXED_DATE
, PPA.NON_LABOR_SCHEDULE_DISCOUNT
, PPA.LIMIT_TO_TXN_CONTROLS_FLAG
, PPA.PROJECT_LEVEL_FUNDING_FLAG
, PPA.INVOICE_COMMENT
, PPA.UNBILLED_RECEIVABLE_DR
, PPA.UNEARNED_REVENUE_CR
, PPA.REQUEST_ID
, PPA.PROGRAM_ID
, PPA.PROGRAM_APPLICATION_ID
, PPA.PROGRAM_UPDATE_DATE
, PPA.SUMMARY_FLAG
, PPA.ENABLED_FLAG
, PPA.SEGMENT2
, PPA.SEGMENT3
, PPA.SEGMENT4
, PPA.SEGMENT5
, PPA.SEGMENT6
, PPA.SEGMENT7
, PPA.SEGMENT8
, PPA.SEGMENT9
, PPA.SEGMENT10
, PPA.ATTRIBUTE_CATEGORY
, PPA.ATTRIBUTE1
, PPA.ATTRIBUTE2
, PPA.ATTRIBUTE3
, PPA.ATTRIBUTE4
, PPA.ATTRIBUTE5
, PPA.ATTRIBUTE6
, PPA.ATTRIBUTE7
, PPA.ATTRIBUTE8
, PPA.ATTRIBUTE9
, PPA.ATTRIBUTE10
, PPA.COST_IND_RATE_SCH_ID
, PPA.REV_IND_RATE_SCH_ID
, PPA.INV_IND_RATE_SCH_ID
, PPA.COST_IND_SCH_FIXED_DATE
, PPA.REV_IND_SCH_FIXED_DATE
, PPA.INV_IND_SCH_FIXED_DATE
, PPA.LABOR_SCH_TYPE
, PPA.NON_LABOR_SCH_TYPE
, PPA.OVR_COST_IND_RATE_SCH_ID
, PPA.OVR_REV_IND_RATE_SCH_ID
, PPA.OVR_INV_IND_RATE_SCH_ID
, PPA.ORG_ID
, PPA.PM_PRODUCT_CODE
, PPA.PM_PROJECT_REFERENCE
, PPA.ACTUAL_START_DATE
, PPA.ACTUAL_FINISH_DATE
, PPA.EARLY_START_DATE
, PPA.EARLY_FINISH_DATE
, PPA.LATE_START_DATE
, PPA.LATE_FINISH_DATE
, PPA.SCHEDULED_START_DATE
, PPA.SCHEDULED_FINISH_DATE
, PPA.ADW_NOTIFY_FLAG
, PPA.WF_STATUS_CODE
, PPA.PROJECT_CURRENCY_CODE
, PPA.ALLOW_CROSS_CHARGE_FLAG
, PPA.PROJECT_RATE_DATE
, PPA.PROJECT_RATE_TYPE
, PPA.OUTPUT_TAX_CODE
, PPA.RETENTION_TAX_CODE
, PPA.CC_PROCESS_LABOR_FLAG
, PPA.LABOR_TP_SCHEDULE_ID
, PPA.LABOR_TP_FIXED_DATE
, PPA.CC_PROCESS_NL_FLAG
, PPA.NL_TP_SCHEDULE_ID
, PPA.NL_TP_FIXED_DATE
, PPA.CC_TAX_TASK_ID
, PPA.BILL_JOB_GROUP_ID
, PJGB.DISPLAYED_NAME
, PPA.COST_JOB_GROUP_ID
, PJGC.DISPLAYED_NAME
, PPA.ROLE_LIST_ID
, PRL.NAME
, PPA.WORK_TYPE_ID
, PWT.NAME
, PPA.CALENDAR_ID
, JCV.CALENDAR_NAME
, PPA.LOCATION_ID
, PL.COUNTRY_CODE
, FTV.TERRITORY_SHORT_NAME
, PL.REGION
, PL.CITY
, PPA.PROBABILITY_MEMBER_ID
, PPM.PROBABILITY_PERCENTAGE
, PPA.PROJECT_VALUE
, PPA.EXPECTED_APPROVAL_DATE
, PPT.CC_PRVDR_FLAG
, PPT.ADMINISTRATIVE_FLAG
, PPT.UNASSIGNED_TIME
, PPA.INITIAL_TEAM_TEMPLATE_ID
, PTT.TEAM_TEMPLATE_NAME
, PPA.RECORD_VERSION_NUMBER
, PPA.JOB_BILL_RATE_SCHEDULE_ID
, PPA.EMP_BILL_RATE_SCHEDULE_ID
, PPA.COMPETENCE_MATCH_WT
, PPA.AVAILABILITY_MATCH_WT
, PPA.JOB_LEVEL_MATCH_WT
, PPA.ENABLE_AUTOMATED_SEARCH
, PPA.SEARCH_MIN_AVAILABILITY
, PPA.SEARCH_ORG_HIER_ID
, PPA.SEARCH_STARTING_ORG_ID
, PPA.SEARCH_COUNTRY_CODE
, PPA.MIN_CAND_SCORE_REQD_FOR_NOM
, POST.NAME
, HROU.NAME
, FTER.TERRITORY_SHORT_NAME
, PPA.PROJFUNC_CURRENCY_CODE
, PPA.PRIORITY_CODE
, PPA.SPLIT_COST_FROM_WORKPLAN_FLAG
, PPA.SPLIT_COST_FROM_BILL_FLAG
, PPA.ADV_ACTION_SET_ID
, PAS.ACTION_SET_NAME
, PPA.START_ADV_ACTION_SET_FLAG
, PPA.TARGET_START_DATE
, PPA.TARGET_FINISH_DATE
, PPA.BASELINE_START_DATE
, PPA.BASELINE_FINISH_DATE
, PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE(PPA.PROJECT_ID)
, PA_PROJECT_DATES_UTILS.GET_PROJECT_FINISH_DATE(PPA.PROJECT_ID)
, PPA.REVALUATE_FUNDING_FLAG
, PPA.INCLUDE_GAINS_LOSSES_FLAG
, PPA.SCHEDULED_AS_OF_DATE
, PPA.BASELINE_AS_OF_DATE
, PPA.SECURITY_LEVEL
, PPA.LABOR_DISC_REASON_CODE
, PPA.NON_LABOR_DISC_REASON_CODE
, PPA.ACTUAL_AS_OF_DATE
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(PPA.SCHEDULED_DURATION)
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(PPA.BASELINE_DURATION)
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(PPA.ACTUAL_DURATION)
, PPA.SYS_PROGRAM_FLAG
, PPA.ALLOW_MULTI_PROGRAM_ROLLUP
, PPA.PROJ_REQ_RES_FORMAT_ID
, PPA.PROJ_ASGMT_RES_FORMAT_ID
, PPA.FUNDING_APPROVAL_STATUS_CODE
, PPSF.PROJECT_STATUS_NAME
, PPSF.PROJECT_SYSTEM_STATUS_CODE
FROM PA_PROJECTS_ALL PPA
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, PA_PROJECT_STATUSES PPS
, PA_PROJECT_STATUSES PPSF
, PER_JOB_GROUPS PJGC
, PER_JOB_GROUPS PJGB
, PA_ROLE_LISTS PRL
, PA_WORK_TYPES_VL PWT
, JTF_CALENDARS_VL JCV
, PA_LOCATIONS PL
, FND_TERRITORIES_VL FTV
, PA_PROJECT_TYPES_ALL PPT
, PA_PROBABILITY_MEMBERS PPM
, PA_TEAM_TEMPLATES PTT
, PER_ORGANIZATION_STRUCTURES POST
, HR_ORGANIZATION_UNITS HROU
, FND_TERRITORIES_VL FTER
, PER_ORG_STRUCTURE_VERSIONS POSV
, FND_LOOKUPS FL
, PA_PROJECTS_ALL PPA2
, PA_ACTION_SETS PAS
WHERE PPA.CARRYING_OUT_ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND USERENV('LANG') = HOU.LANGUAGE
AND PPA.PROJECT_STATUS_CODE = PPS.PROJECT_STATUS_CODE
AND PPA.FUNDING_APPROVAL_STATUS_CODE = PPSF.PROJECT_STATUS_CODE (+)
AND PPA.COST_JOB_GROUP_ID = PJGC.JOB_GROUP_ID (+)
AND PPA.BILL_JOB_GROUP_ID = PJGB.JOB_GROUP_ID (+)
AND PPA.ROLE_LIST_ID = PRL.ROLE_LIST_ID (+)
AND PPA.WORK_TYPE_ID = PWT.WORK_TYPE_ID (+)
AND PPA.CALENDAR_ID = JCV.CALENDAR_ID (+)
AND PPA.LOCATION_ID = PL.LOCATION_ID (+)
AND PL.COUNTRY_CODE = FTV.TERRITORY_CODE (+)
AND PPA.PROBABILITY_MEMBER_ID = PPM.PROBABILITY_MEMBER_ID (+)
AND PPA.PROJECT_TYPE = PPT.PROJECT_TYPE
AND PPA.ORG_ID = PPT.ORG_ID
AND PPA.INITIAL_TEAM_TEMPLATE_ID = PTT.TEAM_TEMPLATE_ID (+)
AND PPA.SEARCH_ORG_HIER_ID = POSV.ORG_STRUCTURE_VERSION_ID (+)
AND POSV.ORGANIZATION_STRUCTURE_ID = POST.ORGANIZATION_STRUCTURE_ID (+)
AND PPA.SEARCH_STARTING_ORG_ID = HROU.ORGANIZATION_ID (+)
AND PPA.SEARCH_COUNTRY_CODE = FTER.TERRITORY_CODE (+)
AND FL.LOOKUP_CODE = PPA.PUBLIC_SECTOR_FLAG
AND FL.LOOKUP_TYPE = 'YES_NO'
AND PPA.CREATED_FROM_PROJECT_ID = PPA2.PROJECT_ID(+)
AND PPA.ADV_ACTION_SET_ID = PAS.ACTION_SET_ID(+)

Columns