VIEW: APPS.PA_PROJECTS_PRM_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)