VIEW: APPS.PA_PROJECTS_AMG_V

Source

View Text - Preformatted

SELECT PROJECT_ID , NAME , LONG_NAME , SEGMENT1 , LAST_UPDATE_DATE , LAST_UPDATED_BY , CREATION_DATE , CREATED_BY , LAST_UPDATE_LOGIN , PROJECT_TYPE , CARRYING_OUT_ORGANIZATION_ID , PUBLIC_SECTOR_FLAG , PROJECT_STATUS_CODE , DESCRIPTION , START_DATE , COMPLETION_DATE , CLOSED_DATE , DISTRIBUTION_RULE , LABOR_INVOICE_FORMAT_ID , NON_LABOR_INVOICE_FORMAT_ID , RETENTION_INVOICE_FORMAT_ID , RETENTION_PERCENTAGE , BILLING_OFFSET , BILLING_CYCLE , BILLING_CYCLE_ID , LABOR_STD_BILL_RATE_SCHDL , LABOR_BILL_RATE_ORG_ID , LABOR_SCHEDULE_FIXED_DATE , LABOR_SCHEDULE_DISCOUNT , TEMPLATE_FLAG , VERIFICATION_DATE , CREATED_FROM_PROJECT_ID , TEMPLATE_START_DATE_ACTIVE , NON_LABOR_STD_BILL_RATE_SCHDL , TEMPLATE_END_DATE_ACTIVE , NON_LABOR_BILL_RATE_ORG_ID , NON_LABOR_SCHEDULE_FIXED_DATE , NON_LABOR_SCHEDULE_DISCOUNT , LIMIT_TO_TXN_CONTROLS_FLAG , PROJECT_LEVEL_FUNDING_FLAG , INVOICE_COMMENT , UNBILLED_RECEIVABLE_DR , UNEARNED_REVENUE_CR , REQUEST_ID , PROGRAM_ID , PROGRAM_APPLICATION_ID , PROGRAM_UPDATE_DATE , SUMMARY_FLAG , ENABLED_FLAG , SEGMENT2 , SEGMENT3 , SEGMENT4 , SEGMENT5 , SEGMENT6 , SEGMENT7 , SEGMENT8 , SEGMENT9 , SEGMENT10 , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , COST_IND_RATE_SCH_ID , REV_IND_RATE_SCH_ID , INV_IND_RATE_SCH_ID , COST_IND_SCH_FIXED_DATE , REV_IND_SCH_FIXED_DATE , INV_IND_SCH_FIXED_DATE , LABOR_SCH_TYPE , NON_LABOR_SCH_TYPE , OVR_COST_IND_RATE_SCH_ID , OVR_REV_IND_RATE_SCH_ID , OVR_INV_IND_RATE_SCH_ID , ORG_ID ,PM_PRODUCT_CODE ,PM_PROJECT_REFERENCE ,ACTUAL_START_DATE ,ACTUAL_FINISH_DATE ,EARLY_START_DATE ,EARLY_FINISH_DATE ,LATE_START_DATE ,LATE_FINISH_DATE ,SCHEDULED_START_DATE ,SCHEDULED_FINISH_DATE ,ADW_NOTIFY_FLAG ,WF_STATUS_CODE ,PROJECT_CURRENCY_CODE ,ALLOW_CROSS_CHARGE_FLAG ,PROJECT_RATE_DATE ,PROJECT_RATE_TYPE ,OUTPUT_TAX_CODE ,RETENTION_TAX_CODE ,CC_PROCESS_LABOR_FLAG ,LABOR_TP_SCHEDULE_ID ,LABOR_TP_FIXED_DATE ,CC_PROCESS_NL_FLAG ,NL_TP_SCHEDULE_ID ,NL_TP_FIXED_DATE ,CC_TAX_TASK_ID ,bill_job_group_id ,cost_job_group_id ,ROLE_LIST_ID ,WORK_TYPE_ID ,CALENDAR_ID ,LOCATION_ID ,PROBABILITY_MEMBER_ID ,PROJECT_VALUE ,EXPECTED_APPROVAL_DATE ,INITIAL_TEAM_TEMPLATE_ID ,RECORD_VERSION_NUMBER ,JOB_BILL_RATE_SCHEDULE_ID ,EMP_BILL_RATE_SCHEDULE_ID ,NON_LAB_STD_BILL_RT_SCH_ID ,invproc_currency_type ,revproc_currency_code ,project_bil_rate_date_code ,project_bil_rate_type ,project_bil_rate_date ,project_bil_exchange_rate ,projfunc_currency_code ,projfunc_bil_rate_date_code ,projfunc_bil_rate_type ,projfunc_bil_rate_date ,projfunc_bil_exchange_rate ,funding_rate_date_code ,funding_rate_type ,funding_rate_date ,funding_exchange_rate ,baseline_funding_flag ,multi_currency_billing_flag ,competence_match_wt ,availability_match_wt ,job_level_match_wt ,enable_automated_search ,search_min_availability ,search_org_hier_id ,search_starting_org_id ,search_country_code ,min_cand_score_reqd_for_nom ,inv_by_bill_trans_curr_flag ,projfunc_cost_rate_type ,projfunc_cost_rate_date ,assign_precedes_task ,SPLIT_COST_FROM_WORKPLAN_FLAG ,SPLIT_COST_FROM_BILL_FLAG ,priority_code ,RETN_BILLING_INV_FORMAT_ID ,RETN_ACCOUNTING_FLAG ,ADV_ACTION_SET_ID ,START_ADV_ACTION_SET_FLAG ,target_start_date ,target_finish_date ,baseline_start_date ,baseline_finish_date ,revaluate_funding_flag ,include_gains_losses_flag ,scheduled_as_of_date ,baseline_as_of_date ,security_level ,labor_disc_reason_code ,non_labor_disc_reason_code ,actual_as_of_date ,pa_proj_elements_utils.convert_hr_to_days(scheduled_duration) ,pa_proj_elements_utils.convert_hr_to_days(baseline_duration) ,pa_proj_elements_utils.convert_hr_to_days(actual_duration) ,nvl(pa_project_structure_utils.check_workplan_enabled(project_id), 'N') ,nvl(pa_workplan_attr_utils.check_wp_versioning_enabled(project_id), 'N') ,pa_project_structure_utils.check_sharing_enabled(project_id) ,pa_workplan_attr_utils.check_auto_pub_enabled(project_id) ,pa_workplan_attr_utils.check_approval_required(project_id) ,pa_workplan_attr_utils.check_auto_pub_at_creation(project_id) ,asset_allocation_method ,capital_event_processing ,cint_rate_sch_id ,CINT_ELIGIBLE_FLAG ,CINT_STOP_DATE ,STRUCTURE_SHARING_CODE ,ENABLE_TOP_TASK_CUSTOMER_FLAG ,ENABLE_TOP_TASK_INV_MTH_FLAG ,REVENUE_ACCRUAL_METHOD ,INVOICE_METHOD ,PROJFUNC_ATTR_FOR_AR_FLAG FROM PA_PROJECTS

View Text - HTML Formatted

SELECT PROJECT_ID
, NAME
, LONG_NAME
, SEGMENT1
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, PROJECT_TYPE
, CARRYING_OUT_ORGANIZATION_ID
, PUBLIC_SECTOR_FLAG
, PROJECT_STATUS_CODE
, DESCRIPTION
, START_DATE
, COMPLETION_DATE
, CLOSED_DATE
, DISTRIBUTION_RULE
, LABOR_INVOICE_FORMAT_ID
, NON_LABOR_INVOICE_FORMAT_ID
, RETENTION_INVOICE_FORMAT_ID
, RETENTION_PERCENTAGE
, BILLING_OFFSET
, BILLING_CYCLE
, BILLING_CYCLE_ID
, LABOR_STD_BILL_RATE_SCHDL
, LABOR_BILL_RATE_ORG_ID
, LABOR_SCHEDULE_FIXED_DATE
, LABOR_SCHEDULE_DISCOUNT
, TEMPLATE_FLAG
, VERIFICATION_DATE
, CREATED_FROM_PROJECT_ID
, TEMPLATE_START_DATE_ACTIVE
, NON_LABOR_STD_BILL_RATE_SCHDL
, TEMPLATE_END_DATE_ACTIVE
, NON_LABOR_BILL_RATE_ORG_ID
, NON_LABOR_SCHEDULE_FIXED_DATE
, NON_LABOR_SCHEDULE_DISCOUNT
, LIMIT_TO_TXN_CONTROLS_FLAG
, PROJECT_LEVEL_FUNDING_FLAG
, INVOICE_COMMENT
, UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, SUMMARY_FLAG
, ENABLED_FLAG
, SEGMENT2
, SEGMENT3
, SEGMENT4
, SEGMENT5
, SEGMENT6
, SEGMENT7
, SEGMENT8
, SEGMENT9
, SEGMENT10
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, COST_IND_RATE_SCH_ID
, REV_IND_RATE_SCH_ID
, INV_IND_RATE_SCH_ID
, COST_IND_SCH_FIXED_DATE
, REV_IND_SCH_FIXED_DATE
, INV_IND_SCH_FIXED_DATE
, LABOR_SCH_TYPE
, NON_LABOR_SCH_TYPE
, OVR_COST_IND_RATE_SCH_ID
, OVR_REV_IND_RATE_SCH_ID
, OVR_INV_IND_RATE_SCH_ID
, ORG_ID
, PM_PRODUCT_CODE
, PM_PROJECT_REFERENCE
, ACTUAL_START_DATE
, ACTUAL_FINISH_DATE
, EARLY_START_DATE
, EARLY_FINISH_DATE
, LATE_START_DATE
, LATE_FINISH_DATE
, SCHEDULED_START_DATE
, SCHEDULED_FINISH_DATE
, ADW_NOTIFY_FLAG
, WF_STATUS_CODE
, PROJECT_CURRENCY_CODE
, ALLOW_CROSS_CHARGE_FLAG
, PROJECT_RATE_DATE
, PROJECT_RATE_TYPE
, OUTPUT_TAX_CODE
, RETENTION_TAX_CODE
, CC_PROCESS_LABOR_FLAG
, LABOR_TP_SCHEDULE_ID
, LABOR_TP_FIXED_DATE
, CC_PROCESS_NL_FLAG
, NL_TP_SCHEDULE_ID
, NL_TP_FIXED_DATE
, CC_TAX_TASK_ID
, BILL_JOB_GROUP_ID
, COST_JOB_GROUP_ID
, ROLE_LIST_ID
, WORK_TYPE_ID
, CALENDAR_ID
, LOCATION_ID
, PROBABILITY_MEMBER_ID
, PROJECT_VALUE
, EXPECTED_APPROVAL_DATE
, INITIAL_TEAM_TEMPLATE_ID
, RECORD_VERSION_NUMBER
, JOB_BILL_RATE_SCHEDULE_ID
, EMP_BILL_RATE_SCHEDULE_ID
, NON_LAB_STD_BILL_RT_SCH_ID
, INVPROC_CURRENCY_TYPE
, REVPROC_CURRENCY_CODE
, PROJECT_BIL_RATE_DATE_CODE
, PROJECT_BIL_RATE_TYPE
, PROJECT_BIL_RATE_DATE
, PROJECT_BIL_EXCHANGE_RATE
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_BIL_RATE_DATE_CODE
, PROJFUNC_BIL_RATE_TYPE
, PROJFUNC_BIL_RATE_DATE
, PROJFUNC_BIL_EXCHANGE_RATE
, FUNDING_RATE_DATE_CODE
, FUNDING_RATE_TYPE
, FUNDING_RATE_DATE
, FUNDING_EXCHANGE_RATE
, BASELINE_FUNDING_FLAG
, MULTI_CURRENCY_BILLING_FLAG
, COMPETENCE_MATCH_WT
, AVAILABILITY_MATCH_WT
, JOB_LEVEL_MATCH_WT
, ENABLE_AUTOMATED_SEARCH
, SEARCH_MIN_AVAILABILITY
, SEARCH_ORG_HIER_ID
, SEARCH_STARTING_ORG_ID
, SEARCH_COUNTRY_CODE
, MIN_CAND_SCORE_REQD_FOR_NOM
, INV_BY_BILL_TRANS_CURR_FLAG
, PROJFUNC_COST_RATE_TYPE
, PROJFUNC_COST_RATE_DATE
, ASSIGN_PRECEDES_TASK
, SPLIT_COST_FROM_WORKPLAN_FLAG
, SPLIT_COST_FROM_BILL_FLAG
, PRIORITY_CODE
, RETN_BILLING_INV_FORMAT_ID
, RETN_ACCOUNTING_FLAG
, ADV_ACTION_SET_ID
, START_ADV_ACTION_SET_FLAG
, TARGET_START_DATE
, TARGET_FINISH_DATE
, BASELINE_START_DATE
, BASELINE_FINISH_DATE
, REVALUATE_FUNDING_FLAG
, INCLUDE_GAINS_LOSSES_FLAG
, SCHEDULED_AS_OF_DATE
, BASELINE_AS_OF_DATE
, SECURITY_LEVEL
, LABOR_DISC_REASON_CODE
, NON_LABOR_DISC_REASON_CODE
, ACTUAL_AS_OF_DATE
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(SCHEDULED_DURATION)
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(BASELINE_DURATION)
, PA_PROJ_ELEMENTS_UTILS.CONVERT_HR_TO_DAYS(ACTUAL_DURATION)
, NVL(PA_PROJECT_STRUCTURE_UTILS.CHECK_WORKPLAN_ENABLED(PROJECT_ID)
, 'N')
, NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(PROJECT_ID)
, 'N')
, PA_PROJECT_STRUCTURE_UTILS.CHECK_SHARING_ENABLED(PROJECT_ID)
, PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_PUB_ENABLED(PROJECT_ID)
, PA_WORKPLAN_ATTR_UTILS.CHECK_APPROVAL_REQUIRED(PROJECT_ID)
, PA_WORKPLAN_ATTR_UTILS.CHECK_AUTO_PUB_AT_CREATION(PROJECT_ID)
, ASSET_ALLOCATION_METHOD
, CAPITAL_EVENT_PROCESSING
, CINT_RATE_SCH_ID
, CINT_ELIGIBLE_FLAG
, CINT_STOP_DATE
, STRUCTURE_SHARING_CODE
, ENABLE_TOP_TASK_CUSTOMER_FLAG
, ENABLE_TOP_TASK_INV_MTH_FLAG
, REVENUE_ACCRUAL_METHOD
, INVOICE_METHOD
, PROJFUNC_ATTR_FOR_AR_FLAG
FROM PA_PROJECTS