ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 4E70003718590869E0630100007FE835Y select null action_, null status_, null message_, null request_id_, null modified_columns_, -- project identifiers haouv.name operating_unit, ppa.segment1 project_number, ppa.name project_name, (select ppa_t.name from pa_projects_all ppa_t where ppa_t.project_id=ppa.created_from_project_id) template, ppa.long_name, ppa.project_type, pps.project_status_name project_status, haouv2.name organization, ppf.full_name project_manager, ppa.description, -- dates ppa.start_date, ppa.completion_date, -- classification decode(ppa.public_sector_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) public_sector, pdr.meaning distribution_rule, -- currency ppa.project_currency_code, ppa.projfunc_currency_code, gdct1.user_conversion_type project_rate_type, ppa.project_rate_date, gdct2.user_conversion_type projfunc_cost_rate_type, ppa.projfunc_cost_rate_date, -- billing setup xxen_util.meaning(ppa.labor_sch_type,'PROJECT SCHEDULE TYPE',275) labor_schedule_type, ppa.labor_schedule_fixed_date, ppa.labor_schedule_discount, xxen_util.meaning(ppa.labor_disc_reason_code,'RATE AND DISCOUNT REASON',275) labor_discount_reason, xxen_util.meaning(ppa.non_labor_sch_type,'PROJECT SCHEDULE TYPE',275) non_labor_schedule_type, haouv4.name non_labor_bill_rate_org, ppa.non_labor_schedule_fixed_date, ppa.non_labor_schedule_discount, xxen_util.meaning(ppa.non_labor_disc_reason_code,'RATE AND DISCOUNT REASON',275) non_labor_discount_reason, psbrsa1.std_bill_rate_schedule employee_bill_rate_schedule, psbrsa2.std_bill_rate_schedule job_bill_rate_schedule, psbrsa3.std_bill_rate_schedule non_labor_bill_rate_schedule, -- burden schedules pirsab2.ind_rate_sch_name revenue_burden_schedule, ppa.rev_ind_sch_fixed_date revenue_ind_sched_fixed_dt, pirsab3.ind_rate_sch_name invoice_burden_schedule, ppa.inv_ind_sch_fixed_date invoice_ind_sched_fixed_dt, -- billing currency xxen_util.meaning(ppa.invproc_currency_type,'INVPROCE_CURR_TYPE',275) invproc_currency_type, ppa.revproc_currency_code, xxen_util.meaning(ppa.project_bil_rate_date_code,'BILL_RATE_DATE_CODE',275) project_bil_rate_date_code, gdct3.user_conversion_type project_bil_rate_type, ppa.project_bil_rate_date, ppa.project_bil_exchange_rate, xxen_util.meaning(ppa.projfunc_bil_rate_date_code,'BILL_RATE_DATE_CODE',275) projfunc_bil_rate_date_code, gdct4.user_conversion_type projfunc_bil_rate_type, ppa.projfunc_bil_rate_date, ppa.projfunc_bil_exchange_rate, xxen_util.meaning(ppa.funding_rate_date_code,'BILL_RATE_DATE_CODE',275) funding_rate_date_code, gdct5.user_conversion_type funding_rate_type, ppa.funding_rate_date, ppa.funding_exchange_rate, -- flags decode(ppa.baseline_funding_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) baseline_funding, decode(ppa.multi_currency_billing_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) multi_currency_billing, decode(ppa.inv_by_bill_trans_curr_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) invoice_by_bill_trans_currency, decode(ppa.assign_precedes_task,'Y',xxen_util.meaning('Y','YES_NO',0)) assign_precedes_task, decode(ppa.split_cost_from_workplan_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) split_cost_from_workplan, decode(ppa.split_cost_from_bill_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) split_cost_from_billing, decode(ppa.sys_program_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) system_program, decode(ppa.allow_multi_program_rollup,'Y',xxen_util.meaning('Y','YES_NO',0)) allow_multi_program_rollup, decode(ppa.projfunc_attr_for_ar_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) projfunc_attr_for_ar, decode(ppa.revaluate_funding_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) revaluate_funding, decode(ppa.include_gains_losses_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) include_gains_losses, decode(ppa.retn_accounting_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) retention_accounting, decode(ppa.cint_eligible_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) capital_interest_eligible, ppa.cint_stop_date capital_interest_stop_date, decode(ppa.enable_top_task_customer_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) enable_top_task_customer, decode(ppa.enable_top_task_inv_mth_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) enable_top_task_invoice_method, decode(ppa.limit_to_txn_controls_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) limit_to_txn_controls, -- cross charge / transfer price decode(ppa.allow_cross_charge_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) allow_cross_charge, decode(ppa.cc_process_labor_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) cross_charge_process_labor, decode(ppa.cc_process_nl_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) cross_charge_process_non_labor, pctsb1.name labor_transfer_price_schedule, ppa.labor_tp_fixed_date labor_transfer_price_fixed_dt, pctsb2.name non_labor_transfer_price_sched, ppa.nl_tp_fixed_date non_labor_trans_price_fxd_dt, -- setup pwtv.name work_type, jtcv.calendar_name calendar, hla.location_code location, prl.name role_list, to_char(ppm.probability_percentage) probability, ppa.project_value, ppa.expected_approval_date, (select pl.meaning from pa_lookups pl where pl.lookup_type='PA_PROJECT_PRIORITY_CODE' and pl.lookup_code=ppa.priority_code) priority_code, pjgv1.displayed_name cost_job_group, pjgv2.displayed_name bill_job_group, (select flvv.meaning from fnd_lookup_values_vl flvv where flvv.lookup_type='PA_SECURITY_LEVEL' and flvv.lookup_code=to_char(ppa.security_level) and flvv.enabled_flag='Y' and flvv.security_group_id=0) security_level, -- retention / invoice format pif.name retention_billing_invoice_fmt, -- asset / capital xxen_util.meaning(ppa.asset_allocation_method,'ASSET_ALLOCATION_METHOD',275) asset_allocation_method, xxen_util.meaning(ppa.capital_event_processing,'CAPITAL_EVENT_PROCESSING',275) capital_event_processing, pirsab4.ind_rate_sch_name capital_interest_rate_schedule, -- tax ppa.output_tax_code, ppa.retention_tax_code, -- DFF xxen_util.display_flexfield_context(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category) attribute_category, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE1',ppa.rowid,ppa.attribute1) attribute1, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE2',ppa.rowid,ppa.attribute2) attribute2, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE3',ppa.rowid,ppa.attribute3) attribute3, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE4',ppa.rowid,ppa.attribute4) attribute4, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE5',ppa.rowid,ppa.attribute5) attribute5, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE6',ppa.rowid,ppa.attribute6) attribute6, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE7',ppa.rowid,ppa.attribute7) attribute7, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE8',ppa.rowid,ppa.attribute8) attribute8, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE9',ppa.rowid,ppa.attribute9) attribute9, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE10',ppa.rowid,ppa.attribute10) attribute10, -- customer (select hp.party_name from pa_project_customers ppc, hz_cust_accounts hca, hz_parties hp where ppc.project_id=ppa.project_id and ppc.customer_id=hca.cust_account_id and hca.party_id=hp.party_id and rownum=1) customer_name, (select pl.meaning from pa_lookups pl where pl.lookup_type='PM_PRODUCT_CODE' and pl.lookup_code=ppa.pm_product_code) pm_product_code, -- hidden ppa.project_id, 0 upload_row from pa_projects_all ppa, pa_project_statuses pps, hr_all_organization_units_vl haouv, hr_all_organization_units_vl haouv2, hr_all_organization_units_vl haouv4, pa_distribution_rules pdr, per_all_people_f ppf, pa_project_parties ppp, gl_daily_conversion_types gdct1, gl_daily_conversion_types gdct2, gl_daily_conversion_types gdct3, gl_daily_conversion_types gdct4, gl_daily_conversion_types gdct5, pa_std_bill_rate_schedules_all psbrsa1, pa_std_bill_rate_schedules_all psbrsa2, pa_std_bill_rate_schedules_all psbrsa3, pa_ind_rate_schedules_all_bg pirsab2, pa_ind_rate_schedules_all_bg pirsab3, pa_ind_rate_schedules_all_bg pirsab4, pa_cc_tp_schedules_bg pctsb1, pa_cc_tp_schedules_bg pctsb2, pa_work_types_vl pwtv, jtf_calendars_vl jtcv, hr_locations_all hla, pa_role_lists prl, pa_probability_members ppm, per_job_groups_v pjgv1, per_job_groups_v pjgv2, pa_invoice_formats pif where 1=1 and ppa.template_flag='N' and ppa.project_status_code=pps.project_status_code and pps.status_type='PROJECT' and ppa.org_id=haouv.organization_id and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and ppa.carrying_out_organization_id=haouv2.organization_id and ppa.non_labor_bill_rate_org_id=haouv4.organization_id(+) and ppa.distribution_rule=pdr.distribution_rule(+) and ppa.project_id=ppp.project_id(+) and ppp.project_role_id(+)=1 and nvl(ppp.end_date_active(+),sysdate)>=sysdate and ppp.resource_source_id=ppf.person_id(+) and trunc(sysdate) between ppf.effective_start_date(+) and ppf.effective_end_date(+) and ppa.project_rate_type=gdct1.conversion_type(+) and ppa.projfunc_cost_rate_type=gdct2.conversion_type(+) and ppa.project_bil_rate_type=gdct3.conversion_type(+) and ppa.projfunc_bil_rate_type=gdct4.conversion_type(+) and ppa.funding_rate_type=gdct5.conversion_type(+) and ppa.emp_bill_rate_schedule_id=psbrsa1.bill_rate_sch_id(+) and ppa.job_bill_rate_schedule_id=psbrsa2.bill_rate_sch_id(+) and ppa.non_lab_std_bill_rt_sch_id=psbrsa3.bill_rate_sch_id(+) and ppa.rev_ind_rate_sch_id=pirsab2.ind_rate_sch_id(+) and ppa.inv_ind_rate_sch_id=pirsab3.ind_rate_sch_id(+) and ppa.cint_rate_sch_id=pirsab4.ind_rate_sch_id(+) and ppa.labor_tp_schedule_id=pctsb1.tp_schedule_id(+) and ppa.nl_tp_schedule_id=pctsb2.tp_schedule_id(+) and ppa.work_type_id=pwtv.work_type_id(+) and ppa.calendar_id=jtcv.calendar_id(+) and ppa.location_id=hla.location_id(+) and ppa.role_list_id=prl.role_list_id(+) and ppa.probability_member_id=ppm.probability_member_id(+) and ppa.cost_job_group_id=pjgv1.job_group_id(+) and ppa.bill_job_group_id=pjgv2.job_group_id(+) and ppa.retn_billing_inv_format_id=pif.invoice_format_id(+) Rewrite: simplified SQL with joins, LOVs with IDs, Yes-only flags, DFF with LOVs/comments, Success SQL, parameters, template defaulting, project manager editable U A xxen_pa_upload.upload_project xxen_pa_upload.validate_project_required( p_project_number=>:$column$.project_number, p_project_name=>:$column$.project_name, p_template=>:$column$.template, p_long_name=>:$column$.long_name, p_description=>:$column$.description, p_organization=>:$column$.organization, p_project_manager=>:$column$.project_manager, p_start_date=>:$column$.start_date, p_completion_date=>:$column$.completion_date, p_customer_name=>:$column$.customer_name ) US PA Project Upload PA Project Upload =================== Create and update Projects in Oracle Projects using the pa_project_pub API. Create Mode: - Select a Template to populate default values (project type, organization, billing setup, etc.) - Template-specific required fields (customer, organization, completion date, etc.) are validated in Excel before upload - Project Manager can differ from the template PM — the template PM is replaced post-creation - PM Product Code determines which external PM system owns the project (default: Primavera). Do NOT use Microsoft Project — it blocks date updates due to Oracle bug 12954344. Update Mode: - Use "Create, Update" upload mode to download existing projects, modify fields, and re-upload - Only changed fields are updated — unchanged fields are preserved - Project Manager changes: the current active PM is end-dated and the new PM is assigned from today - If no active PM exists (all end-dated), the new PM is simply assigned - Start Date and Completion Date can be changed, cleared, or added - Customer and PM Product Code are set on creation only and not changed on update Field Length Limits: - Project Number: 25 characters - Project Name: 30 characters - Long Name: 240 characters - Description: 250 characters Supported Fields: Project identifiers, dates, billing setup (labor/non-labor schedules, bill rate schedules, burden schedules), billing currency settings, flags (baseline funding, multi-currency billing, cross charge, retention, capital interest, etc.), transfer price schedules, work type, calendar, location, role list, probability, priority, job groups, security level, invoice format, asset/capital settings, tax codes, DFF attributes (1-10), customer, and PM product code. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 1=1 haouv.name=:p_operating_unit LOV custom Y select pouv.operating_unit value, null description from pa_operating_units_v pouv order by value Y US Operating Unit 3 30 1=1 ppa.segment1=:p_project_number LOV custom Y Y select ppv.segment1 value, ppv.project_type||': '||ppv.name description from pa_projects_v ppv where ppv.template_flag='N' and xxen_util.contains(:$flex$.operating_unit,ppv.operating_unit)='Y' US Project Number 4 40 1=1 ppa.name=:p_project_name LOV custom Y select ppv.name value, ppv.project_type||': '||ppv.segment1 description from pa_projects_v ppv where ppv.template_flag='N' and xxen_util.contains(:$flex$.operating_unit,ppv.operating_unit)='Y' US Project Name 5 50 1=1 ppa.project_type=:p_project_type LOV custom Y select pptv.project_type value, pptv.description from pa_project_types_v pptv, pa_operating_units_v pouv where pptv.org_id=pouv.org_id and xxen_util.contains(:$flex$.operating_unit,pouv.operating_unit)='Y' order by pptv.project_type US Project Type 6 60 1=1 pps.project_status_name=:p_project_status LOV custom Y select pps.project_status_name value, pps.description from pa_project_statuses pps where pps.status_type='PROJECT' order by value US Project Status :$flex$.operating_unit Operating Unit Project Name :$flex$.operating_unit Operating Unit Project Number :$flex$.operating_unit Operating Unit Project Type 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 OPERATING_UNIT LOV custom varchar2 Y select pouv.org_id id, pouv.operating_unit value, null description from pa_operating_units_v pouv order by value Y 7 PROJECT_NUMBER LOV custom varchar2 Y select ppa.segment1 value, ppa.name||' ('||ppa.project_type||')' description from pa_projects_all ppa, pa_operating_units_v pouv where ppa.template_flag='N' and ppa.org_id=pouv.org_id and pouv.operating_unit=:$column$.operating_unit order by value Y 8 PROJECT_NAME Char varchar2 select xxen_pa_upload.project_default_value(:$column$.project_number,null,'PROJECT_NAME') from dual Y 9 TEMPLATE LOV custom varchar2 Y select ppa.project_id id, ppa.name value, ppa.project_type||': '||ppa.segment1 description from pa_projects_all ppa, pa_operating_units_v pouv where ppa.template_flag='Y' and nvl(ppa.template_start_date_active,trunc(sysdate))<=trunc(sysdate) and nvl(ppa.template_end_date_active,trunc(sysdate))>=trunc(sysdate) and ppa.org_id=pouv.org_id and pouv.operating_unit=:$column$.operating_unit order by value select xxen_pa_upload.project_default_value(:$column$.project_number,null,'TEMPLATE') from dual Y 10 LONG_NAME Char varchar2 select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'LONG_NAME') from dual 11 PROJECT_TYPE Char varchar2 select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJECT_TYPE') from dual Y 12 PROJECT_STATUS LOV custom varchar2 Y select pps.project_status_code id, pps.project_status_name value, pps.project_system_status_code description from pa_project_statuses pps where pps.status_type='PROJECT' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJECT_STATUS') from dual 13 ORGANIZATION LOV custom varchar2 Y select popv.organization_id id, popv.name value, null description from pa_organizations_project_v popv, pa_operating_units_v pouv where popv.org_id=pouv.org_id and pouv.operating_unit=:$column$.operating_unit and trunc(sysdate) between popv.date_from and nvl(popv.date_to,sysdate) and popv.active_flag='Y' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ORGANIZATION') from dual 14 PROJECT_MANAGER LOV custom varchar2 Y select pe.person_id id, pe.full_name value, pe.employee_number description from pa_employees pe where pe.active='*' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJECT_MANAGER') from dual Y 15 DESCRIPTION Char varchar2 select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'DESCRIPTION') from dual 16 START_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'START_DATE') from dual Y 17 COMPLETION_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'COMPLETION_DATE') from dual 18 PUBLIC_SECTOR LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PUBLIC_SECTOR') from dual 19 DISTRIBUTION_RULE LOV custom varchar2 Y select pdr.distribution_rule id, pdr.meaning value, null description from pa_distribution_rules pdr order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'DISTRIBUTION_RULE') from dual 20 PROJECT_CURRENCY_CODE LOV custom varchar2 Y select fc.currency_code value, fc.name description from fnd_currencies_vl fc where fc.enabled_flag='Y' and fc.currency_flag='Y' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJECT_CURRENCY_CODE') from dual 21 PROJFUNC_CURRENCY_CODE LOV custom varchar2 Y select fc.currency_code value, fc.name description from fnd_currencies_vl fc where fc.enabled_flag='Y' and fc.currency_flag='Y' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJFUNC_CURRENCY_CODE') from dual 22 PROJECT_RATE_TYPE LOV custom varchar2 Y select gdct.conversion_type id, gdct.user_conversion_type value, null description from gl_daily_conversion_types gdct order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJECT_RATE_TYPE') from dual 23 PROJECT_RATE_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'PROJECT_RATE_DATE') from dual 24 PROJFUNC_COST_RATE_TYPE LOV custom varchar2 Y select gdct.conversion_type id, gdct.user_conversion_type value, null description from gl_daily_conversion_types gdct order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJFUNC_COST_RATE_TYPE') from dual 25 PROJFUNC_COST_RATE_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'PROJFUNC_COST_RATE_DATE') from dual 26 LABOR_SCHEDULE_TYPE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='PROJECT SCHEDULE TYPE' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'LABOR_SCHEDULE_TYPE') from dual 27 LABOR_SCHEDULE_FIXED_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'LABOR_SCHEDULE_FIXED_DATE') from dual 28 LABOR_SCHEDULE_DISCOUNT Number number select xxen_pa_upload.project_default_number(:$column$.project_number,:$column$.template,'LABOR_SCHEDULE_DISCOUNT') from dual 29 LABOR_DISCOUNT_REASON LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='RATE AND DISCOUNT REASON' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'LABOR_DISCOUNT_REASON') from dual 30 NON_LABOR_SCHEDULE_TYPE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='PROJECT SCHEDULE TYPE' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'NON_LABOR_SCHEDULE_TYPE') from dual 31 NON_LABOR_BILL_RATE_ORG LOV custom varchar2 Y select haouv.organization_id id, haouv.name value, null description from hr_all_organization_units_vl haouv order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'NON_LABOR_BILL_RATE_ORG') from dual 32 NON_LABOR_SCHEDULE_FIXED_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'NON_LABOR_SCHEDULE_FIXED_DATE') from dual 33 NON_LABOR_SCHEDULE_DISCOUNT Number number select xxen_pa_upload.project_default_number(:$column$.project_number,:$column$.template,'NON_LABOR_SCHEDULE_DISCOUNT') from dual 34 NON_LABOR_DISCOUNT_REASON LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='RATE AND DISCOUNT REASON' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'NON_LABOR_DISCOUNT_REASON') from dual 35 EMPLOYEE_BILL_RATE_SCHEDULE LOV custom varchar2 Y select psbrsa.bill_rate_sch_id id, psbrsa.std_bill_rate_schedule value, null description from pa_std_bill_rate_schedules_all psbrsa where psbrsa.schedule_type='EMPLOYEE' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'EMPLOYEE_BILL_RATE_SCHEDULE') from dual 36 JOB_BILL_RATE_SCHEDULE LOV custom varchar2 Y select psbrsa.bill_rate_sch_id id, psbrsa.std_bill_rate_schedule value, null description from pa_std_bill_rate_schedules_all psbrsa where psbrsa.schedule_type='JOB' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'JOB_BILL_RATE_SCHEDULE') from dual 37 NON_LABOR_BILL_RATE_SCHEDULE LOV custom varchar2 Y select psbrsa.bill_rate_sch_id id, psbrsa.std_bill_rate_schedule value, null description from pa_std_bill_rate_schedules_all psbrsa where psbrsa.schedule_type='NON-LABOR' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'NON_LABOR_BILL_RATE_SCHEDULE') from dual 38 REVENUE_BURDEN_SCHEDULE LOV custom varchar2 Y select pirsab.ind_rate_sch_id id, pirsab.ind_rate_sch_name value, null description from pa_ind_rate_schedules_all_bg pirsab order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'REVENUE_BURDEN_SCHEDULE') from dual 39 REVENUE_IND_SCHED_FIXED_DT Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'REVENUE_IND_SCHED_FIXED_DT') from dual Revenue Ind Schedule Fixed Date 40 INVOICE_BURDEN_SCHEDULE LOV custom varchar2 Y select pirsab.ind_rate_sch_id id, pirsab.ind_rate_sch_name value, null description from pa_ind_rate_schedules_all_bg pirsab order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'INVOICE_BURDEN_SCHEDULE') from dual 41 INVOICE_IND_SCHED_FIXED_DT Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'INVOICE_IND_SCHED_FIXED_DT') from dual Invoice Ind Schedule Fixed Date 42 INVPROC_CURRENCY_TYPE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='INVPROCE_CURR_TYPE' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'INVPROC_CURRENCY_TYPE') from dual 43 REVPROC_CURRENCY_CODE LOV custom varchar2 Y select fc.currency_code value, fc.name description from fnd_currencies_vl fc where fc.enabled_flag='Y' and fc.currency_flag='Y' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'REVPROC_CURRENCY_CODE') from dual 44 PROJECT_BIL_RATE_DATE_CODE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='BILL_RATE_DATE_CODE' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJECT_BIL_RATE_DATE_CODE') from dual 45 PROJECT_BIL_RATE_TYPE LOV custom varchar2 Y select gdct.conversion_type id, gdct.user_conversion_type value, null description from gl_daily_conversion_types gdct order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJECT_BIL_RATE_TYPE') from dual 46 PROJECT_BIL_RATE_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'PROJECT_BIL_RATE_DATE') from dual 47 PROJECT_BIL_EXCHANGE_RATE Number number select xxen_pa_upload.project_default_number(:$column$.project_number,:$column$.template,'PROJECT_BIL_EXCHANGE_RATE') from dual 48 PROJFUNC_BIL_RATE_DATE_CODE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='BILL_RATE_DATE_CODE' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJFUNC_BIL_RATE_DATE_CODE') from dual 49 PROJFUNC_BIL_RATE_TYPE LOV custom varchar2 Y select gdct.conversion_type id, gdct.user_conversion_type value, null description from gl_daily_conversion_types gdct order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJFUNC_BIL_RATE_TYPE') from dual 50 PROJFUNC_BIL_RATE_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'PROJFUNC_BIL_RATE_DATE') from dual 51 PROJFUNC_BIL_EXCHANGE_RATE Number number select xxen_pa_upload.project_default_number(:$column$.project_number,:$column$.template,'PROJFUNC_BIL_EXCHANGE_RATE') from dual 52 FUNDING_RATE_DATE_CODE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='BILL_RATE_DATE_CODE' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'FUNDING_RATE_DATE_CODE') from dual 53 FUNDING_RATE_TYPE LOV custom varchar2 Y select gdct.conversion_type id, gdct.user_conversion_type value, null description from gl_daily_conversion_types gdct order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'FUNDING_RATE_TYPE') from dual 54 FUNDING_RATE_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'FUNDING_RATE_DATE') from dual 55 FUNDING_EXCHANGE_RATE Number number select xxen_pa_upload.project_default_number(:$column$.project_number,:$column$.template,'FUNDING_EXCHANGE_RATE') from dual 56 BASELINE_FUNDING LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'BASELINE_FUNDING') from dual 57 MULTI_CURRENCY_BILLING LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'MULTI_CURRENCY_BILLING') from dual 58 INVOICE_BY_BILL_TRANS_CURRENCY LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'INVOICE_BY_BILL_TRANS_CURRENCY') from dual 59 ASSIGN_PRECEDES_TASK LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ASSIGN_PRECEDES_TASK') from dual 60 SPLIT_COST_FROM_WORKPLAN LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'SPLIT_COST_FROM_WORKPLAN') from dual 61 SPLIT_COST_FROM_BILLING LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'SPLIT_COST_FROM_BILLING') from dual 62 SYSTEM_PROGRAM LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'SYSTEM_PROGRAM') from dual 63 ALLOW_MULTI_PROGRAM_ROLLUP LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ALLOW_MULTI_PROGRAM_ROLLUP') from dual 64 PROJFUNC_ATTR_FOR_AR LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROJFUNC_ATTR_FOR_AR') from dual 65 REVALUATE_FUNDING LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'REVALUATE_FUNDING') from dual 66 INCLUDE_GAINS_LOSSES LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'INCLUDE_GAINS_LOSSES') from dual 67 RETENTION_ACCOUNTING LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'RETENTION_ACCOUNTING') from dual 68 CAPITAL_INTEREST_ELIGIBLE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'CAPITAL_INTEREST_ELIGIBLE') from dual 69 CAPITAL_INTEREST_STOP_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'CAPITAL_INTEREST_STOP_DATE') from dual 70 ENABLE_TOP_TASK_CUSTOMER LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ENABLE_TOP_TASK_CUSTOMER') from dual 71 ENABLE_TOP_TASK_INVOICE_METHOD LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ENABLE_TOP_TASK_INVOICE_METHOD') from dual 72 LIMIT_TO_TXN_CONTROLS LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'LIMIT_TO_TXN_CONTROLS') from dual Y 73 ALLOW_CROSS_CHARGE LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ALLOW_CROSS_CHARGE') from dual 74 CROSS_CHARGE_PROCESS_LABOR LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'CROSS_CHARGE_PROCESS_LABOR') from dual 75 CROSS_CHARGE_PROCESS_NON_LABOR LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'CROSS_CHARGE_PROCESS_NON_LABOR') from dual 76 LABOR_TRANSFER_PRICE_SCHEDULE LOV custom varchar2 Y select pctsb.tp_schedule_id id, pctsb.name value, null description from pa_cc_tp_schedules_bg pctsb order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'LABOR_TRANSFER_PRICE_SCHEDULE') from dual 77 LABOR_TRANSFER_PRICE_FIXED_DT Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'LABOR_TRANSFER_PRICE_FIXED_DT') from dual Labor Transfer Price Fixed Date 78 NON_LABOR_TRANSFER_PRICE_SCHED LOV custom varchar2 Y select pctsb.tp_schedule_id id, pctsb.name value, null description from pa_cc_tp_schedules_bg pctsb order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'NON_LABOR_TRANSFER_PRICE_SCHED') from dual Non Labor Transfer Price Schedule 79 NON_LABOR_TRANS_PRICE_FXD_DT Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'NON_LABOR_TRANS_PRICE_FXD_DT') from dual Non Labor Transfer Price Fixed Date 80 WORK_TYPE LOV custom varchar2 Y select pwtv.work_type_id id, pwtv.name value, pwtv.description from pa_work_types_vl pwtv where trunc(sysdate) between trunc(pwtv.start_date_active) and nvl(pwtv.end_date_active,trunc(sysdate)) order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'WORK_TYPE') from dual 81 CALENDAR LOV custom varchar2 Y select jtcv.calendar_id id, jtcv.calendar_name value, null description from jtf_calendars_vl jtcv order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'CALENDAR') from dual 82 LOCATION LOV custom varchar2 Y select hla.location_id id, hla.location_code value, hla.description from hr_locations_all hla where nvl(hla.inactive_date,sysdate+1)>sysdate order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'LOCATION') from dual 83 ROLE_LIST LOV custom varchar2 Y select prl.role_list_id id, prl.name value, prl.description from pa_role_lists prl where nvl(prl.end_date_active,sysdate+1)>sysdate order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ROLE_LIST') from dual 84 PROBABILITY LOV custom varchar2 Y select ppm.probability_member_id id, to_char(ppm.probability_percentage) value, null description from pa_probability_members ppm order by ppm.probability_percentage select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PROBABILITY') from dual 85 PROJECT_VALUE Number number select xxen_pa_upload.project_default_number(:$column$.project_number,:$column$.template,'PROJECT_VALUE') from dual 86 EXPECTED_APPROVAL_DATE Date date select xxen_pa_upload.project_default_date(:$column$.project_number,:$column$.template,'EXPECTED_APPROVAL_DATE') from dual 87 PRIORITY_CODE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='PA_PROJECT_PRIORITY_CODE' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'PRIORITY_CODE') from dual 88 COST_JOB_GROUP LOV custom varchar2 Y select pjgv.job_group_id id, pjgv.displayed_name value, null description from per_job_groups_v pjgv order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'COST_JOB_GROUP') from dual 89 BILL_JOB_GROUP LOV custom varchar2 Y select pjgv.job_group_id id, pjgv.displayed_name value, null description from per_job_groups_v pjgv order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'BILL_JOB_GROUP') from dual 90 SECURITY_LEVEL LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PA_SECURITY_LEVEL' and flvv.enabled_flag='Y' and flvv.security_group_id=0 order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'SECURITY_LEVEL') from dual 91 RETENTION_BILLING_INVOICE_FMT LOV custom varchar2 Y select pif.invoice_format_id id, pif.name value, null description from pa_invoice_formats pif order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'RETENTION_BILLING_INVOICE_FMT') from dual Retention Billing Invoice Format 92 ASSET_ALLOCATION_METHOD LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='ASSET_ALLOCATION_METHOD' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ASSET_ALLOCATION_METHOD') from dual 93 CAPITAL_EVENT_PROCESSING LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='CAPITAL_EVENT_PROCESSING' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'CAPITAL_EVENT_PROCESSING') from dual 94 CAPITAL_INTEREST_RATE_SCHEDULE LOV custom varchar2 Y select pirsab.ind_rate_sch_id id, pirsab.ind_rate_sch_name value, null description from pa_ind_rate_schedules_all_bg pirsab order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'CAPITAL_INTEREST_RATE_SCHEDULE') from dual 95 OUTPUT_TAX_CODE LOV custom varchar2 Y select zb.lookup_code value, zb.meaning description from zx_output_classifications_v zb where zb.enabled_flag='Y' and zb.org_id=-99 order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'OUTPUT_TAX_CODE') from dual 96 RETENTION_TAX_CODE LOV custom varchar2 Y select zb.lookup_code value, zb.meaning description from zx_output_classifications_v zb where zb.enabled_flag='Y' and zb.org_id=-99 order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'RETENTION_TAX_CODE') from dual 97 ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=275 and fdfcv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE_CATEGORY') from dual 98 ATTRIBUTE1 LOV custom varchar2 select case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,1,instrb(lov.column_value,'~')-1) else lov.column_value end value, case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,instrb(lov.column_value,'~')+1) end description from table(xxen_util.dff_attribute_lov(275,'PA_PROJECTS_DESC_FLEX',:$column$.attribute_category,'ATTRIBUTE1',:$column$.attribute1,:$column$.attribute2,:$column$.attribute3,:$column$.attribute4,:$column$.attribute5,:$column$.attribute6,:$column$.attribute7,:$column$.attribute8,:$column$.attribute9,:$column$.attribute10)) lov order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE1') from dual select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE1' 99 ATTRIBUTE2 LOV custom varchar2 select case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,1,instrb(lov.column_value,'~')-1) else lov.column_value end value, case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,instrb(lov.column_value,'~')+1) end description from table(xxen_util.dff_attribute_lov(275,'PA_PROJECTS_DESC_FLEX',:$column$.attribute_category,'ATTRIBUTE2',:$column$.attribute1,:$column$.attribute2,:$column$.attribute3,:$column$.attribute4,:$column$.attribute5,:$column$.attribute6,:$column$.attribute7,:$column$.attribute8,:$column$.attribute9,:$column$.attribute10)) lov order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE2') from dual select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE2' 100 ATTRIBUTE3 LOV custom varchar2 select case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,1,instrb(lov.column_value,'~')-1) else lov.column_value end value, case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,instrb(lov.column_value,'~')+1) end description from table(xxen_util.dff_attribute_lov(275,'PA_PROJECTS_DESC_FLEX',:$column$.attribute_category,'ATTRIBUTE3',:$column$.attribute1,:$column$.attribute2,:$column$.attribute3,:$column$.attribute4,:$column$.attribute5,:$column$.attribute6,:$column$.attribute7,:$column$.attribute8,:$column$.attribute9,:$column$.attribute10)) lov order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE3') from dual select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE3' 101 ATTRIBUTE4 LOV custom varchar2 select case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,1,instrb(lov.column_value,'~')-1) else lov.column_value end value, case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,instrb(lov.column_value,'~')+1) end description from table(xxen_util.dff_attribute_lov(275,'PA_PROJECTS_DESC_FLEX',:$column$.attribute_category,'ATTRIBUTE4',:$column$.attribute1,:$column$.attribute2,:$column$.attribute3,:$column$.attribute4,:$column$.attribute5,:$column$.attribute6,:$column$.attribute7,:$column$.attribute8,:$column$.attribute9,:$column$.attribute10)) lov order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE4') from dual select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE4' 102 ATTRIBUTE5 LOV custom varchar2 select case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,1,instrb(lov.column_value,'~')-1) else lov.column_value end value, case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,instrb(lov.column_value,'~')+1) end description from table(xxen_util.dff_attribute_lov(275,'PA_PROJECTS_DESC_FLEX',:$column$.attribute_category,'ATTRIBUTE5',:$column$.attribute1,:$column$.attribute2,:$column$.attribute3,:$column$.attribute4,:$column$.attribute5,:$column$.attribute6,:$column$.attribute7,:$column$.attribute8,:$column$.attribute9,:$column$.attribute10)) lov order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE5') from dual select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE5' 103 ATTRIBUTE6 LOV custom varchar2 select case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,1,instrb(lov.column_value,'~')-1) else lov.column_value end value, case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,instrb(lov.column_value,'~')+1) end description from table(xxen_util.dff_attribute_lov(275,'PA_PROJECTS_DESC_FLEX',:$column$.attribute_category,'ATTRIBUTE6',:$column$.attribute1,:$column$.attribute2,:$column$.attribute3,:$column$.attribute4,:$column$.attribute5,:$column$.attribute6,:$column$.attribute7,:$column$.attribute8,:$column$.attribute9,:$column$.attribute10)) lov order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE6') from dual select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE6' 104 ATTRIBUTE7 LOV custom varchar2 select case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,1,instrb(lov.column_value,'~')-1) else lov.column_value end value, case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,instrb(lov.column_value,'~')+1) end description from table(xxen_util.dff_attribute_lov(275,'PA_PROJECTS_DESC_FLEX',:$column$.attribute_category,'ATTRIBUTE7',:$column$.attribute1,:$column$.attribute2,:$column$.attribute3,:$column$.attribute4,:$column$.attribute5,:$column$.attribute6,:$column$.attribute7,:$column$.attribute8,:$column$.attribute9,:$column$.attribute10)) lov order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE7') from dual select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE7' 105 ATTRIBUTE8 LOV custom varchar2 select case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,1,instrb(lov.column_value,'~')-1) else lov.column_value end value, case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,instrb(lov.column_value,'~')+1) end description from table(xxen_util.dff_attribute_lov(275,'PA_PROJECTS_DESC_FLEX',:$column$.attribute_category,'ATTRIBUTE8',:$column$.attribute1,:$column$.attribute2,:$column$.attribute3,:$column$.attribute4,:$column$.attribute5,:$column$.attribute6,:$column$.attribute7,:$column$.attribute8,:$column$.attribute9,:$column$.attribute10)) lov order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE8') from dual select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE8' 106 ATTRIBUTE9 LOV custom varchar2 select case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,1,instrb(lov.column_value,'~')-1) else lov.column_value end value, case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,instrb(lov.column_value,'~')+1) end description from table(xxen_util.dff_attribute_lov(275,'PA_PROJECTS_DESC_FLEX',:$column$.attribute_category,'ATTRIBUTE9',:$column$.attribute1,:$column$.attribute2,:$column$.attribute3,:$column$.attribute4,:$column$.attribute5,:$column$.attribute6,:$column$.attribute7,:$column$.attribute8,:$column$.attribute9,:$column$.attribute10)) lov order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE9') from dual select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE9' 107 ATTRIBUTE10 LOV custom varchar2 select case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,1,instrb(lov.column_value,'~')-1) else lov.column_value end value, case when instrb(lov.column_value,'~')>0 then substrb(lov.column_value,instrb(lov.column_value,'~')+1) end description from table(xxen_util.dff_attribute_lov(275,'PA_PROJECTS_DESC_FLEX',:$column$.attribute_category,'ATTRIBUTE10',:$column$.attribute1,:$column$.attribute2,:$column$.attribute3,:$column$.attribute4,:$column$.attribute5,:$column$.attribute6,:$column$.attribute7,:$column$.attribute8,:$column$.attribute9,:$column$.attribute10)) lov order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'ATTRIBUTE10') from dual select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_PROJECTS_DESC_FLEX' and fdfv.application_id=fdfc.application_id and fdfv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfc.application_id=fdfcuv.application_id and fdfc.descriptive_flexfield_name=fdfcuv.descriptive_flexfield_name and fdfc.descriptive_flex_context_code=fdfcuv.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE10' 108 CUSTOMER_NAME LOV custom varchar2 Y Y select hca.cust_account_id id, hp.party_name value, hca.account_number description from hz_cust_accounts hca, hz_parties hp where hca.party_id=hp.party_id and nvl(hca.status,'A')='A' order by value select xxen_pa_upload.project_default_value(:$column$.project_number,:$column$.template,'CUSTOMER_NAME') from dual 109 PM_PRODUCT_CODE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, null description from pa_lookups pl where pl.lookup_type='PM_PRODUCT_CODE' order by value select pl.meaning from pa_lookups pl where pl.lookup_type='PM_PRODUCT_CODE' and pl.lookup_code='PRIMAVERA' Y 110 PROJECT_ID Number number Y 111 UPLOAD_ROW Number number Y Error SQL Order By case when x.upload_row>0 then 0 else 1 end, operating_unit, project_number Success SQL select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, haouv.name operating_unit, ppa.segment1 project_number, ppa.name project_name, (select ppa_t.name from pa_projects_all ppa_t where ppa_t.project_id=ppa.created_from_project_id) template, ppa.long_name, ppa.project_type, pps.project_status_name project_status, haouv2.name organization, ppf.full_name project_manager, ppa.description, ppa.start_date, ppa.completion_date, decode(ppa.public_sector_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) public_sector, pdr.meaning distribution_rule, ppa.project_currency_code, ppa.projfunc_currency_code, gdct1.user_conversion_type project_rate_type, ppa.project_rate_date, gdct2.user_conversion_type projfunc_cost_rate_type, ppa.projfunc_cost_rate_date, xxen_util.meaning(ppa.labor_sch_type,'PROJECT SCHEDULE TYPE',275) labor_schedule_type, ppa.labor_schedule_fixed_date, ppa.labor_schedule_discount, xxen_util.meaning(ppa.labor_disc_reason_code,'RATE AND DISCOUNT REASON',275) labor_discount_reason, xxen_util.meaning(ppa.non_labor_sch_type,'PROJECT SCHEDULE TYPE',275) non_labor_schedule_type, haouv4.name non_labor_bill_rate_org, ppa.non_labor_schedule_fixed_date, ppa.non_labor_schedule_discount, xxen_util.meaning(ppa.non_labor_disc_reason_code,'RATE AND DISCOUNT REASON',275) non_labor_discount_reason, psbrsa1.std_bill_rate_schedule employee_bill_rate_schedule, psbrsa2.std_bill_rate_schedule job_bill_rate_schedule, psbrsa3.std_bill_rate_schedule non_labor_bill_rate_schedule, pirsab2.ind_rate_sch_name revenue_burden_schedule, ppa.rev_ind_sch_fixed_date revenue_ind_sched_fixed_dt, pirsab3.ind_rate_sch_name invoice_burden_schedule, ppa.inv_ind_sch_fixed_date invoice_ind_sched_fixed_dt, xxen_util.meaning(ppa.invproc_currency_type,'INVPROCE_CURR_TYPE',275) invproc_currency_type, ppa.revproc_currency_code, xxen_util.meaning(ppa.project_bil_rate_date_code,'BILL_RATE_DATE_CODE',275) project_bil_rate_date_code, gdct3.user_conversion_type project_bil_rate_type, ppa.project_bil_rate_date, ppa.project_bil_exchange_rate, xxen_util.meaning(ppa.projfunc_bil_rate_date_code,'BILL_RATE_DATE_CODE',275) projfunc_bil_rate_date_code, gdct4.user_conversion_type projfunc_bil_rate_type, ppa.projfunc_bil_rate_date, ppa.projfunc_bil_exchange_rate, xxen_util.meaning(ppa.funding_rate_date_code,'BILL_RATE_DATE_CODE',275) funding_rate_date_code, gdct5.user_conversion_type funding_rate_type, ppa.funding_rate_date, ppa.funding_exchange_rate, decode(ppa.baseline_funding_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) baseline_funding, decode(ppa.multi_currency_billing_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) multi_currency_billing, decode(ppa.inv_by_bill_trans_curr_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) invoice_by_bill_trans_currency, decode(ppa.assign_precedes_task,'Y',xxen_util.meaning('Y','YES_NO',0)) assign_precedes_task, decode(ppa.split_cost_from_workplan_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) split_cost_from_workplan, decode(ppa.split_cost_from_bill_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) split_cost_from_billing, decode(ppa.sys_program_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) system_program, decode(ppa.allow_multi_program_rollup,'Y',xxen_util.meaning('Y','YES_NO',0)) allow_multi_program_rollup, decode(ppa.projfunc_attr_for_ar_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) projfunc_attr_for_ar, decode(ppa.revaluate_funding_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) revaluate_funding, decode(ppa.include_gains_losses_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) include_gains_losses, decode(ppa.retn_accounting_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) retention_accounting, decode(ppa.cint_eligible_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) capital_interest_eligible, ppa.cint_stop_date capital_interest_stop_date, decode(ppa.enable_top_task_customer_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) enable_top_task_customer, decode(ppa.enable_top_task_inv_mth_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) enable_top_task_invoice_method, decode(ppa.limit_to_txn_controls_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) limit_to_txn_controls, decode(ppa.allow_cross_charge_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) allow_cross_charge, decode(ppa.cc_process_labor_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) cross_charge_process_labor, decode(ppa.cc_process_nl_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) cross_charge_process_non_labor, pctsb1.name labor_transfer_price_schedule, ppa.labor_tp_fixed_date labor_transfer_price_fixed_dt, pctsb2.name non_labor_transfer_price_sched, ppa.nl_tp_fixed_date non_labor_trans_price_fxd_dt, pwtv.name work_type, jtcv.calendar_name calendar, hla.location_code location, prl.name role_list, to_char(ppm.probability_percentage) probability, ppa.project_value, ppa.expected_approval_date, (select pl.meaning from pa_lookups pl where pl.lookup_type='PA_PROJECT_PRIORITY_CODE' and pl.lookup_code=ppa.priority_code) priority_code, pjgv1.displayed_name cost_job_group, pjgv2.displayed_name bill_job_group, (select flvv.meaning from fnd_lookup_values_vl flvv where flvv.lookup_type='PA_SECURITY_LEVEL' and flvv.lookup_code=to_char(ppa.security_level) and flvv.enabled_flag='Y' and flvv.security_group_id=0) security_level, pif.name retention_billing_invoice_fmt, xxen_util.meaning(ppa.asset_allocation_method,'ASSET_ALLOCATION_METHOD',275) asset_allocation_method, xxen_util.meaning(ppa.capital_event_processing,'CAPITAL_EVENT_PROCESSING',275) capital_event_processing, pirsab4.ind_rate_sch_name capital_interest_rate_schedule, ppa.output_tax_code, ppa.retention_tax_code, xxen_util.display_flexfield_context(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category) attribute_category, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE1',ppa.rowid,ppa.attribute1) attribute1, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE2',ppa.rowid,ppa.attribute2) attribute2, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE3',ppa.rowid,ppa.attribute3) attribute3, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE4',ppa.rowid,ppa.attribute4) attribute4, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE5',ppa.rowid,ppa.attribute5) attribute5, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE6',ppa.rowid,ppa.attribute6) attribute6, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE7',ppa.rowid,ppa.attribute7) attribute7, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE8',ppa.rowid,ppa.attribute8) attribute8, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE9',ppa.rowid,ppa.attribute9) attribute9, xxen_util.display_flexfield_value(275,'PA_PROJECTS_DESC_FLEX',ppa.attribute_category,'ATTRIBUTE10',ppa.rowid,ppa.attribute10) attribute10, (select hp.party_name from pa_project_customers ppc, hz_cust_accounts hca, hz_parties hp where ppc.project_id=ppa.project_id and ppc.customer_id=hca.cust_account_id and hca.party_id=hp.party_id and rownum=1) customer_name, (select pl.meaning from pa_lookups pl where pl.lookup_type='PM_PRODUCT_CODE' and pl.lookup_code=ppa.pm_product_code) pm_product_code, ppa.project_id, 0 upload_row from pa_projects_all ppa, pa_project_statuses pps, hr_all_organization_units_vl haouv, hr_all_organization_units_vl haouv2, hr_all_organization_units_vl haouv4, pa_distribution_rules pdr, per_all_people_f ppf, pa_project_parties ppp, gl_daily_conversion_types gdct1, gl_daily_conversion_types gdct2, gl_daily_conversion_types gdct3, gl_daily_conversion_types gdct4, gl_daily_conversion_types gdct5, pa_std_bill_rate_schedules_all psbrsa1, pa_std_bill_rate_schedules_all psbrsa2, pa_std_bill_rate_schedules_all psbrsa3, pa_ind_rate_schedules_all_bg pirsab2, pa_ind_rate_schedules_all_bg pirsab3, pa_ind_rate_schedules_all_bg pirsab4, pa_cc_tp_schedules_bg pctsb1, pa_cc_tp_schedules_bg pctsb2, pa_work_types_vl pwtv, jtf_calendars_vl jtcv, hr_locations_all hla, pa_role_lists prl, pa_probability_members ppm, per_job_groups_v pjgv1, per_job_groups_v pjgv2, pa_invoice_formats pif, xxen_pa_project_upload_7009_u xu where xu.status_code_=xxen_upload.status_success and xu.project_id=ppa.project_id and ppa.project_status_code=pps.project_status_code and pps.status_type='PROJECT' and ppa.org_id=haouv.organization_id and ppa.carrying_out_organization_id=haouv2.organization_id and ppa.non_labor_bill_rate_org_id=haouv4.organization_id(+) and ppa.distribution_rule=pdr.distribution_rule(+) and ppa.project_id=ppp.project_id(+) and ppp.project_role_id(+)=1 and nvl(ppp.end_date_active(+),sysdate)>=sysdate and ppp.resource_source_id=ppf.person_id(+) and trunc(sysdate) between ppf.effective_start_date(+) and ppf.effective_end_date(+) and ppa.project_rate_type=gdct1.conversion_type(+) and ppa.projfunc_cost_rate_type=gdct2.conversion_type(+) and ppa.project_bil_rate_type=gdct3.conversion_type(+) and ppa.projfunc_bil_rate_type=gdct4.conversion_type(+) and ppa.funding_rate_type=gdct5.conversion_type(+) and ppa.emp_bill_rate_schedule_id=psbrsa1.bill_rate_sch_id(+) and ppa.job_bill_rate_schedule_id=psbrsa2.bill_rate_sch_id(+) and ppa.non_lab_std_bill_rt_sch_id=psbrsa3.bill_rate_sch_id(+) and ppa.rev_ind_rate_sch_id=pirsab2.ind_rate_sch_id(+) and ppa.inv_ind_rate_sch_id=pirsab3.ind_rate_sch_id(+) and ppa.cint_rate_sch_id=pirsab4.ind_rate_sch_id(+) and ppa.labor_tp_schedule_id=pctsb1.tp_schedule_id(+) and ppa.nl_tp_schedule_id=pctsb2.tp_schedule_id(+) and ppa.work_type_id=pwtv.work_type_id(+) and ppa.calendar_id=jtcv.calendar_id(+) and ppa.location_id=hla.location_id(+) and ppa.role_list_id=prl.role_list_id(+) and ppa.probability_member_id=ppm.probability_member_id(+) and ppa.cost_job_group_id=pjgv1.job_group_id(+) and ppa.bill_job_group_id=pjgv2.job_group_id(+) and ppa.retn_billing_inv_format_id=pif.invoice_format_id(+) Default value :$column$.project_number PROJECT_NUMBER ALLOW_CROSS_CHARGE Default value :$column$.template TEMPLATE ALLOW_CROSS_CHARGE Default value :$column$.project_number PROJECT_NUMBER ALLOW_MULTI_PROGRAM_ROLLUP Default value :$column$.template TEMPLATE ALLOW_MULTI_PROGRAM_ROLLUP Default value :$column$.project_number PROJECT_NUMBER ASSET_ALLOCATION_METHOD Default value :$column$.template TEMPLATE ASSET_ALLOCATION_METHOD Default value :$column$.project_number PROJECT_NUMBER ASSIGN_PRECEDES_TASK Default value :$column$.template TEMPLATE ASSIGN_PRECEDES_TASK LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE1 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE1 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE1 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE1 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE1 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE1 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE1 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE1 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE1 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE1 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE1 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE1 Default value :$column$.template TEMPLATE ATTRIBUTE1 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE10 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE10 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE10 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE10 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE10 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE10 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE10 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE10 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE10 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE10 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE10 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE10 Default value :$column$.template TEMPLATE ATTRIBUTE10 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE2 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE2 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE2 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE2 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE2 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE2 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE2 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE2 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE2 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE2 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE2 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE2 Default value :$column$.template TEMPLATE ATTRIBUTE2 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE3 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE3 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE3 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE3 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE3 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE3 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE3 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE3 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE3 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE3 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE3 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE3 Default value :$column$.template TEMPLATE ATTRIBUTE3 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE4 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE4 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE4 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE4 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE4 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE4 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE4 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE4 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE4 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE4 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE4 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE4 Default value :$column$.template TEMPLATE ATTRIBUTE4 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE5 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE5 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE5 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE5 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE5 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE5 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE5 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE5 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE5 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE5 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE5 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE5 Default value :$column$.template TEMPLATE ATTRIBUTE5 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE6 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE6 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE6 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE6 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE6 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE6 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE6 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE6 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE6 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE6 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE6 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE6 Default value :$column$.template TEMPLATE ATTRIBUTE6 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE7 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE7 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE7 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE7 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE7 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE7 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE7 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE7 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE7 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE7 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE7 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE7 Default value :$column$.template TEMPLATE ATTRIBUTE7 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE8 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE8 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE8 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE8 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE8 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE8 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE8 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE8 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE8 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE8 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE8 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE8 Default value :$column$.template TEMPLATE ATTRIBUTE8 LOV query :$column$.attribute1 ATTRIBUTE1 ATTRIBUTE9 LOV query :$column$.attribute10 ATTRIBUTE10 ATTRIBUTE9 LOV query :$column$.attribute2 ATTRIBUTE2 ATTRIBUTE9 LOV query :$column$.attribute3 ATTRIBUTE3 ATTRIBUTE9 LOV query :$column$.attribute4 ATTRIBUTE4 ATTRIBUTE9 LOV query :$column$.attribute5 ATTRIBUTE5 ATTRIBUTE9 LOV query :$column$.attribute6 ATTRIBUTE6 ATTRIBUTE9 LOV query :$column$.attribute7 ATTRIBUTE7 ATTRIBUTE9 LOV query :$column$.attribute8 ATTRIBUTE8 ATTRIBUTE9 LOV query :$column$.attribute9 ATTRIBUTE9 ATTRIBUTE9 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY ATTRIBUTE9 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE9 Default value :$column$.template TEMPLATE ATTRIBUTE9 Default value :$column$.project_number PROJECT_NUMBER ATTRIBUTE_CATEGORY Default value :$column$.template TEMPLATE ATTRIBUTE_CATEGORY Default value :$column$.project_number PROJECT_NUMBER BASELINE_FUNDING Default value :$column$.template TEMPLATE BASELINE_FUNDING Default value :$column$.project_number PROJECT_NUMBER BILL_JOB_GROUP Default value :$column$.template TEMPLATE BILL_JOB_GROUP Default value :$column$.project_number PROJECT_NUMBER CALENDAR Default value :$column$.template TEMPLATE CALENDAR Default value :$column$.project_number PROJECT_NUMBER CAPITAL_EVENT_PROCESSING Default value :$column$.template TEMPLATE CAPITAL_EVENT_PROCESSING Default value :$column$.project_number PROJECT_NUMBER CAPITAL_INTEREST_ELIGIBLE Default value :$column$.template TEMPLATE CAPITAL_INTEREST_ELIGIBLE Default value :$column$.project_number PROJECT_NUMBER CAPITAL_INTEREST_RATE_SCHEDULE Default value :$column$.template TEMPLATE CAPITAL_INTEREST_RATE_SCHEDULE Default value :$column$.project_number PROJECT_NUMBER CAPITAL_INTEREST_STOP_DATE Default value :$column$.template TEMPLATE CAPITAL_INTEREST_STOP_DATE Default value :$column$.project_number PROJECT_NUMBER COMPLETION_DATE Default value :$column$.template TEMPLATE COMPLETION_DATE Default value :$column$.project_number PROJECT_NUMBER COST_JOB_GROUP Default value :$column$.template TEMPLATE COST_JOB_GROUP Default value :$column$.project_number PROJECT_NUMBER CROSS_CHARGE_PROCESS_LABOR Default value :$column$.template TEMPLATE CROSS_CHARGE_PROCESS_LABOR Default value :$column$.project_number PROJECT_NUMBER CROSS_CHARGE_PROCESS_NON_LABOR Default value :$column$.template TEMPLATE CROSS_CHARGE_PROCESS_NON_LABOR Default value :$column$.project_number PROJECT_NUMBER CUSTOMER_NAME Default value :$column$.template TEMPLATE CUSTOMER_NAME Default value :$column$.project_number PROJECT_NUMBER DESCRIPTION Default value :$column$.template TEMPLATE DESCRIPTION Default value :$column$.project_number PROJECT_NUMBER DISTRIBUTION_RULE Default value :$column$.template TEMPLATE DISTRIBUTION_RULE Default value :$column$.project_number PROJECT_NUMBER EMPLOYEE_BILL_RATE_SCHEDULE Default value :$column$.template TEMPLATE EMPLOYEE_BILL_RATE_SCHEDULE Default value :$column$.project_number PROJECT_NUMBER ENABLE_TOP_TASK_CUSTOMER Default value :$column$.template TEMPLATE ENABLE_TOP_TASK_CUSTOMER Default value :$column$.project_number PROJECT_NUMBER ENABLE_TOP_TASK_INVOICE_METHOD Default value :$column$.template TEMPLATE ENABLE_TOP_TASK_INVOICE_METHOD Default value :$column$.project_number PROJECT_NUMBER EXPECTED_APPROVAL_DATE Default value :$column$.template TEMPLATE EXPECTED_APPROVAL_DATE Default value :$column$.project_number PROJECT_NUMBER FUNDING_EXCHANGE_RATE Default value :$column$.template TEMPLATE FUNDING_EXCHANGE_RATE Default value :$column$.project_number PROJECT_NUMBER FUNDING_RATE_DATE Default value :$column$.template TEMPLATE FUNDING_RATE_DATE Default value :$column$.project_number PROJECT_NUMBER FUNDING_RATE_DATE_CODE Default value :$column$.template TEMPLATE FUNDING_RATE_DATE_CODE Default value :$column$.project_number PROJECT_NUMBER FUNDING_RATE_TYPE Default value :$column$.template TEMPLATE FUNDING_RATE_TYPE Default value :$column$.project_number PROJECT_NUMBER INCLUDE_GAINS_LOSSES Default value :$column$.template TEMPLATE INCLUDE_GAINS_LOSSES Default value :$column$.project_number PROJECT_NUMBER INVOICE_BURDEN_SCHEDULE Default value :$column$.template TEMPLATE INVOICE_BURDEN_SCHEDULE Default value :$column$.project_number PROJECT_NUMBER INVOICE_BY_BILL_TRANS_CURRENCY Default value :$column$.template TEMPLATE INVOICE_BY_BILL_TRANS_CURRENCY Default value :$column$.project_number PROJECT_NUMBER INVOICE_IND_SCHED_FIXED_DT Default value :$column$.template TEMPLATE INVOICE_IND_SCHED_FIXED_DT Default value :$column$.project_number PROJECT_NUMBER INVPROC_CURRENCY_TYPE Default value :$column$.template TEMPLATE INVPROC_CURRENCY_TYPE Default value :$column$.project_number PROJECT_NUMBER JOB_BILL_RATE_SCHEDULE Default value :$column$.template TEMPLATE JOB_BILL_RATE_SCHEDULE Default value :$column$.project_number PROJECT_NUMBER LABOR_DISCOUNT_REASON Default value :$column$.template TEMPLATE LABOR_DISCOUNT_REASON Default value :$column$.project_number PROJECT_NUMBER LABOR_SCHEDULE_DISCOUNT Default value :$column$.template TEMPLATE LABOR_SCHEDULE_DISCOUNT Default value :$column$.project_number PROJECT_NUMBER LABOR_SCHEDULE_FIXED_DATE Default value :$column$.template TEMPLATE LABOR_SCHEDULE_FIXED_DATE Default value :$column$.project_number PROJECT_NUMBER LABOR_SCHEDULE_TYPE Default value :$column$.template TEMPLATE LABOR_SCHEDULE_TYPE Default value :$column$.project_number PROJECT_NUMBER LABOR_TRANSFER_PRICE_FIXED_DT Default value :$column$.template TEMPLATE LABOR_TRANSFER_PRICE_FIXED_DT Default value :$column$.project_number PROJECT_NUMBER LABOR_TRANSFER_PRICE_SCHEDULE Default value :$column$.template TEMPLATE LABOR_TRANSFER_PRICE_SCHEDULE Default value :$column$.project_number PROJECT_NUMBER LIMIT_TO_TXN_CONTROLS Default value :$column$.template TEMPLATE LIMIT_TO_TXN_CONTROLS Default value :$column$.project_number PROJECT_NUMBER LOCATION Default value :$column$.template TEMPLATE LOCATION Default value :$column$.project_number PROJECT_NUMBER LONG_NAME Default value :$column$.template TEMPLATE LONG_NAME Default value :$column$.project_number PROJECT_NUMBER MULTI_CURRENCY_BILLING Default value :$column$.template TEMPLATE MULTI_CURRENCY_BILLING Default value :$column$.project_number PROJECT_NUMBER NON_LABOR_BILL_RATE_ORG Default value :$column$.template TEMPLATE NON_LABOR_BILL_RATE_ORG Default value :$column$.project_number PROJECT_NUMBER NON_LABOR_BILL_RATE_SCHEDULE Default value :$column$.template TEMPLATE NON_LABOR_BILL_RATE_SCHEDULE Default value :$column$.project_number PROJECT_NUMBER NON_LABOR_DISCOUNT_REASON Default value :$column$.template TEMPLATE NON_LABOR_DISCOUNT_REASON Default value :$column$.project_number PROJECT_NUMBER NON_LABOR_SCHEDULE_DISCOUNT Default value :$column$.template TEMPLATE NON_LABOR_SCHEDULE_DISCOUNT Default value :$column$.project_number PROJECT_NUMBER NON_LABOR_SCHEDULE_FIXED_DATE Default value :$column$.template TEMPLATE NON_LABOR_SCHEDULE_FIXED_DATE Default value :$column$.project_number PROJECT_NUMBER NON_LABOR_SCHEDULE_TYPE Default value :$column$.template TEMPLATE NON_LABOR_SCHEDULE_TYPE Default value :$column$.project_number PROJECT_NUMBER NON_LABOR_TRANSFER_PRICE_SCHED Default value :$column$.template TEMPLATE NON_LABOR_TRANSFER_PRICE_SCHED Default value :$column$.project_number PROJECT_NUMBER NON_LABOR_TRANS_PRICE_FXD_DT Default value :$column$.template TEMPLATE NON_LABOR_TRANS_PRICE_FXD_DT LOV query :$column$.operating_unit OPERATING_UNIT ORGANIZATION Default value :$column$.project_number PROJECT_NUMBER ORGANIZATION Default value :$column$.template TEMPLATE ORGANIZATION Default value :$column$.project_number PROJECT_NUMBER OUTPUT_TAX_CODE Default value :$column$.template TEMPLATE OUTPUT_TAX_CODE Default value :$column$.project_number PROJECT_NUMBER PRIORITY_CODE Default value :$column$.template TEMPLATE PRIORITY_CODE Default value :$column$.project_number PROJECT_NUMBER PROBABILITY Default value :$column$.template TEMPLATE PROBABILITY Default value :$column$.project_number PROJECT_NUMBER PROJECT_BIL_EXCHANGE_RATE Default value :$column$.template TEMPLATE PROJECT_BIL_EXCHANGE_RATE Default value :$column$.project_number PROJECT_NUMBER PROJECT_BIL_RATE_DATE Default value :$column$.template TEMPLATE PROJECT_BIL_RATE_DATE Default value :$column$.project_number PROJECT_NUMBER PROJECT_BIL_RATE_DATE_CODE Default value :$column$.template TEMPLATE PROJECT_BIL_RATE_DATE_CODE Default value :$column$.project_number PROJECT_NUMBER PROJECT_BIL_RATE_TYPE Default value :$column$.template TEMPLATE PROJECT_BIL_RATE_TYPE Default value :$column$.project_number PROJECT_NUMBER PROJECT_CURRENCY_CODE Default value :$column$.template TEMPLATE PROJECT_CURRENCY_CODE Default value :$column$.project_number PROJECT_NUMBER PROJECT_MANAGER Default value :$column$.template TEMPLATE PROJECT_MANAGER Default value :$column$.project_number PROJECT_NUMBER PROJECT_NAME LOV query :$column$.operating_unit OPERATING_UNIT PROJECT_NUMBER Default value :$column$.project_number PROJECT_NUMBER PROJECT_RATE_DATE Default value :$column$.template TEMPLATE PROJECT_RATE_DATE Default value :$column$.project_number PROJECT_NUMBER PROJECT_RATE_TYPE Default value :$column$.template TEMPLATE PROJECT_RATE_TYPE Default value :$column$.project_number PROJECT_NUMBER PROJECT_STATUS Default value :$column$.template TEMPLATE PROJECT_STATUS Default value :$column$.project_number PROJECT_NUMBER PROJECT_TYPE Default value :$column$.template TEMPLATE PROJECT_TYPE Default value :$column$.project_number PROJECT_NUMBER PROJECT_VALUE Default value :$column$.template TEMPLATE PROJECT_VALUE Default value :$column$.project_number PROJECT_NUMBER PROJFUNC_ATTR_FOR_AR Default value :$column$.template TEMPLATE PROJFUNC_ATTR_FOR_AR Default value :$column$.project_number PROJECT_NUMBER PROJFUNC_BIL_EXCHANGE_RATE Default value :$column$.template TEMPLATE PROJFUNC_BIL_EXCHANGE_RATE Default value :$column$.project_number PROJECT_NUMBER PROJFUNC_BIL_RATE_DATE Default value :$column$.template TEMPLATE PROJFUNC_BIL_RATE_DATE Default value :$column$.project_number PROJECT_NUMBER PROJFUNC_BIL_RATE_DATE_CODE Default value :$column$.template TEMPLATE PROJFUNC_BIL_RATE_DATE_CODE Default value :$column$.project_number PROJECT_NUMBER PROJFUNC_BIL_RATE_TYPE Default value :$column$.template TEMPLATE PROJFUNC_BIL_RATE_TYPE Default value :$column$.project_number PROJECT_NUMBER PROJFUNC_COST_RATE_DATE Default value :$column$.template TEMPLATE PROJFUNC_COST_RATE_DATE Default value :$column$.project_number PROJECT_NUMBER PROJFUNC_COST_RATE_TYPE Default value :$column$.template TEMPLATE PROJFUNC_COST_RATE_TYPE Default value :$column$.project_number PROJECT_NUMBER PROJFUNC_CURRENCY_CODE Default value :$column$.template TEMPLATE PROJFUNC_CURRENCY_CODE Default value :$column$.project_number PROJECT_NUMBER PUBLIC_SECTOR Default value :$column$.template TEMPLATE PUBLIC_SECTOR Default value :$column$.project_number PROJECT_NUMBER RETENTION_ACCOUNTING Default value :$column$.template TEMPLATE RETENTION_ACCOUNTING Default value :$column$.project_number PROJECT_NUMBER RETENTION_BILLING_INVOICE_FMT Default value :$column$.template TEMPLATE RETENTION_BILLING_INVOICE_FMT Default value :$column$.project_number PROJECT_NUMBER RETENTION_TAX_CODE Default value :$column$.template TEMPLATE RETENTION_TAX_CODE Default value :$column$.project_number PROJECT_NUMBER REVALUATE_FUNDING Default value :$column$.template TEMPLATE REVALUATE_FUNDING Default value :$column$.project_number PROJECT_NUMBER REVENUE_BURDEN_SCHEDULE Default value :$column$.template TEMPLATE REVENUE_BURDEN_SCHEDULE Default value :$column$.project_number PROJECT_NUMBER REVENUE_IND_SCHED_FIXED_DT Default value :$column$.template TEMPLATE REVENUE_IND_SCHED_FIXED_DT Default value :$column$.project_number PROJECT_NUMBER REVPROC_CURRENCY_CODE Default value :$column$.template TEMPLATE REVPROC_CURRENCY_CODE Default value :$column$.project_number PROJECT_NUMBER ROLE_LIST Default value :$column$.template TEMPLATE ROLE_LIST Default value :$column$.project_number PROJECT_NUMBER SECURITY_LEVEL Default value :$column$.template TEMPLATE SECURITY_LEVEL Default value :$column$.project_number PROJECT_NUMBER SPLIT_COST_FROM_BILLING Default value :$column$.template TEMPLATE SPLIT_COST_FROM_BILLING Default value :$column$.project_number PROJECT_NUMBER SPLIT_COST_FROM_WORKPLAN Default value :$column$.template TEMPLATE SPLIT_COST_FROM_WORKPLAN Default value :$column$.project_number PROJECT_NUMBER START_DATE Default value :$column$.template TEMPLATE START_DATE Default value :$column$.project_number PROJECT_NUMBER SYSTEM_PROGRAM Default value :$column$.template TEMPLATE SYSTEM_PROGRAM LOV query :$column$.operating_unit OPERATING_UNIT TEMPLATE Default value :$column$.project_number PROJECT_NUMBER TEMPLATE Default value :$column$.project_number PROJECT_NUMBER WORK_TYPE Default value :$column$.template TEMPLATE WORK_TYPE Excel validation :$column$.completion_date COMPLETION_DATE Excel validation :$column$.customer_name CUSTOMER_NAME Excel validation :$column$.description DESCRIPTION Excel validation :$column$.long_name LONG_NAME Excel validation :$column$.organization ORGANIZATION Excel validation :$column$.project_manager PROJECT_MANAGER Excel validation :$column$.project_name PROJECT_NAME Excel validation :$column$.project_number PROJECT_NUMBER Excel validation :$column$.start_date START_DATE Excel validation :$column$.template TEMPLATE