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 40ADAF9625006205E0633D7D37A25AFA select null action_, null status_, null message_, null request_id_, null modified_columns_, -- operating unit haouv.name operating_unit, -- project ppv.segment1 project_number, ppv.name project_name, ppv.project_type, ppv.project_status_m project_status, ppf0.full_name project_manager, -- task pt.task_id, pt.task_number, pt.task_name, pt.long_task_name, pt.description, lpad(' ',2*(pt.wbs_level-1))||pt.wbs_level wbs_level, pt2.task_number parent_task_number, -- task dates pt.start_date, pt.completion_date end_date, -- organization haouv2.name organization, -- task manager ppf.full_name task_manager, -- service type xxen_util.meaning(pt.service_type_code,'SERVICE TYPE',275) service_type, -- work type pwtv.name work_type, -- flags decode(pt.chargeable_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) allow_charges, decode(pt.billable_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) billable, decode(pt.ready_to_bill_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) ready_to_bill, decode(pt.ready_to_distribute_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) ready_to_distribute, decode(pt.limit_to_txn_controls_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) limit_to_txn_controls, decode(pt.receive_project_invoice_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) receive_inter_project_invoices, decode(pt.retirement_cost_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) retirement_cost, -- billing schedules xxen_util.meaning(pt.labor_sch_type,'PROJECT SCHEDULE TYPE',275) labor_schedule_type, psbrsa4.std_bill_rate_schedule labor_std_bill_rate_schedule, pt.labor_schedule_fixed_date, pt.labor_schedule_discount, xxen_util.meaning(pt.labor_disc_reason_code,'RATE AND DISCOUNT REASON',275) labor_discount_reason, xxen_util.meaning(pt.non_labor_sch_type,'PROJECT SCHEDULE TYPE',275) non_labor_schedule_type, haouv4.name non_labor_bill_rate_org, psbrsa5.std_bill_rate_schedule non_labor_std_bill_rate_sched, pt.non_labor_schedule_fixed_date, pt.non_labor_schedule_discount, xxen_util.meaning(pt.non_labor_disc_reason_code,'RATE AND DISCOUNT REASON',275) non_labor_discount_reason, pt.labor_cost_multiplier_name, 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, xxen_util.meaning(pt.invoice_method,'INVOICE METHOD',275) invoice_method, xxen_util.meaning(pt.gen_etc_source_code,'PA_TASK_LVL_ETC_SRC',275) generate_etc_source, xxen_util.meaning(pt.adj_on_std_inv,'PA_ADJ_ON_STD_INV',275) adjust_on_standard_invoice, -- burden schedules pirsab1.ind_rate_sch_name cost_burden_schedule, pt.cost_ind_sch_fixed_date cost_ind_schedule_fixed_date, pirsab2.ind_rate_sch_name revenue_burden_schedule, pt.rev_ind_sch_fixed_date revenue_ind_sched_fixed_dt, pirsab3.ind_rate_sch_name invoice_burden_schedule, pt.inv_ind_sch_fixed_date invoice_ind_sched_fixed_dt, -- cross charge decode(pt.allow_cross_charge_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) allow_cross_charge, decode(pt.cc_process_labor_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) cross_charge_process_labor, decode(pt.cc_process_nl_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) cross_charge_process_non_labor, pctsb1.name labor_transfer_price_schedule, pt.labor_tp_fixed_date labor_transfer_price_fixed_dt, pctsb2.name non_labor_transfer_price_sched, pt.nl_tp_fixed_date non_labor_trans_price_fxd_dt, -- intercompany pctsb3.name ic_labor_transfer_price_sched, pt.ic_labor_tp_fixed_date ic_labor_trans_price_fxd_dt, pctsb4.name ic_non_lab_trans_price_sched, pt.ic_nl_tp_fixed_date ic_non_lab_trans_price_fxd_dt, -- rate info gdct1.user_conversion_type project_rate_type, pt.project_rate_date, gdct2.user_conversion_type task_functional_cost_rate_type, pt.taskfunc_cost_rate_date task_functional_cost_rate_date, -- capital interest decode(pt.cint_eligible_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) capital_interest_eligible, pt.cint_stop_date capital_interest_stop_date, -- address hl.address1||nvl2(hl.city,', '||hl.city,null)||nvl2(hl.state,', '||hl.state,null)||nvl2(hl.country,', '||hl.country,null) address, -- customer hp.party_name customer_name, -- DFF xxen_util.display_flexfield_context(275,'PA_TASKS_DESC_FLEX',pt.attribute_category) attribute_category, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',pt.attribute_category,'ATTRIBUTE1',pt.rowid,pt.attribute1) attribute1, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',pt.attribute_category,'ATTRIBUTE2',pt.rowid,pt.attribute2) attribute2, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',pt.attribute_category,'ATTRIBUTE3',pt.rowid,pt.attribute3) attribute3, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',pt.attribute_category,'ATTRIBUTE4',pt.rowid,pt.attribute4) attribute4, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',pt.attribute_category,'ATTRIBUTE5',pt.rowid,pt.attribute5) attribute5, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',pt.attribute_category,'ATTRIBUTE6',pt.rowid,pt.attribute6) attribute6, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',pt.attribute_category,'ATTRIBUTE7',pt.rowid,pt.attribute7) attribute7, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',pt.attribute_category,'ATTRIBUTE8',pt.rowid,pt.attribute8) attribute8, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',pt.attribute_category,'ATTRIBUTE9',pt.rowid,pt.attribute9) attribute9, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',pt.attribute_category,'ATTRIBUTE10',pt.rowid,pt.attribute10) attribute10, null publish_structure, 0 upload_row from pa_projects_v ppv, pa_tasks pt, pa_tasks pt2, hr_all_organization_units_vl haouv, hr_all_organization_units_vl haouv2, hr_all_organization_units_vl haouv4, per_all_people_f ppf, per_all_people_f ppf0, pa_project_parties ppp, pa_work_types_vl pwtv, pa_std_bill_rate_schedules_all psbrsa1, pa_std_bill_rate_schedules_all psbrsa2, pa_std_bill_rate_schedules_all psbrsa3, pa_std_bill_rate_schedules_all psbrsa4, pa_std_bill_rate_schedules_all psbrsa5, pa_ind_rate_schedules_all_bg pirsab1, pa_ind_rate_schedules_all_bg pirsab2, pa_ind_rate_schedules_all_bg pirsab3, pa_cc_tp_schedules_bg pctsb1, pa_cc_tp_schedules_bg pctsb2, pa_cc_tp_schedules_bg pctsb3, pa_cc_tp_schedules_bg pctsb4, gl_daily_conversion_types gdct1, gl_daily_conversion_types gdct2, hz_party_sites hps, hz_locations hl, hz_cust_accounts hca, hz_parties hp where 1=1 and ppv.template_flag='N' and ppv.org_id=haouv.organization_id and ppv.project_id=pt.project_id and pt.parent_task_id=pt2.task_id(+) and pt.carrying_out_organization_id=haouv2.organization_id and pt.task_manager_person_id=ppf.person_id(+) and trunc(sysdate) between ppf.effective_start_date(+) and ppf.effective_end_date(+) and ppv.project_id=ppp.project_id(+) and ppp.project_role_id(+)=1 and nvl(ppp.end_date_active(+),sysdate)>=sysdate and ppp.resource_source_id=ppf0.person_id(+) and trunc(sysdate) between ppf0.effective_start_date(+) and ppf0.effective_end_date(+) and pt.work_type_id=pwtv.work_type_id(+) and pt.emp_bill_rate_schedule_id=psbrsa1.bill_rate_sch_id(+) and pt.job_bill_rate_schedule_id=psbrsa2.bill_rate_sch_id(+) and pt.non_lab_std_bill_rt_sch_id=psbrsa3.bill_rate_sch_id(+) and pt.labor_std_bill_rate_schdl=psbrsa4.std_bill_rate_schedule(+) and pt.labor_bill_rate_org_id=psbrsa4.org_id(+) and pt.non_labor_std_bill_rate_schdl=psbrsa5.std_bill_rate_schedule(+) and pt.non_labor_bill_rate_org_id=psbrsa5.org_id(+) and pt.cost_ind_rate_sch_id=pirsab1.ind_rate_sch_id(+) and pt.rev_ind_rate_sch_id=pirsab2.ind_rate_sch_id(+) and pt.inv_ind_rate_sch_id=pirsab3.ind_rate_sch_id(+) and pt.non_labor_bill_rate_org_id=haouv4.organization_id(+) and pt.labor_tp_schedule_id=pctsb1.tp_schedule_id(+) and pt.nl_tp_schedule_id=pctsb2.tp_schedule_id(+) and pt.ic_labor_tp_schedule_id=pctsb3.tp_schedule_id(+) and pt.ic_nl_tp_schedule_id=pctsb4.tp_schedule_id(+) and pt.project_rate_type=gdct1.conversion_type(+) and pt.taskfunc_cost_rate_type=gdct2.conversion_type(+) and pt.address_id=hps.party_site_id(+) and hps.location_id=hl.location_id(+) and pt.customer_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) Y U A xxen_pa_upload.upload_project_task US PA Task Upload PA Task Upload ====================== Create new tasks or update existing task attributes within Oracle Projects using APIs pa_project_pub.add_task and pa_project_pub.update_task. This upload does not create projects — it operates on tasks within existing projects. Supported Actions: - Create: Add new top-level tasks, child tasks under existing parents, or entire parent-child hierarchies - Update: Modify attributes of existing tasks (organization, manager, work type, flags, schedules, etc.) Report Parameters: - Upload Mode: 'Create' for new tasks only, or 'Create, Update' for both - Operating Unit: Filter download to a specific operating unit - Project Number: Filter download to a specific project - Project Name: Filter download to a specific project by name - Project Type: Filter download to a specific project type - Project Status: Filter download to a specific project status Uploadable Columns: - Task Identity: Task Number, Task Name, Long Task Name, Task Description - Hierarchy: Parent Task Number (to create child tasks or reparent) - Dates: Task Start Date, Task Completion Date - Organization: Carrying Out Organization, Task Manager - Classification: Service Type, Work Type - Flags: Chargeable, Billable, Receive Project Invoice, Ready to Bill, Ready to Distribute, Limit to Txn Controls, Allow Cross Charge, Retirement Cost, Capital Interest (CINT) Eligible - Labor Billing: Labor Schedule Type, Labor Std Bill Rate Schedule, Labor Schedule Fixed Date, Labor Schedule Discount, Employee Bill Rate Schedule, Labor Cost Multiplier - Non-Labor Billing: NL Schedule Type, NL Bill Rate Org, NL Std Bill Rate Schedule, NL Schedule Fixed Date, NL Schedule Discount, Job Bill Rate Schedule, Non-Labor Std Bill Rate Schedule - Burden Schedules: Cost/Revenue/Invoice Burden Schedule and Fixed Dates - Transfer Pricing: Labor/NL TP Schedule and Fixed Dates, Intercompany Labor/NL TP Schedule and Fixed Dates, CC Process Labor/NL Flags - Rate Info: Project Rate Type/Date, Task Functional Cost Rate Type/Date - Revenue/Invoice: Invoice Method, Customer Name, Gen ETC Source Code, CINT Stop Date - Address: Task Address - DFF: Attribute Category, Attributes 1-10 - Publish Structure: Set to 'Yes' on the last task row of a project to publish the working structure version after upload Structure Version Handling: - For projects without workplan versioning: tasks are added/updated directly — no special handling needed - For versioned projects with a WORKING structure version: the upload uses the WORKING version automatically - For versioned projects with only a PUBLISHED version (no WORKING version): task add/update is NOT supported and records will be errored Unsupported Project Configurations: - Projects with workplan versioning enabled (Workplan Attributes > Enable Versioning = Yes) that have no WORKING structure version will fail with: "The structure version cannot be updated" - This typically affects projects where: a) All structure versions have been published and none are in working/draft status b) Auto-publish is enabled and no manual working version has been created Workaround for Unsupported Projects: 1. Navigate to Projects > Project Super User > Projects 2. Query the project and go to the Workplan tab 3. Click "Update Workplan" to create a new WORKING structure version 4. Re-run the upload — it will now pick up the WORKING version and succeed 5. After the upload completes, publish the working version from the Workplan tab if needed Notes: - To modify tasks on projects owned by other users, the profile option 'PA: Cross Project User -- Update' must be enabled at the responsibility level - Tasks with existing expenditure items cannot have new subtasks created below them - When updating tasks, the task number itself is not modified — only other attributes are updated - The PM Product Code must be a valid value registered in the PA_LOOKUPS lookup type PM_PRODUCT_CODE (e.g., MSPROJECT, PRIMAVERA) 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 select xxen_upload.action_meaning(xxen_upload.action_create) from dual 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 ppv.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 ppv.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 ppv.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 ppv.project_status_m=: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 ppv.project_id id, ppv.segment1 value, ppv.description from pa_projects_v ppv where ppv.template_flag='N' and ppv.operating_unit=:$column$.operating_unit order by value Y 8 PROJECT_NAME Char varchar2 select ppv.name from pa_projects_v ppv where ppv.segment1=:$column$.project_number 9 PROJECT_TYPE Char varchar2 select ppv.project_type from pa_projects_v ppv where ppv.segment1=:$column$.project_number 10 PROJECT_STATUS Char varchar2 select ppv.project_status_m from pa_projects_v ppv where ppv.segment1=:$column$.project_number 11 PROJECT_MANAGER Char varchar2 select ppf.full_name from pa_projects_v ppv, pa_project_parties ppp, per_all_people_f ppf where ppv.segment1=:$column$.project_number and ppv.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 12 TASK_ID Number number Y 13 TASK_NUMBER Char varchar2 Y 14 TASK_NAME Char varchar2 Y 15 LONG_TASK_NAME Char varchar2 16 DESCRIPTION Char varchar2 17 WBS_LEVEL Char varchar2 18 PARENT_TASK_NUMBER LOV custom varchar2 select ppe.element_number id, ppe.element_number value, ppe.name description from pa_proj_elements ppe where ppe.project_id=(select ppv.project_id from pa_projects_v ppv where ppv.segment1=:$column$.project_number) and ppe.object_type='PA_TASKS' and ppe.element_number<>:$column$.task_number order by ppe.element_number 19 START_DATE Date date 20 END_DATE Date date 21 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' 22 TASK_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 pe.full_name 23 SERVICE_TYPE LOV custom varchar2 Y select pl.lookup_code id, pl.meaning value, pl.description from pa_lookups pl where pl.lookup_type='SERVICE TYPE' and pl.lookup_code<>'AWARD_SERVICE_TYPE' order by value 24 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 25 ALLOW_CHARGES LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 26 BILLABLE LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 27 READY_TO_BILL LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 28 READY_TO_DISTRIBUTE LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 29 LIMIT_TO_TXN_CONTROLS LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 30 RECEIVE_INTER_PROJECT_INVOICES LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 31 RETIREMENT_COST LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 32 LABOR_SCHEDULE_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='PROJECT SCHEDULE TYPE' and flvv.view_application_id=275 and flvv.enabled_flag='Y' order by flvv.lookup_code 33 LABOR_STD_BILL_RATE_SCHEDULE LOV custom varchar2 Y select psbrsa.std_bill_rate_schedule id, psbrsa.std_bill_rate_schedule value, psbrsa.description from pa_std_bill_rate_schedules_all psbrsa, hr_all_organization_units_vl haouv where psbrsa.org_id=haouv.organization_id and psbrsa.schedule_type='EMPLOYEE' and haouv.name=:$column$.operating_unit order by psbrsa.std_bill_rate_schedule 34 LABOR_SCHEDULE_FIXED_DATE Date date 35 LABOR_SCHEDULE_DISCOUNT Number number 36 LABOR_DISCOUNT_REASON LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='RATE AND DISCOUNT REASON' and flvv.view_application_id=275 and flvv.enabled_flag='Y' order by flvv.lookup_code 37 NON_LABOR_SCHEDULE_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='PROJECT SCHEDULE TYPE' and flvv.view_application_id=275 and flvv.enabled_flag='Y' order by flvv.lookup_code 38 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 where exists (select null from pa_std_bill_rate_schedules_all psbrsa where psbrsa.org_id=haouv.organization_id and psbrsa.schedule_type='NON-LABOR') order by haouv.name 39 NON_LABOR_STD_BILL_RATE_SCHED LOV custom varchar2 Y select psbrsa.std_bill_rate_schedule id, psbrsa.std_bill_rate_schedule value, psbrsa.description from pa_std_bill_rate_schedules_all psbrsa, hr_all_organization_units_vl haouv where psbrsa.schedule_type='NON-LABOR' and psbrsa.org_id=haouv.organization_id and haouv.name=:$column$.non_labor_bill_rate_org order by psbrsa.std_bill_rate_schedule Non Labor Std Bill Rate Schedule 40 NON_LABOR_SCHEDULE_FIXED_DATE Date date 41 NON_LABOR_SCHEDULE_DISCOUNT Number number 42 NON_LABOR_DISCOUNT_REASON LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='RATE AND DISCOUNT REASON' and flvv.view_application_id=275 and flvv.enabled_flag='Y' order by flvv.lookup_code 43 LABOR_COST_MULTIPLIER_NAME LOV custom varchar2 Y select plcm.labor_cost_multiplier_name id, plcm.labor_cost_multiplier_name value, null description from pa_labor_cost_multipliers plcm where nvl(plcm.end_date_active,sysdate)>=sysdate order by plcm.labor_cost_multiplier_name 44 EMPLOYEE_BILL_RATE_SCHEDULE LOV custom varchar2 Y select psbrsa.bill_rate_sch_id id, psbrsa.std_bill_rate_schedule value, psbrsa.description from pa_std_bill_rate_schedules_all psbrsa, hr_all_organization_units_vl haouv where psbrsa.org_id=haouv.organization_id and psbrsa.schedule_type='EMPLOYEE' and haouv.name=:$column$.operating_unit order by psbrsa.std_bill_rate_schedule 45 JOB_BILL_RATE_SCHEDULE LOV custom varchar2 Y select psbrsa.bill_rate_sch_id id, psbrsa.std_bill_rate_schedule value, psbrsa.description from pa_std_bill_rate_schedules_all psbrsa, hr_all_organization_units_vl haouv where psbrsa.org_id=haouv.organization_id and psbrsa.schedule_type='JOB' and haouv.name=:$column$.operating_unit order by psbrsa.std_bill_rate_schedule 46 NON_LABOR_BILL_RATE_SCHEDULE LOV custom varchar2 Y select psbrsa.bill_rate_sch_id id, psbrsa.std_bill_rate_schedule value, psbrsa.description from pa_std_bill_rate_schedules_all psbrsa, hr_all_organization_units_vl haouv where psbrsa.schedule_type='NON-LABOR' and psbrsa.org_id=haouv.organization_id and haouv.name=:$column$.non_labor_bill_rate_org order by psbrsa.std_bill_rate_schedule 47 INVOICE_METHOD LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='INVOICE METHOD' and flvv.view_application_id=275 and flvv.enabled_flag='Y' order by flvv.lookup_code 48 GENERATE_ETC_SOURCE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='PA_TASK_LVL_ETC_SRC' and flvv.view_application_id=275 and flvv.enabled_flag='Y' order by flvv.lookup_code 49 ADJUST_ON_STANDARD_INVOICE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='PA_ADJ_ON_STD_INV' and flvv.enabled_flag='Y' order by value 50 COST_BURDEN_SCHEDULE LOV custom varchar2 Y select pirsab.ind_rate_sch_id id, pirsab.ind_rate_sch_name value, pirsab.description from pa_ind_rate_schedules_all_bg pirsab where nvl(pirsab.end_date_active,sysdate)>=sysdate order by value 51 COST_IND_SCHEDULE_FIXED_DATE Date date 52 REVENUE_BURDEN_SCHEDULE LOV custom varchar2 Y select pirsab.ind_rate_sch_id id, pirsab.ind_rate_sch_name value, pirsab.description from pa_ind_rate_schedules_all_bg pirsab where nvl(pirsab.end_date_active,sysdate)>=sysdate order by value 53 REVENUE_IND_SCHED_FIXED_DT Date date Revenue Ind Schedule Fixed Date 54 INVOICE_BURDEN_SCHEDULE LOV custom varchar2 Y select pirsab.ind_rate_sch_id id, pirsab.ind_rate_sch_name value, pirsab.description from pa_ind_rate_schedules_all_bg pirsab where nvl(pirsab.end_date_active,sysdate)>=sysdate order by value 55 INVOICE_IND_SCHED_FIXED_DT Date date Invoice Ind Schedule Fixed Date 56 ALLOW_CROSS_CHARGE LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 57 CROSS_CHARGE_PROCESS_LABOR LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 58 CROSS_CHARGE_PROCESS_NON_LABOR LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 59 LABOR_TRANSFER_PRICE_SCHEDULE LOV custom varchar2 Y select pctsb.tp_schedule_id id, pctsb.name value, pctsb.description from pa_cc_tp_schedules_bg pctsb order by value 60 LABOR_TRANSFER_PRICE_FIXED_DT Date date Labor Transfer Price Fixed Date 61 NON_LABOR_TRANSFER_PRICE_SCHED LOV custom varchar2 Y select pctsb.tp_schedule_id id, pctsb.name value, pctsb.description from pa_cc_tp_schedules_bg pctsb order by value Non Labor Transfer Price Schedule 62 NON_LABOR_TRANS_PRICE_FXD_DT Date date Non Labor Transfer Price Fixed Date 63 IC_LABOR_TRANSFER_PRICE_SCHED LOV custom varchar2 Y select pctsb.tp_schedule_id id, pctsb.name value, pctsb.description from pa_cc_tp_schedules_bg pctsb order by value Intercompany Labor Transfer Price Schedule 64 IC_LABOR_TRANS_PRICE_FXD_DT Date date Intercompany Labor Transfer Price Fixed Date 65 IC_NON_LAB_TRANS_PRICE_SCHED LOV custom varchar2 Y select pctsb.tp_schedule_id id, pctsb.name value, pctsb.description from pa_cc_tp_schedules_bg pctsb order by value Intercompany Non Labor Transfer Price Schedule 66 IC_NON_LAB_TRANS_PRICE_FXD_DT Date date Intercompany Non Labor Transfer Price Fixed Date 67 PROJECT_RATE_TYPE LOV custom varchar2 Y select pctv.conversion_type id, pctv.user_conversion_type value, pctv.description from pa_conversion_types_v pctv where pctv.conversion_type<>'User' 68 PROJECT_RATE_DATE Date date 69 TASK_FUNCTIONAL_COST_RATE_TYPE LOV custom varchar2 Y select pctv.conversion_type id, pctv.user_conversion_type value, pctv.description from pa_conversion_types_v pctv where pctv.conversion_type<>'User' 70 TASK_FUNCTIONAL_COST_RATE_DATE Date date 71 CAPITAL_INTEREST_ELIGIBLE LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 72 CAPITAL_INTEREST_STOP_DATE Date date 73 ADDRESS LOV custom varchar2 Y select distinct hps.party_site_id id, hl.address1||nvl2(hl.city,', '||hl.city,null)||nvl2(hl.state,', '||hl.state,null)||nvl2(hl.country,', '||hl.country,null) value, null description from hz_party_sites hps, hz_locations hl, hz_cust_acct_sites_all hcasa, hz_cust_site_uses hcsu, pa_project_customers ppc, pa_projects_v ppv where hcasa.party_site_id=hps.party_site_id and hps.location_id=hl.location_id and hcasa.cust_account_id=ppc.customer_id and ppc.project_id=ppv.project_id and ppv.segment1=:$column$.project_number and hcasa.cust_acct_site_id=hcsu.cust_acct_site_id and nvl(hcsu.status,'A')='A' and hcsu.site_use_code='SHIP_TO' order by value 74 CUSTOMER_NAME LOV custom varchar2 Y select hca.cust_account_id id, hp.party_name value, null description from hz_cust_accounts hca, hz_parties hp, pa_project_customers ppc, pa_projects_v ppv where hca.party_id=hp.party_id and hca.status='A' and ppc.customer_id=hca.cust_account_id and ppc.project_id=ppv.project_id and ppv.segment1=:$column$.project_number order by hp.party_name 75 ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=275 and fdfv.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and fdfcv.descriptive_flex_context_code!='Global Data Elements' order by fdfcv.descriptive_flex_context_name 76 ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>275, p_descriptive_flexfield_name=>'PA_TASKS_DESC_FLEX', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=275 and dff.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and dffcu.application_column_name='ATTRIBUTE1' 77 ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>275, p_descriptive_flexfield_name=>'PA_TASKS_DESC_FLEX', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=275 and dff.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and dffcu.application_column_name='ATTRIBUTE2' 78 ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>275, p_descriptive_flexfield_name=>'PA_TASKS_DESC_FLEX', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=275 and dff.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and dffcu.application_column_name='ATTRIBUTE3' 79 ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>275, p_descriptive_flexfield_name=>'PA_TASKS_DESC_FLEX', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=275 and dff.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and dffcu.application_column_name='ATTRIBUTE4' 80 ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>275, p_descriptive_flexfield_name=>'PA_TASKS_DESC_FLEX', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=275 and dff.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and dffcu.application_column_name='ATTRIBUTE5' 81 ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>275, p_descriptive_flexfield_name=>'PA_TASKS_DESC_FLEX', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=275 and dff.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and dffcu.application_column_name='ATTRIBUTE6' 82 ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>275, p_descriptive_flexfield_name=>'PA_TASKS_DESC_FLEX', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=275 and dff.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and dffcu.application_column_name='ATTRIBUTE7' 83 ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>275, p_descriptive_flexfield_name=>'PA_TASKS_DESC_FLEX', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=275 and dff.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and dffcu.application_column_name='ATTRIBUTE8' 84 ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>275, p_descriptive_flexfield_name=>'PA_TASKS_DESC_FLEX', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=275 and dff.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and dffcu.application_column_name='ATTRIBUTE9' 85 ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov (p_application_id=>275, p_descriptive_flexfield_name=>'PA_TASKS_DESC_FLEX', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.attribute1, p_attribute2=>:$column$.attribute2, p_attribute3=>:$column$.attribute3, p_attribute4=>:$column$.attribute4, p_attribute5=>:$column$.attribute5, p_attribute6=>:$column$.attribute6, p_attribute7=>:$column$.attribute7, p_attribute8=>:$column$.attribute8, p_attribute9=>:$column$.attribute9, p_attribute10=>:$column$.attribute10 ) ) lov order by value select distinct '(Context) ' || initcap(dffcu.application_column_name) || ': ' || listagg(decode(dffcx.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || dffcx.descriptive_flex_context_code || ')') || ' ' || dffcu.form_left_prompt,', ') within group (order by decode(dffcx.descriptive_flex_context_code,'Global Data Elements',1,2),dffcx.descriptive_flex_context_code) over (partition by dffcu.application_column_name) from fnd_descriptive_flexs_vl dff, fnd_descr_flex_contexts dffcx, fnd_descr_flex_col_usage_vl dffcu where dffcx.application_id=dff.application_id and dffcx.descriptive_flexfield_name=dff.descriptive_flexfield_name and dffcx.enabled_flag='Y' and dffcu.application_id=dffcx.application_id and dffcu.descriptive_flexfield_name=dffcx.descriptive_flexfield_name and dffcu.descriptive_flex_context_code=dffcx.descriptive_flex_context_code and dffcu.enabled_flag='Y' and dff.application_id=275 and dff.descriptive_flexfield_name='PA_TASKS_DESC_FLEX' and dffcu.application_column_name='ATTRIBUTE10' 86 PUBLISH_STRUCTURE LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual union all select 'N' id, xxen_util.meaning('N','YES_NO',0) value, null description from dual 87 UPLOAD_ROW Number number Y U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_task_id in/out Number TASK_ID U 5 p_org_id in Number OPERATING_UNIT U 6 p_pa_project_id in Number PROJECT_NUMBER U 7 p_pm_product_code in Char Y U 8 p_task_number in Char TASK_NUMBER U 9 p_task_name in Char TASK_NAME U 10 p_long_task_name in Char Y LONG_TASK_NAME U 11 p_task_description in Char Y DESCRIPTION U 12 p_parent_task_number in Char Y PARENT_TASK_NUMBER U 13 p_task_start_date in Date Y START_DATE U 14 p_task_completion_date in Date Y END_DATE U 15 p_carrying_out_organization_id in Number Y ORGANIZATION U 16 p_task_manager_person_id in Number Y TASK_MANAGER U 17 p_service_type_code in Char Y SERVICE_TYPE U 18 p_work_type_id in Number Y WORK_TYPE U 19 p_billable_flag in Char Y BILLABLE U 20 p_chargeable_flag in Char Y ALLOW_CHARGES U 21 p_ready_to_bill_flag in Char Y READY_TO_BILL U 22 p_ready_to_distribute_flag in Char Y READY_TO_DISTRIBUTE U 23 p_limit_to_txn_controls_flag in Char Y LIMIT_TO_TXN_CONTROLS U 24 p_allow_cross_charge_flag in Char Y ALLOW_CROSS_CHARGE U 25 p_receive_project_invoice_flag in Char Y RECEIVE_INTER_PROJECT_INVOICES U 26 p_retirement_cost_flag in Char Y RETIREMENT_COST U 27 p_cint_eligible_flag in Char Y CAPITAL_INTEREST_ELIGIBLE U 28 p_labor_bill_rate_org_id in Number Y U 29 p_labor_std_bill_rate_schdl in Char Y LABOR_STD_BILL_RATE_SCHEDULE U 30 p_labor_schedule_fixed_date in Date Y LABOR_SCHEDULE_FIXED_DATE U 31 p_labor_schedule_discount in Number Y LABOR_SCHEDULE_DISCOUNT U 32 p_nl_bill_rate_org_id in Number Y NON_LABOR_BILL_RATE_ORG U 33 p_nl_std_bill_rate_schdl in Char Y NON_LABOR_STD_BILL_RATE_SCHED U 34 p_nl_schedule_fixed_date in Date Y NON_LABOR_SCHEDULE_FIXED_DATE U 35 p_nl_schedule_discount in Number Y NON_LABOR_SCHEDULE_DISCOUNT U 36 p_labor_disc_reason_code in Char Y LABOR_DISCOUNT_REASON U 37 p_non_labor_disc_reason_code in Char Y NON_LABOR_DISCOUNT_REASON U 38 p_labor_cost_multiplier_name in Char Y LABOR_COST_MULTIPLIER_NAME U 39 p_labor_sch_type in Char Y LABOR_SCHEDULE_TYPE U 40 p_nl_sch_type in Char Y NON_LABOR_SCHEDULE_TYPE U 41 p_emp_bill_rate_schedule_id in Number Y EMPLOYEE_BILL_RATE_SCHEDULE U 42 p_job_bill_rate_schedule_id in Number Y JOB_BILL_RATE_SCHEDULE U 43 p_non_lab_std_bill_rt_sch_id in Number Y NON_LABOR_BILL_RATE_SCHEDULE U 44 p_cost_ind_rate_sch_id in Number Y COST_BURDEN_SCHEDULE U 45 p_rev_ind_rate_sch_id in Number Y REVENUE_BURDEN_SCHEDULE U 46 p_inv_ind_rate_sch_id in Number Y INVOICE_BURDEN_SCHEDULE U 47 p_cost_ind_sch_fixed_date in Date Y COST_IND_SCHEDULE_FIXED_DATE U 48 p_rev_ind_sch_fixed_date in Date Y REVENUE_IND_SCHED_FIXED_DT U 49 p_inv_ind_sch_fixed_date in Date Y INVOICE_IND_SCHED_FIXED_DT U 50 p_cc_process_labor_flag in Char Y CROSS_CHARGE_PROCESS_LABOR U 51 p_cc_process_nl_flag in Char Y CROSS_CHARGE_PROCESS_NON_LABOR U 52 p_labor_tp_schedule_id in Number Y LABOR_TRANSFER_PRICE_SCHEDULE U 53 p_labor_tp_fixed_date in Date Y LABOR_TRANSFER_PRICE_FIXED_DT U 54 p_nl_tp_schedule_id in Number Y NON_LABOR_TRANSFER_PRICE_SCHED U 55 p_nl_tp_fixed_date in Date Y NON_LABOR_TRANS_PRICE_FXD_DT U 56 p_ic_labor_tp_schedule_id in Number Y IC_LABOR_TRANSFER_PRICE_SCHED U 57 p_ic_labor_tp_fixed_date in Date Y IC_LABOR_TRANS_PRICE_FXD_DT U 58 p_ic_nl_tp_schedule_id in Number Y IC_NON_LAB_TRANS_PRICE_SCHED U 59 p_ic_nl_tp_fixed_date in Date Y IC_NON_LAB_TRANS_PRICE_FXD_DT U 60 p_project_rate_type in Char Y PROJECT_RATE_TYPE U 61 p_project_rate_date in Date Y PROJECT_RATE_DATE U 62 p_taskfunc_cost_rate_type in Char Y TASK_FUNCTIONAL_COST_RATE_TYPE U 63 p_taskfunc_cost_rate_date in Date Y TASK_FUNCTIONAL_COST_RATE_DATE U 64 p_invoice_method in Char Y INVOICE_METHOD U 65 p_customer_id in Number Y CUSTOMER_NAME U 66 p_gen_etc_source_code in Char Y GENERATE_ETC_SOURCE U 67 p_adj_on_std_inv in Char Y ADJUST_ON_STANDARD_INVOICE U 68 p_cint_stop_date in Date Y CAPITAL_INTEREST_STOP_DATE U 69 p_address_id in Number Y ADDRESS U 70 p_tasks_dff in Char Y U 71 p_attribute_category in Char Y ATTRIBUTE_CATEGORY U 72 p_attribute1 in Char Y ATTRIBUTE1 U 73 p_attribute2 in Char Y ATTRIBUTE2 U 74 p_attribute3 in Char Y ATTRIBUTE3 U 75 p_attribute4 in Char Y ATTRIBUTE4 U 76 p_attribute5 in Char Y ATTRIBUTE5 U 77 p_attribute6 in Char Y ATTRIBUTE6 U 78 p_attribute7 in Char Y ATTRIBUTE7 U 79 p_attribute8 in Char Y ATTRIBUTE8 U 80 p_attribute9 in Char Y ATTRIBUTE9 U 81 p_attribute10 in Char Y ATTRIBUTE10 U 82 p_publish_structure in Char Y PUBLISH_STRUCTURE Error SQL Order By case when x.upload_row>0 then 0 else 1 end, operating_unit, project_number, (select pa_task_utils.sort_order_tree_walk(pt.parent_task_id, pt.task_number) from pa_tasks pt where pt.task_id=x.task_id) Success SQL select xm.action_, xm.status_, xm.message_, xm.request_id_, xm.modified_columns_, -- operating unit haouv.name operating_unit, -- project ppv.segment1 project_number, ppv.name project_name, ppv.project_type, ppv.project_status_m project_status, ppf0.full_name project_manager, -- task ppe.proj_element_id task_id, ppe.element_number task_number, ppe.name task_name, pt.long_task_name, ppe.description, lpad(' ',2*(pt.wbs_level-1))||pt.wbs_level wbs_level, pt2.task_number parent_task_number, -- task dates ppe.start_date, ppe.completion_date end_date, -- organization haouv2.name organization, -- task manager ppf.full_name task_manager, -- service type xxen_util.meaning(pt.service_type_code,'SERVICE TYPE',275) service_type, -- work type pwtv.name work_type, -- flags decode(ppe.chargeable_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) allow_charges, decode(ppe.billable_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) billable, decode(pt.ready_to_bill_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) ready_to_bill, decode(pt.ready_to_distribute_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) ready_to_distribute, decode(pt.limit_to_txn_controls_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) limit_to_txn_controls, decode(nvl(ppe.receive_project_invoice_flag,pt.receive_project_invoice_flag),'Y',xxen_util.meaning('Y','YES_NO',0)) receive_inter_project_invoices, decode(pt.retirement_cost_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) retirement_cost, -- billing schedules xxen_util.meaning(pt.labor_sch_type,'PROJECT SCHEDULE TYPE',275) labor_schedule_type, psbrsa4.std_bill_rate_schedule labor_std_bill_rate_schedule, pt.labor_schedule_fixed_date, pt.labor_schedule_discount, xxen_util.meaning(pt.labor_disc_reason_code,'RATE AND DISCOUNT REASON',275) labor_discount_reason, xxen_util.meaning(pt.non_labor_sch_type,'PROJECT SCHEDULE TYPE',275) non_labor_schedule_type, haouv4.name non_labor_bill_rate_org, psbrsa5.std_bill_rate_schedule non_labor_std_bill_rate_sched, pt.non_labor_schedule_fixed_date, pt.non_labor_schedule_discount, xxen_util.meaning(pt.non_labor_disc_reason_code,'RATE AND DISCOUNT REASON',275) non_labor_discount_reason, pt.labor_cost_multiplier_name, 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, xxen_util.meaning(pt.invoice_method,'INVOICE METHOD',275) invoice_method, xxen_util.meaning(pt.gen_etc_source_code,'PA_TASK_LVL_ETC_SRC',275) generate_etc_source, xxen_util.meaning(pt.adj_on_std_inv,'PA_ADJ_ON_STD_INV',275) adjust_on_standard_invoice, -- burden schedules pirsab1.ind_rate_sch_name cost_burden_schedule, pt.cost_ind_sch_fixed_date cost_ind_schedule_fixed_date, pirsab2.ind_rate_sch_name revenue_burden_schedule, pt.rev_ind_sch_fixed_date revenue_ind_sched_fixed_dt, pirsab3.ind_rate_sch_name invoice_burden_schedule, pt.inv_ind_sch_fixed_date invoice_ind_sched_fixed_dt, -- cross charge decode(pt.allow_cross_charge_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) allow_cross_charge, decode(pt.cc_process_labor_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) cross_charge_process_labor, decode(pt.cc_process_nl_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) cross_charge_process_non_labor, pctsb1.name labor_transfer_price_schedule, pt.labor_tp_fixed_date labor_transfer_price_fixed_dt, pctsb2.name non_labor_transfer_price_sched, pt.nl_tp_fixed_date non_labor_trans_price_fxd_dt, -- intercompany pctsb3.name ic_labor_transfer_price_sched, pt.ic_labor_tp_fixed_date ic_labor_trans_price_fxd_dt, pctsb4.name ic_non_lab_trans_price_sched, pt.ic_nl_tp_fixed_date ic_non_lab_trans_price_fxd_dt, -- rate info gdct1.user_conversion_type project_rate_type, pt.project_rate_date, gdct2.user_conversion_type task_functional_cost_rate_type, pt.taskfunc_cost_rate_date task_functional_cost_rate_date, -- capital interest decode(pt.cint_eligible_flag,'Y',xxen_util.meaning('Y','YES_NO',0)) capital_interest_eligible, pt.cint_stop_date capital_interest_stop_date, -- address hl.address1||nvl2(hl.city,', '||hl.city,null)||nvl2(hl.state,', '||hl.state,null)||nvl2(hl.country,', '||hl.country,null) address, -- customer hp.party_name customer_name, -- DFF xxen_util.display_flexfield_context(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category) attribute_category, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category,'ATTRIBUTE1',ppe.rowid,ppe.attribute1) attribute1, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category,'ATTRIBUTE2',ppe.rowid,ppe.attribute2) attribute2, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category,'ATTRIBUTE3',ppe.rowid,ppe.attribute3) attribute3, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category,'ATTRIBUTE4',ppe.rowid,ppe.attribute4) attribute4, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category,'ATTRIBUTE5',ppe.rowid,ppe.attribute5) attribute5, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category,'ATTRIBUTE6',ppe.rowid,ppe.attribute6) attribute6, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category,'ATTRIBUTE7',ppe.rowid,ppe.attribute7) attribute7, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category,'ATTRIBUTE8',ppe.rowid,ppe.attribute8) attribute8, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category,'ATTRIBUTE9',ppe.rowid,ppe.attribute9) attribute9, xxen_util.display_flexfield_value(275,'PA_TASKS_DESC_FLEX',ppe.attribute_category,'ATTRIBUTE10',ppe.rowid,ppe.attribute10) attribute10, xm.publish_structure, 0 upload_row from pa_projects_v ppv, pa_proj_elements ppe, pa_tasks pt, pa_tasks pt2, hr_all_organization_units_vl haouv, hr_all_organization_units_vl haouv2, hr_all_organization_units_vl haouv4, per_all_people_f ppf, per_all_people_f ppf0, pa_project_parties ppp, pa_work_types_vl pwtv, pa_std_bill_rate_schedules_all psbrsa1, pa_std_bill_rate_schedules_all psbrsa2, pa_std_bill_rate_schedules_all psbrsa3, pa_std_bill_rate_schedules_all psbrsa4, pa_std_bill_rate_schedules_all psbrsa5, pa_ind_rate_schedules_all_bg pirsab1, pa_ind_rate_schedules_all_bg pirsab2, pa_ind_rate_schedules_all_bg pirsab3, pa_cc_tp_schedules_bg pctsb1, pa_cc_tp_schedules_bg pctsb2, pa_cc_tp_schedules_bg pctsb3, pa_cc_tp_schedules_bg pctsb4, gl_daily_conversion_types gdct1, gl_daily_conversion_types gdct2, hz_party_sites hps, hz_locations hl, hz_cust_accounts hca, hz_parties hp, xxen_pa_project_task_up_1952_u xm where nvl(xm.status_code_,xxen_upload.status_error)=xxen_upload.status_success and xm.project_number=ppv.segment1 and ppv.template_flag='N' and ppv.org_id=haouv.organization_id and xm.task_id_chr=ppe.proj_element_id and ppe.object_type='PA_TASKS' and ppe.project_id=ppv.project_id and ppe.proj_element_id=pt.task_id(+) and pt.parent_task_id=pt2.task_id(+) and ppe.carrying_out_organization_id=haouv2.organization_id(+) and ppe.manager_person_id=ppf.person_id(+) and trunc(sysdate) between ppf.effective_start_date(+) and ppf.effective_end_date(+) and ppv.project_id=ppp.project_id(+) and ppp.project_role_id(+)=1 and nvl(ppp.end_date_active(+),sysdate)>=sysdate and ppp.resource_source_id=ppf0.person_id(+) and trunc(sysdate) between ppf0.effective_start_date(+) and ppf0.effective_end_date(+) and pt.work_type_id=pwtv.work_type_id(+) and pt.emp_bill_rate_schedule_id=psbrsa1.bill_rate_sch_id(+) and pt.job_bill_rate_schedule_id=psbrsa2.bill_rate_sch_id(+) and pt.non_lab_std_bill_rt_sch_id=psbrsa3.bill_rate_sch_id(+) and pt.labor_std_bill_rate_schdl=psbrsa4.std_bill_rate_schedule(+) and pt.labor_bill_rate_org_id=psbrsa4.org_id(+) and pt.non_labor_std_bill_rate_schdl=psbrsa5.std_bill_rate_schedule(+) and pt.non_labor_bill_rate_org_id=psbrsa5.org_id(+) and pt.cost_ind_rate_sch_id=pirsab1.ind_rate_sch_id(+) and pt.rev_ind_rate_sch_id=pirsab2.ind_rate_sch_id(+) and pt.inv_ind_rate_sch_id=pirsab3.ind_rate_sch_id(+) and pt.non_labor_bill_rate_org_id=haouv4.organization_id(+) and pt.labor_tp_schedule_id=pctsb1.tp_schedule_id(+) and pt.nl_tp_schedule_id=pctsb2.tp_schedule_id(+) and pt.ic_labor_tp_schedule_id=pctsb3.tp_schedule_id(+) and pt.ic_nl_tp_schedule_id=pctsb4.tp_schedule_id(+) and pt.project_rate_type=gdct1.conversion_type(+) and pt.taskfunc_cost_rate_type=gdct2.conversion_type(+) and pt.address_id=hps.party_site_id(+) and hps.location_id=hl.location_id(+) and pt.customer_id=hca.cust_account_id(+) and hca.party_id=hp.party_id(+) LOV query :$column$.project_number PROJECT_NUMBER ADDRESS 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 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 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 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 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 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 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 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 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 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 LOV query :$column$.project_number PROJECT_NUMBER CUSTOMER_NAME LOV query :$column$.operating_unit OPERATING_UNIT EMPLOYEE_BILL_RATE_SCHEDULE LOV query :$column$.operating_unit OPERATING_UNIT JOB_BILL_RATE_SCHEDULE LOV query :$column$.operating_unit OPERATING_UNIT LABOR_STD_BILL_RATE_SCHEDULE LOV query :$column$.non_labor_bill_rate_org NON_LABOR_BILL_RATE_ORG NON_LABOR_BILL_RATE_SCHEDULE LOV query :$column$.non_labor_bill_rate_org NON_LABOR_BILL_RATE_ORG NON_LABOR_STD_BILL_RATE_SCHED LOV query :$column$.operating_unit OPERATING_UNIT ORGANIZATION LOV query :$column$.project_number PROJECT_NUMBER PARENT_TASK_NUMBER LOV query :$column$.task_number TASK_NUMBER PARENT_TASK_NUMBER Default value :$column$.project_number PROJECT_NUMBER 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_STATUS Default value :$column$.project_number PROJECT_NUMBER PROJECT_TYPE Value to id query :$column$.non_labor_bill_rate_org NON_LABOR_BILL_RATE_ORG p_non_lab_std_bill_rt_sch_id Value to id query :$column$.operating_unit OPERATING_UNIT p_carrying_out_organization_id Value to id query :$column$.operating_unit OPERATING_UNIT p_emp_bill_rate_schedule_id Value to id query :$column$.operating_unit OPERATING_UNIT p_job_bill_rate_schedule_id Value to id query :$column$.operating_unit OPERATING_UNIT p_pa_project_id Value to id query :$column$.project_number PROJECT_NUMBER p_address_id Value to id query :$column$.project_number PROJECT_NUMBER p_customer_id