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 8E2FF36EDE9079D2E0530100007F1FF2 FND Currency Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code US 91D3167A335F1204E053BB6B63585EE3 GL Currency Conversion Type Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 US 197A8DE62B015A76E0636AFB0905DDF9 select null action_, null status_, null message_, null request_id_, null modified_columns_, null row_id, -- haouv.name operating_unit, (select pts.user_transaction_source from pa_transaction_sources pts where pts.transaction_source = ptia.transaction_source) transaction_source, xxen_pa_upload.get_system_linkage_meaning(ptia.system_linkage) expnd_type_class, ptia.expenditure_ending_date expnd_ending_date, ptia.batch_name batch_name, ptia.orig_transaction_reference original_trans_ref, -- ptia.organization_name organization_name, null employee_name, ptia.employee_number employee_number, ptia.person_business_group_name business_group, ptia.person_type person_type, ptia.override_to_organization_name override_to_organization, -- ptia.expenditure_item_date expnd_item_date, ptia.project_number project_number, null project_name, ptia.task_number task_number, null task_name, ptia.expenditure_type expnd_type, -- ptia.non_labor_resource non_labor_resource, --usages ptia.non_labor_resource_org_name non_labor_org, --usages ptia.assignment_name assignment_name, -- timecards ptia.work_type_name work_type_name, -- ptia.quantity quantity, -- ptia.denom_currency_code trans_curr, ptia.denom_raw_cost trans_raw_cost, ptia.denom_burdened_cost trans_burdened_cost, ptia.acct_raw_cost acctd_raw_cost, ptia.acct_burdened_cost acctd_burdened_cost, ptia.raw_cost_rate, ptia.burdened_cost_rate, -- ptia.acct_rate_type acctd_exchange_rate_type, ptia.acct_rate_date acctd_exchange_rate_date, ptia.acct_exchange_rate acctd_exchange_rate, ptia.acct_exchange_rounding_limit acctd_exchange_rounding_limit, -- ptia.receipt_currency_code, ptia.receipt_currency_amount, ptia.receipt_exchange_rate, ptia.project_rate_type, ptia.project_rate_date, ptia.project_exchange_rate, ptia.projfunc_cost_rate_type project_func_rate_type, ptia.projfunc_cost_rate_date project_func_rate_date, ptia.projfunc_cost_exchange_rate project_func_exchange_rate, -- ptia.reversed_orig_txn_reference reversed_orig_trans_ref, ptia.unmatched_negative_txn_flag negative_txn_flag, ptia.accrual_flag, ptia.billable_flag, -- ptia.gl_date gl_date, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = ptia.dr_code_combination_id) debit_acct, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = ptia.cr_code_combination_id) credit_acct, -- ptia.vendor_number vendor_number, ptia.po_number po_number, ptia.po_line_num po_line_number, ptia.po_price_type po_price_type, -- ptia.expenditure_comment, -- ptia.orig_user_exp_txn_reference orig_user_expnd_trans_ref, ptia.orig_exp_txn_reference1 orig_expnd_trans_ref1, ptia.orig_exp_txn_reference2 orig_expnd_trans_ref2, ptia.orig_exp_txn_reference3 orig_expnd_trans_ref3, ptia.cdl_system_reference1 cdl_system_ref1, ptia.cdl_system_reference2 cdl_system_ref2, ptia.cdl_system_reference3 cdl_system_ref3, ptia.cdl_system_reference4 cdl_system_ref4, ptia.cdl_system_reference5 cdl_system_ref5, -- ptia.attribute_category attribute_category, ptia.attribute1 pa_expnd_attribute1, ptia.attribute2 pa_expnd_attribute2, ptia.attribute3 pa_expnd_attribute3, ptia.attribute4 pa_expnd_attribute4, ptia.attribute5 pa_expnd_attribute5, ptia.attribute6 pa_expnd_attribute6, ptia.attribute7 pa_expnd_attribute7, ptia.attribute8 pa_expnd_attribute8, ptia.attribute9 pa_expnd_attribute9, ptia.attribute10 pa_expnd_attribute10, -- xxen_util.meaning(nvl(:p_submit_import,'Y'),'YES_NO',0) import_transactions from pa_transaction_interface_all ptia, hr_all_organization_units_vl haouv where 1=1 and ptia.org_id = haouv.organization_id and :p_upload_mode like '%' || xxen_upload.action_update and haouv.name = nvl(:p_operating_unit,haouv.name) and ptia.transaction_source = nvl(:p_transaction_source,ptia.transaction_source) and ptia.batch_name = nvl(:p_batch_name,ptia.batch_name) and nvl(:p_expnd_ending_date,sysdate) = nvl(:p_expnd_ending_date,sysdate) and nvl(:p_unmatched_neg_txn_flag,'X') = nvl(:p_unmatched_neg_txn_flag,'X') and nvl(:p_accrual_flag,'X') = nvl(:p_accrual_flag,'X') Y U XXEN_PA_UPLOAD A Y xxen_pa_upload.upload_project_transaction xxen_pa_upload.submit_transation_import xxen_pa_upload.validate_project_transaction ( p_operating_unit => :$column$.operating_unit , p_orig_transaction_reference => :$column$.original_trans_ref , p_user_transaction_source => :$column$.transaction_source , p_system_linkage => :$column$.expnd_type_class , p_expenditure_ending_date => :$column$.expnd_ending_date , p_expenditure_item_date => :$column$.expnd_item_date , p_employee_name => :$column$.employee_name , p_employee_number => :$column$.employee_number , p_organization_name => :$column$.organization_name , p_person_business_group_name => :$column$.business_group , p_quantity => :$column$.quantity , p_denom_currency_code => :$column$.trans_curr , p_denom_raw_cost => :$column$.trans_raw_cost , p_denom_burdened_cost => :$column$.trans_burdened_cost , p_acct_raw_cost => :$column$.acctd_raw_cost , p_acct_burdened_cost => :$column$.acctd_burdened_cost , p_acct_rate_date => :$column$.acctd_exchange_rate_date , p_acct_rate_type => :$column$.acctd_exchange_rate_type , p_acct_exchange_rate => :$column$.acctd_exchange_rate , p_dr_code_combination => :$column$.debit_acct , p_cr_code_combination => :$column$.credit_acct , p_gl_date => :$column$.gl_date , p_non_labor_resource => :$column$.non_labor_resource , p_non_labor_resource_org_name => :$column$.non_labor_org , p_accrual_flag => :$column$.accrual_flag ) US PA Transaction Upload PA Transaction Upload =================== This upload can be used to upload transactions from external cost collection systems into Oracle Projects. Transaction Import creates pre-approved expenditure items from transaction data entered in external cost collection systems. If the 'Operating Unit' and/or 'Transaction Source' parameters are specified, then the upload excel will be restricted to the specified Operating Unit and/or Transaction Source. If the 'Batch Name' parameter is specified, this will default as the Batch Name in the upload Excel. If the 'All Negative Expend Unmatched' parameter is set to Yes, then all negative transations then the 'Unmatched Negative Txn Flag' column will automatically default to Yes against any negative transactions entered into upload Excel. If the 'Reverse in Future Period' parameter is set to Yes, then the 'Accrual Flag' column will default to Yes against every transaction entered in the upload Excel Enginatics R12 only Upload 1=1 :p_accrual_flag :p_batch_name :p_expnd_ending_date :p_operating_unit :p_report_code :p_submit_import :p_transaction_source :p_unmatched_neg_txn_flag :p_upload_mode 1 -30 :p_report_code Char PAXTRTRX US Report Code 2 -5 :p_upload_mode 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 3 30 :p_operating_unit LOV custom Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and hou.organization_id in (select pi.org_id from pa_implementations pi) order by hou.name US Operating Unit 4 40 :p_transaction_source LOV custom Y select pts.transaction_source id, pts.user_transaction_source value, pts.description || ' (' || xxen_util.meaning(pts.system_linkage_function,'TIMECARD TRANSLATION',275) || ')' description from pa_transaction_sources pts where trunc(sysdate) between trunc(pts.start_date_active) and nvl(trunc(pts.end_date_active),trunc(sysdate)) order by user_transaction_source US Transaction Source 5 50 :p_batch_name Char US Batch Name 6 60 :p_expnd_ending_date Date US Expenditure Ending Date 7 70 :p_unmatched_neg_txn_flag LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US All Negative Expend Unmatched 8 80 :p_accrual_flag LOV custom Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Reverse in Future Period 9 90 :p_submit_import LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y US Import Transactions 0259B71D0ABF80B6FF6D0A9FBA71B82C Default SYSADMIN 42 ACCRUAL_FLAG 27 ACCTD_BURDENED_COST 30 ACCTD_EXCHANGE_RATE 29 ACCTD_EXCHANGE_RATE_DATE 28 ACCTD_EXCHANGE_RATE_TYPE 31 ACCTD_EXCHANGE_ROUNDING_LIMIT 26 ACCTD_RAW_COST 20 ASSIGNMENT_NAME 5 BATCH_NAME 9 BUSINESS_GROUP 36 CREDIT_ACCT 35 DEBIT_ACCT 7 EMPLOYEE_NAME 8 EMPLOYEE_NUMBER 41 EXPENDITURE_COMMENT 4 EXPND_ENDING_DATE 12 EXPND_ITEM_DATE 17 EXPND_TYPE 3 EXPND_TYPE_CLASS 34 GL_DATE 33 NEGATIVE_TXN_FLAG 19 NON_LABOR_ORG 18 NON_LABOR_RESOURCE 1 OPERATING_UNIT 6 ORGANIZATION_NAME 11 ORIGINAL_TRANS_REF 10 PERSON_TYPE 39 PO_LINE_NUMBER 38 PO_NUMBER 40 PO_PRICE_TYPE 14 PROJECT_NAME 13 PROJECT_NUMBER 22 QUANTITY 32 REVERSED_ORIG_TRANS_REF 16 TASK_NAME 15 TASK_NUMBER 2 TRANSACTION_SOURCE 25 TRANS_BURDENED_COST 23 TRANS_CURR 24 TRANS_RAW_COST -22.0023 UNMATCHED_NEGATIVE_TXN_FLAG 37 VENDOR_NUMBER 21 WORK_TYPE_NAME S Site 0259B71D0ABF80B6FF6D0A9FBA71B82C 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 ROW_ID Char varchar2 Y 7 OPERATING_UNIT LOV custom varchar2 Y select hou.name value, null description from hr_operating_units hou where hou.organization_id in (select pi.org_id from pa_implementations pi) and hou.name = nvl(:$flex$.operating_unit,hou.name) order by hou.name select haouv.organization_id id, haouv.name value from hr_all_organization_units_vl haouv :$flex$.operating_unit Y 8 TRANSACTION_SOURCE LOV custom varchar2 Y select pts.transaction_source id, pts.user_transaction_source value, pts.description from pa_transaction_sources pts where trunc(sysdate) between trunc(pts.start_date_active) and nvl(trunc(pts.end_date_active),trunc(sysdate)) and pts.transaction_source = nvl(:$flex$.transaction_source,pts.transaction_source) order by value select pts.transaction_source id, pts.user_transaction_source value from pa_transaction_sources pts where trunc(sysdate) between trunc(pts.start_date_active) and nvl(trunc(pts.end_date_active),trunc(sysdate)) select pts.user_transaction_source from pa_transaction_sources pts where trunc(sysdate) between trunc(pts.start_date_active) and nvl(trunc(pts.end_date_active),trunc(sysdate)) and pts.transaction_source = :$flex$.transaction_source Y 9 EXPND_TYPE_CLASS LOV custom varchar2 Y select psl.function id, xxen_pa_upload.get_system_linkage_meaning(psl.function) value, null description from pa_transaction_sources pts, pa_system_linkages psl where pts.user_transaction_source = :$column$.transaction_source and trunc(sysdate) between nvl(trunc(pts.start_date_active),trunc(sysdate)) and nvl(trunc(pts.end_date_active),trunc(sysdate)) and (pts.system_linkage_function = psl.function or pts.system_linkage_function = 'ST' and psl.function in ('ST','OT') ) order by value select psl.function id, xxen_pa_upload.get_system_linkage_meaning(psl.function) value from pa_system_linkages psl select xxen_pa_upload.get_system_linkage_meaning(pts.system_linkage_function) from pa_transaction_sources pts, pa_system_linkages psl where pts.system_linkage_function = psl.function and pts.user_transaction_source = :$column$.transaction_source and trunc(sysdate) between nvl(trunc(pts.start_date_active),trunc(sysdate)) and nvl(trunc(pts.end_date_active),trunc(sysdate)) Y 10 EXPND_ENDING_DATE Date date select --from pa_utils.newgetweekending next_day(trunc(:$flex$.Expenditure_Ending_Date)-1,to_char(to_date('01-01-1950','DD-MM-YYYY') + (decode( pia.exp_cycle_start_day_code, 1, 8, pia.exp_cycle_start_day_code )-1) - 1, 'Day')) end_date from hr_all_organization_units_vl haouv, pa_implementations_all pia where haouv.organization_id = pia.org_id and haouv.name = :$column$.operating_unit Y 11 BATCH_NAME Char varchar2 :$flex$.batch_name Y 12 ORIGINAL_TRANS_REF Char varchar2 Y 13 ORGANIZATION_NAME LOV custom varchar2 Y select poev.organization_id id, poev.name value, null description from hr_all_organization_units_vl haouv, pa_organizations_expend_v poev where haouv.organization_id = poev.org_id and haouv.name = :$column$.operating_unit and poev.active_flag = 'Y' and sysdate between nvl(poev.date_from,sysdate) and nvl(poev.date_to,sysdate) order by value 14 EMPLOYEE_NAME LOV custom varchar2 Y select pe.person_id id, pe.full_name value, pe.employee_number || ' (' || xxen_util.meaning(decode(paf.assignment_type,'C','CWK','EMP'),'PA_PERSON_TYPE',275) || ')' description from pa_employees pe, per_assignments_f paf, hr_all_organization_units_vl haouv, per_assignment_status_types past where pe.person_id = paf.person_id and paf.organization_id = haouv.organization_id and paf.assignment_status_type_id = past.assignment_status_type_id and (:$column$.organization_name is null or haouv.name = :$column$.organization_name) and paf.primary_flag = 'Y' and :$column$.expnd_ending_date between paf.effective_start_date and paf.effective_end_date + 6 and paf.job_id is not null and paf.assignment_type in ('C','E') and ( (paf.assignment_type = 'E' and past.per_system_status in ('ACTIVE_ASSIGN','TERM_ASSIGN')) or (paf.assignment_type = 'E' and past.per_system_status = 'ACTIVE_CWK') ) order by value 15 EMPLOYEE_NUMBER LOV custom varchar2 Y select pe.person_id id, pe.employee_number value, pe.full_name || ' (' || xxen_util.meaning(decode(paf.assignment_type,'C','CWK','EMP'),'PA_PERSON_TYPE',275) || ')' description from pa_employees pe, per_assignments_f paf, hr_all_organization_units_vl haouv, per_assignment_status_types past where pe.person_id = paf.person_id and paf.organization_id = haouv.organization_id and paf.assignment_status_type_id = past.assignment_status_type_id and (:$column$.organization_name is null or haouv.name = :$column$.organization_name) and (:$column$.employee_name is null or pe.full_name = :$column$.employee_name) and paf.primary_flag = 'Y' and :$column$.expnd_ending_date between paf.effective_start_date and paf.effective_end_date + 6 and paf.job_id is not null and paf.assignment_type in ('C','E') and ( (paf.assignment_type = 'E' and past.per_system_status in ('ACTIVE_ASSIGN','TERM_ASSIGN')) or (paf.assignment_type = 'E' and past.per_system_status = 'ACTIVE_CWK') ) order by value select distinct pe.employee_number from pa_employees pe, per_assignments_f paf, hr_all_organization_units_vl haouv, per_assignment_status_types past where pe.person_id = paf.person_id and paf.organization_id = haouv.organization_id and paf.assignment_status_type_id = past.assignment_status_type_id and (:$column$.organization_name is null or haouv.name = :$column$.organization_name) and pe.full_name = :$column$.employee_name and paf.primary_flag = 'Y' and :$column$.expnd_ending_date between paf.effective_start_date and paf.effective_end_date + 6 and paf.job_id is not null and paf.assignment_type in ('C','E') and ( (paf.assignment_type = 'E' and past.per_system_status in ('ACTIVE_ASSIGN','TERM_ASSIGN')) or (paf.assignment_type = 'E' and past.per_system_status = 'ACTIVE_CWK') ) 16 BUSINESS_GROUP LOV custom varchar2 Y select distinct pbg.business_group_id id, pbg.name value, pbg.short_name description from per_people_x ppx, per_business_groups pbg where pbg.business_group_id = ppx.business_group_id and ppx.person_id in ( select pe.person_id id from pa_employees pe, per_assignments_f paf, hr_all_organization_units_vl haouv, per_assignment_status_types past where pe.person_id = paf.person_id and paf.organization_id = haouv.organization_id and paf.assignment_status_type_id = past.assignment_status_type_id and (:$column$.organization_name is null or haouv.name = :$column$.organization_name) and (:$column$.employee_name is null or pe.full_name = :$column$.employee_name) and pe.employee_number = :$column$.employee_number and paf.primary_flag = 'Y' and :$column$.expnd_ending_date between paf.effective_start_date and paf.effective_end_date + 6 and paf.job_id is not null and paf.assignment_type in ('C','E') and ( (paf.assignment_type = 'E' and past.per_system_status in ('ACTIVE_ASSIGN','TERM_ASSIGN')) or (paf.assignment_type = 'E' and past.per_system_status = 'ACTIVE_CWK') ) ) order by value select distinct pbg.name from per_people_x ppx, per_business_groups pbg where pbg.business_group_id = ppx.business_group_id and ppx.person_id in ( select pe.person_id id from pa_employees pe, per_assignments_f paf, hr_all_organization_units_vl haouv, per_assignment_status_types past where pe.person_id = paf.person_id and paf.organization_id = haouv.organization_id and paf.assignment_status_type_id = past.assignment_status_type_id and (:$column$.organization_name is null or haouv.name = :$column$.organization_name) and (:$column$.employee_name is null or pe.full_name = :$column$.employee_name) and pe.employee_number = :$column$.employee_number and paf.primary_flag = 'Y' and :$column$.expnd_ending_date between paf.effective_start_date and paf.effective_end_date + 6 and paf.job_id is not null and paf.assignment_type in ('C','E') and ( (paf.assignment_type = 'E' and past.per_system_status in ('ACTIVE_ASSIGN','TERM_ASSIGN')) or (paf.assignment_type = 'E' and past.per_system_status = 'ACTIVE_CWK') ) ) 17 PERSON_TYPE LOV custom varchar2 Y select distinct xxen_util.meaning(decode(paf.assignment_type,'C','CWK','EMP'),'PA_PERSON_TYPE',275) value, null description from pa_employees pe, per_assignments_f paf, hr_all_organization_units_vl haouv, per_assignment_status_types past where pe.person_id = paf.person_id and paf.organization_id = haouv.organization_id and paf.assignment_status_type_id = past.assignment_status_type_id and (:$column$.organization_name is null or haouv.name = :$column$.organization_name) and (:$column$.employee_name is null or pe.full_name = :$column$.employee_name) and pe.employee_number = :$column$.employee_number and paf.primary_flag = 'Y' and :$column$.expnd_ending_date between paf.effective_start_date and paf.effective_end_date + 6 and paf.job_id is not null and paf.assignment_type in ('C','E') and ( (paf.assignment_type = 'E' and past.per_system_status in ('ACTIVE_ASSIGN','TERM_ASSIGN')) or (paf.assignment_type = 'E' and past.per_system_status = 'ACTIVE_CWK') ) order by value select pl.lookup_code id, pl.meaning value from pa_lookups pl where pl.lookup_type='PA_PERSON_TYPE' and pl.lookup_code in ('CWK','EMP') select distinct xxen_util.meaning(decode(paf.assignment_type,'C','CWK','EMP'),'PA_PERSON_TYPE',275) from pa_employees pe, per_assignments_f paf, hr_all_organization_units_vl haouv, per_assignment_status_types past where pe.person_id = paf.person_id and paf.organization_id = haouv.organization_id and paf.assignment_status_type_id = past.assignment_status_type_id and (:$column$.organization_name is null or haouv.name = :$column$.organization_name) and (:$column$.employee_name is null or pe.full_name = :$column$.employee_name) and pe.employee_number = :$column$.employee_number and paf.primary_flag = 'Y' and :$column$.expnd_ending_date between paf.effective_start_date and paf.effective_end_date + 6 and paf.job_id is not null and paf.assignment_type in ('C','E') and ( (paf.assignment_type = 'E' and past.per_system_status in ('ACTIVE_ASSIGN','TERM_ASSIGN')) or (paf.assignment_type = 'E' and past.per_system_status = 'ACTIVE_CWK') ) 18 OVERRIDE_TO_ORGANIZATION LOV custom varchar2 Y select distinct haouv.organization_id id, haouv.name value, null description from hr_all_organization_units_vl haouv, pa_implementations pi where ( (pa_utils.iscrossbgprofile_wnps = 'N' and haouv.business_group_id = pi.business_group_id and haouv.business_group_id = nvl(:$column$.business_group,haouv.business_group_id) ) or (pa_utils.iscrossbgprofile_wnps = 'Y' and haouv.business_group_id = nvl(:$column$.business_group,haouv.business_group_id) ) ) order by value 19 EXPND_ITEM_DATE Date date Y 20 PROJECT_NUMBER LOV custom varchar2 Y select ppev.project_id id, ppev.project_number value, ppev.project_name || nvl2(ppev.project_description,' (' || ppev.project_description || ')',null) description from hr_all_organization_units_vl haouv, pa_projects_expend_v ppev where haouv.organization_id = ppev.expenditure_ou and haouv.name = :$column$.operating_unit and :$column$.expnd_item_date between nvl(ppev.start_date,:$column$.expnd_item_date) and nvl(ppev.completion_date,:$column$.expnd_item_date) order by value, description Y 21 PROJECT_NAME LOV custom varchar2 Y select ppev.project_id id, ppev.project_name value, ppev.project_number || nvl2(ppev.project_description,' (' || ppev.project_description || ')',null) description from hr_all_organization_units_vl haouv, pa_projects_expend_v ppev where haouv.organization_id = ppev.expenditure_ou and haouv.name = :$column$.operating_unit and :$column$.expnd_item_date between nvl(ppev.start_date,:$column$.expnd_item_date) and nvl(ppev.completion_date,:$column$.expnd_item_date) and ppev.project_number = :$column$.project_number order by value, description 22 TASK_NUMBER LOV custom varchar2 Y select ptev.task_id id, ptev.task_number value, ptev.task_name description from hr_all_organization_units_vl haouv, pa_projects_expend_v ppev, pa_tasks_expend_v ptev where haouv.organization_id = ppev.expenditure_ou and ppev.project_id = ptev.project_id and ppev.project_ou = ptev.org_id and haouv.name = :$column$.operating_unit and ppev.project_number = :$column$.project_number and :$column$.expnd_item_date between nvl(ptev.start_date,:$column$.expnd_item_date) and nvl(ptev.completion_date,:$column$.expnd_item_date) order by value, description Y 23 TASK_NAME LOV custom varchar2 Y select ptev.task_id id, ptev.task_name value, ptev.task_number description from hr_all_organization_units_vl haouv, pa_projects_expend_v ppev, pa_tasks_expend_v ptev where haouv.organization_id = ppev.expenditure_ou and ppev.project_id = ptev.project_id and ppev.project_ou = ptev.org_id and haouv.name = :$column$.operating_unit and ppev.project_number = :$column$.project_number and ptev.task_number = :$column$.task_number and :$column$.expnd_item_date between nvl(ptev.start_date,:$column$.expnd_item_date) and nvl(ptev.completion_date,:$column$.expnd_item_date) order by value, description 24 EXPND_TYPE LOV custom varchar2 Y select petsl.expenditure_type value, pet.description || ' (' || pet.expenditure_category || ') (' || pet.unit_of_measure || ')' description from pa_system_linkages psl, pa_expend_typ_sys_links petsl, pa_expenditure_types pet where petsl.system_linkage_function = psl.function and petsl.expenditure_type = pet.expenditure_type and :$column$.expnd_item_date between trunc(greatest(petsl.start_date_active,pet.start_date_active)) and nvl(trunc(least(petsl.end_date_active,pet.end_date_active)),:$column$.expnd_item_date) and psl.function = xxen_pa_upload.get_system_linkage_code(:$column$.expnd_type_class) order by value Y 25 NON_LABOR_RESOURCE LOV custom varchar2 Y select pnlr.non_labor_resource id, pnlr.non_labor_resource value, pnlr.description description from pa_non_labor_resources pnlr where pnlr.expenditure_type = :$column$.expnd_type and sysdate between nvl(pnlr.start_date_active,sysdate) and nvl(pnlr.end_date_active,sysdate) order by value 26 NON_LABOR_ORG LOV custom varchar2 Y select haouv.organization_id id, haouv.name value, null description from pa_non_labor_resource_orgs pvlro, hr_all_organization_units_vl haouv where pvlro.organization_id = haouv.organization_id and pvlro.non_labor_resource = :$column$.non_labor_resource and sysdate between nvl(pvlro.start_date_active,sysdate) and nvl(pvlro.end_date_active,sysdate) order by value select haouv.name from pa_non_labor_resource_orgs pvlro, hr_all_organization_units_vl haouv where pvlro.organization_id = haouv.organization_id and pvlro.non_labor_resource = :$column$.non_labor_resource and sysdate between nvl(pvlro.start_date_active,sysdate) and nvl(pvlro.end_date_active,sysdate) 27 ASSIGNMENT_NAME LOV custom varchar2 Y select ppaav.assignment_id id, ppaav.assignment_name value, null description from pa_employees pe, pa_projects_expend_v ppev, per_business_groups pbg, hr_all_organization_units_vl haouv, pa_proj_assignments_actuals_v ppaav where pe.business_group_id = pbg.business_group_id and ppev.expenditure_ou = haouv.organization_id and pe.person_id = ppaav.person_id and ppev.project_id = ppaav.project_id and pe.employee_number = :$column$.employee_number and (:$column$.business_group is null or pbg.name = :$column$.business_group) and (:$column$.employee_name is null or pe.full_name = :$column$.employee_name) and ppev.project_number = :$column$.project_number and haouv.name = :$column$.operating_unit and :$column$.expnd_item_date between ppaav.start_date and ppaav.end_date and xxen_pa_upload.get_system_linkage_code(:$column$.expnd_type_class) in ('OT','ST','ER') order by value 28 WORK_TYPE_NAME LOV custom varchar2 Y select pwtv.work_type_id id, pwtv.name value, pwtv.tp_amt_type_code description from pa_projects_expend_v ppev, hr_all_organization_units_vl haouv, pa_work_types_vl pwtv where ppev.expenditure_ou = haouv.organization_id and ppev.project_number = :$column$.project_number and haouv.name = :$column$.operating_unit and pwtv.billable_capitalizable_flag = decode(ppev.project_type_class_code, 'INDIRECT', 'N', pwtv.billable_capitalizable_flag) and :$column$.expnd_item_date between pwtv.start_date_active and nvl(pwtv.end_date_active, :$column$.expnd_item_date) order by value 29 QUANTITY Number number Y 30 TRANS_CURR LOV varchar2 FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code 31 TRANS_RAW_COST Number number 32 TRANS_BURDENED_COST Number number 33 ACCTD_RAW_COST Number number 34 ACCTD_BURDENED_COST Number number 35 RAW_COST_RATE Number number 36 BURDENED_COST_RATE Number number 37 ACCTD_EXCHANGE_RATE_TYPE LOV varchar2 GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 select pctv.conversion_type id, pctv.user_conversion_type value from pa_conversion_types_v pctv 38 ACCTD_EXCHANGE_RATE_DATE Date date 39 ACCTD_EXCHANGE_RATE Number number 40 ACCTD_EXCHANGE_ROUNDING_LIMIT Number number 41 RECEIPT_CURRENCY_CODE LOV varchar2 FND Currency 8E2FF36EDE9079D2E0530100007F1FF2 Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' order by fcv.currency_code 42 RECEIPT_CURRENCY_AMOUNT Number number 43 RECEIPT_EXCHANGE_RATE Number number 44 PROJECT_RATE_TYPE LOV varchar2 GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 select pctv.conversion_type id, pctv.user_conversion_type value from pa_conversion_types_v pctv 45 PROJECT_RATE_DATE Date date 46 PROJECT_EXCHANGE_RATE Number number 47 PROJECT_FUNC_RATE_TYPE LOV varchar2 GL Currency Conversion Type 91D3167A335F1204E053BB6B63585EE3 Y select gdct.user_conversion_type value, gdct.description from gl_daily_conversion_types gdct order by 1 select pctv.conversion_type id, pctv.user_conversion_type value from pa_conversion_types_v pctv 48 PROJECT_FUNC_RATE_DATE Date date 49 PROJECT_FUNC_EXCHANGE_RATE Number number 50 REVERSED_ORIG_TRANS_REF LOV custom varchar2 Y select peia.orig_transaction_reference value, 'Qty: ' || to_char(peia.quantity) || ' Curr: ' || peia.denom_currency_code || ' Raw Cost: ' || to_char(peia.denom_raw_cost) || ' Acctd Raw Cost: ' || to_char(peia.acct_raw_cost) description from hr_all_organization_units_vl haouv, pa_projects_expend_v ppev, pa_tasks_expend_v ptev, pa_expenditure_items peia, pa_expenditures_all pea where haouv.organization_id = ppev.expenditure_ou and ppev.project_id = ptev.project_id and ppev.project_ou = ptev.org_id and haouv.name = :$column$.operating_unit and ppev.project_number = :$column$.project_number and ptev.task_number = :$column$.task_number and peia.org_id = haouv.organization_id and peia.task_id = ptev.task_id and peia.expenditure_id = pea.expenditure_id and peia.expenditure_item_date = :$column$.expnd_item_date and peia.expenditure_type = :$column$.expnd_type and nvl(peia.non_labor_resource,'dummy') = nvl(:$column$.non_labor_resource,'dummy') and peia.transaction_source || '' = (select pts.transaction_source from pa_transaction_sources pts where pts.user_transaction_source = :$column$.transaction_source) and nvl(peia.net_zero_adjustment_flag, 'N') = 'N' and (pea.incurred_by_person_id is null or pea.incurred_by_person_id in (select pe.person_id from pa_employees pe, per_business_groups pbg where pe.business_group_id = pbg.business_group_id and pe.employee_number = :$column$.employee_number and (:$column$.employee_name is null or pe.full_name = :$column$.employee_name) and (:$column$.business_group is null or pbg.name = :$column$.business_group) ) ) and (pea.incurred_by_organization_id is null or pea.incurred_by_organization_id = (select haouv2.organization_id from hr_all_organization_units_vl haouv2 where haouv2.name = :$column$.organization_name ) ) order by value 51 NEGATIVE_TXN_FLAG LOV custom varchar2 Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and lookup_code = 'Y' and :$column$.quantity < 0 order by value,description select fl.lookup_code id, fl.meaning value from fnd_lookups fl where fl.lookup_type = 'YES_NO' select xxen_util.meaning(:$flex$.All_Negative_Expend_Unmatched,'YES_NO',0) from dual where :$column$.quantity < 0 52 ACCRUAL_FLAG LOV custom varchar2 Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and lookup_code = nvl(:$flex$.Reverse_in_Future_Period,'N') order by value,description select fl.lookup_code id, fl.meaning value from fnd_lookups fl where fl.lookup_type = 'YES_NO' xxen_util.meaning(:$flex$.Reverse_in_Future_Period,'YES_NO',0) 53 BILLABLE_FLAG LOV custom varchar2 Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type='YES_NO' and lookup_code = 'Y' order by value,description select fl.lookup_code id, fl.meaning value from fnd_lookups fl where fl.lookup_type = 'YES_NO' 54 GL_DATE Date date 55 DEBIT_ACCT LOV custom varchar2 Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from hr_operating_units hou, gl_ledgers gl, gl_code_combinations_kfv gcck where hou.name = :$column$.operating_unit and to_number(hou.set_of_books_id) = gl.ledger_id and gl.chart_of_accounts_id = gcck.chart_of_accounts_id and gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' order by gcck.concatenated_segments select gcck.code_combination_id id, gcck.concatenated_segments value from hr_operating_units hou, gl_ledgers gl, gl_code_combinations_kfv gcck where hou.name = :$column$.operating_unit and to_number(hou.set_of_books_id) = gl.ledger_id and gl.chart_of_accounts_id = gcck.chart_of_accounts_id and gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' 56 CREDIT_ACCT LOV custom varchar2 Y select gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from hr_operating_units hou, gl_ledgers gl, gl_code_combinations_kfv gcck where hou.name = :$column$.operating_unit and to_number(hou.set_of_books_id) = gl.ledger_id and gl.chart_of_accounts_id = gcck.chart_of_accounts_id and gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' order by gcck.concatenated_segments select gcck.code_combination_id id, gcck.concatenated_segments value from hr_operating_units hou, gl_ledgers gl, gl_code_combinations_kfv gcck where hou.name = :$column$.operating_unit and to_number(hou.set_of_books_id) = gl.ledger_id and gl.chart_of_accounts_id = gcck.chart_of_accounts_id and gcck.detail_posting_allowed = 'Y' and gcck.enabled_flag = 'Y' and gcck.summary_flag = 'N' 57 VENDOR_NUMBER LOV custom varchar2 Y select aps.segment1 value, aps.vendor_name description from ap_suppliers aps order by value, description select distinct aps.segment1 from ap_suppliers aps where aps.vendor_id in ( select pe.vendor_id from pa_employees pe, per_assignments_f paf, hr_all_organization_units_vl haouv, per_assignment_status_types past where pe.person_id = paf.person_id and paf.organization_id = haouv.organization_id and paf.assignment_status_type_id = past.assignment_status_type_id and (:$column$.organization_name is null or haouv.name = :$column$.organization_name) and (:$column$.employee_name is null or pe.full_name = :$column$.employee_name) and pe.employee_number = :$column$.employee_number and paf.primary_flag = 'Y' and :$column$.expnd_ending_date between paf.effective_start_date and paf.effective_end_date + 6 and paf.job_id is not null and paf.assignment_type in ('C','E') and ( (paf.assignment_type = 'E' and past.per_system_status in ('ACTIVE_ASSIGN','TERM_ASSIGN')) or (paf.assignment_type = 'E' and past.per_system_status = 'ACTIVE_CWK') ) ) 58 PO_NUMBER LOV custom varchar2 Y select pha.po_header_id id, pha.segment1 value, pha.comments description from hr_all_organization_units_vl haouv, po_headers pha where haouv.organization_id = pha.org_id and haouv.name = :$column$.operating_unit and exists (select null from po_lines_all pla, po_distributions_all pda, po_line_types_b pltb where pla.po_header_id = pha.po_header_id and pla.po_header_id = pda.po_header_id and pla.po_line_id = pda.po_line_id and pla.line_type_id = pltb.line_type_id and nvl(pla.cancel_flag,'N') <> 'Y' and pda.project_id > 0 and pltb.purchase_basis = 'TEMP LABOR' ) order by value 59 PO_LINE_NUMBER LOV custom number Y select pla.po_line_id id, pla.line_num value, pha.segment1 description from hr_all_organization_units_vl haouv, po_headers pha, po_lines_all pla, po_line_types_b pltb where haouv.organization_id = pha.org_id and pla.po_header_id = pha.po_header_id and pla.line_type_id = pltb.line_type_id and haouv.name = :$column$.operating_unit and pha.segment1 = :$column$.po_number and nvl(pla.cancel_flag,'N') <> 'Y' and pltb.purchase_basis = 'TEMP LABOR' and exists (select null from po_distributions_all pda where pla.po_header_id = pda.po_header_id and pla.po_line_id = pda.po_line_id and pda.project_id > 0 ) order by value select pla.line_num from hr_all_organization_units_vl haouv, po_headers pha, po_lines_all pla, po_line_types_b pltb where haouv.organization_id = pha.org_id and pla.po_header_id = pha.po_header_id and pla.line_type_id = pltb.line_type_id and haouv.name = :$column$.operating_unit and pha.segment1 = :$column$.po_number and nvl(pla.cancel_flag,'N') <> 'Y' and pltb.purchase_basis = 'TEMP LABOR' and exists (select null from po_distributions_all pda where pla.po_header_id = pda.po_header_id and pla.po_line_id = pda.po_line_id and pda.project_id > 0 ) 60 PO_PRICE_TYPE LOV custom varchar2 Y select fl.lookup_code id, fl.lookup_code value, fl.meaning description from hr_all_organization_units_vl haouv, po_headers pha, po_lines_all pla, fnd_lookups fl where haouv.organization_id = pha.org_id and pla.po_header_id = pha.po_header_id and fl.lookup_type = 'PRICE DIFFERENTIALS' and fl.lookup_code = pla.price_type_lookup_code and haouv.name = :$column$.operating_unit and pha.segment1 = :$column$.po_number and pla.line_num = :$column$.po_line_number order by value select fl.lookup_code from hr_all_organization_units_vl haouv, po_headers pha, po_lines_all pla, fnd_lookups fl where haouv.organization_id = pha.org_id and pla.po_header_id = pha.po_header_id and fl.lookup_type = 'PRICE DIFFERENTIALS' and fl.lookup_code = pla.price_type_lookup_code and haouv.name = :$column$.operating_unit and pha.segment1 = :$column$.po_number and pla.line_num = :$column$.po_line_number 61 EXPENDITURE_COMMENT Char varchar2 62 ORIG_USER_EXPND_TRANS_REF Char varchar2 63 ORIG_EXPND_TRANS_REF1 Char varchar2 64 ORIG_EXPND_TRANS_REF2 Char varchar2 65 ORIG_EXPND_TRANS_REF3 Char varchar2 66 CDL_SYSTEM_REF1 Char varchar2 67 CDL_SYSTEM_REF2 Char varchar2 68 CDL_SYSTEM_REF3 Char varchar2 69 CDL_SYSTEM_REF4 Char varchar2 70 CDL_SYSTEM_REF5 Number number 71 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_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcv.descriptive_flex_context_code != 'Global Data Elements' order by fdfcv.descriptive_flex_context_name 72 PA_EXPND_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_EXPENDITURE_ITEMS_DESC_FLEX', p_context_name => :$column$.party_dff_context, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.pa_expnd_attribute1, p_attribute2 => :$column$.pa_expnd_attribute2, p_attribute3 => :$column$.pa_expnd_attribute3, p_attribute4 => :$column$.pa_expnd_attribute4, p_attribute5 => :$column$.pa_expnd_attribute5, p_attribute6 => :$column$.pa_expnd_attribute6, p_attribute7 => :$column$.pa_expnd_attribute7, p_attribute8 => :$column$.pa_expnd_attribute8, p_attribute9 => :$column$.pa_expnd_attribute9, p_attribute10 => :$column$.pa_expnd_attribute10 ) ) lov order by value 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 275 and fdfv.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcuv.application_column_name = 'ATTRIBUTE1' 73 PA_EXPND_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_EXPENDITURE_ITEMS_DESC_FLEX', p_context_name => :$column$.party_dff_context, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.pa_expnd_attribute1, p_attribute2 => :$column$.pa_expnd_attribute2, p_attribute3 => :$column$.pa_expnd_attribute3, p_attribute4 => :$column$.pa_expnd_attribute4, p_attribute5 => :$column$.pa_expnd_attribute5, p_attribute6 => :$column$.pa_expnd_attribute6, p_attribute7 => :$column$.pa_expnd_attribute7, p_attribute8 => :$column$.pa_expnd_attribute8, p_attribute9 => :$column$.pa_expnd_attribute9, p_attribute10 => :$column$.pa_expnd_attribute10 ) ) lov order by value 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 275 and fdfv.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcuv.application_column_name = 'ATTRIBUTE2' 74 PA_EXPND_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_EXPENDITURE_ITEMS_DESC_FLEX', p_context_name => :$column$.party_dff_context, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.pa_expnd_attribute1, p_attribute2 => :$column$.pa_expnd_attribute2, p_attribute3 => :$column$.pa_expnd_attribute3, p_attribute4 => :$column$.pa_expnd_attribute4, p_attribute5 => :$column$.pa_expnd_attribute5, p_attribute6 => :$column$.pa_expnd_attribute6, p_attribute7 => :$column$.pa_expnd_attribute7, p_attribute8 => :$column$.pa_expnd_attribute8, p_attribute9 => :$column$.pa_expnd_attribute9, p_attribute10 => :$column$.pa_expnd_attribute10 ) ) lov order by value 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 275 and fdfv.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcuv.application_column_name = 'ATTRIBUTE3' 75 PA_EXPND_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_EXPENDITURE_ITEMS_DESC_FLEX', p_context_name => :$column$.party_dff_context, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.pa_expnd_attribute1, p_attribute2 => :$column$.pa_expnd_attribute2, p_attribute3 => :$column$.pa_expnd_attribute3, p_attribute4 => :$column$.pa_expnd_attribute4, p_attribute5 => :$column$.pa_expnd_attribute5, p_attribute6 => :$column$.pa_expnd_attribute6, p_attribute7 => :$column$.pa_expnd_attribute7, p_attribute8 => :$column$.pa_expnd_attribute8, p_attribute9 => :$column$.pa_expnd_attribute9, p_attribute10 => :$column$.pa_expnd_attribute10 ) ) lov order by value 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 275 and fdfv.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcuv.application_column_name = 'ATTRIBUTE4' 76 PA_EXPND_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_EXPENDITURE_ITEMS_DESC_FLEX', p_context_name => :$column$.party_dff_context, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.pa_expnd_attribute1, p_attribute2 => :$column$.pa_expnd_attribute2, p_attribute3 => :$column$.pa_expnd_attribute3, p_attribute4 => :$column$.pa_expnd_attribute4, p_attribute5 => :$column$.pa_expnd_attribute5, p_attribute6 => :$column$.pa_expnd_attribute6, p_attribute7 => :$column$.pa_expnd_attribute7, p_attribute8 => :$column$.pa_expnd_attribute8, p_attribute9 => :$column$.pa_expnd_attribute9, p_attribute10 => :$column$.pa_expnd_attribute10 ) ) lov order by value 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 275 and fdfv.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcuv.application_column_name = 'ATTRIBUTE5' 77 PA_EXPND_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_EXPENDITURE_ITEMS_DESC_FLEX', p_context_name => :$column$.party_dff_context, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.pa_expnd_attribute1, p_attribute2 => :$column$.pa_expnd_attribute2, p_attribute3 => :$column$.pa_expnd_attribute3, p_attribute4 => :$column$.pa_expnd_attribute4, p_attribute5 => :$column$.pa_expnd_attribute5, p_attribute6 => :$column$.pa_expnd_attribute6, p_attribute7 => :$column$.pa_expnd_attribute7, p_attribute8 => :$column$.pa_expnd_attribute8, p_attribute9 => :$column$.pa_expnd_attribute9, p_attribute10 => :$column$.pa_expnd_attribute10 ) ) lov order by value 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 275 and fdfv.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcuv.application_column_name = 'ATTRIBUTE6' 78 PA_EXPND_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_EXPENDITURE_ITEMS_DESC_FLEX', p_context_name => :$column$.party_dff_context, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.pa_expnd_attribute1, p_attribute2 => :$column$.pa_expnd_attribute2, p_attribute3 => :$column$.pa_expnd_attribute3, p_attribute4 => :$column$.pa_expnd_attribute4, p_attribute5 => :$column$.pa_expnd_attribute5, p_attribute6 => :$column$.pa_expnd_attribute6, p_attribute7 => :$column$.pa_expnd_attribute7, p_attribute8 => :$column$.pa_expnd_attribute8, p_attribute9 => :$column$.pa_expnd_attribute9, p_attribute10 => :$column$.pa_expnd_attribute10 ) ) lov order by value 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 275 and fdfv.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcuv.application_column_name = 'ATTRIBUTE7' 79 PA_EXPND_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_EXPENDITURE_ITEMS_DESC_FLEX', p_context_name => :$column$.party_dff_context, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.pa_expnd_attribute1, p_attribute2 => :$column$.pa_expnd_attribute2, p_attribute3 => :$column$.pa_expnd_attribute3, p_attribute4 => :$column$.pa_expnd_attribute4, p_attribute5 => :$column$.pa_expnd_attribute5, p_attribute6 => :$column$.pa_expnd_attribute6, p_attribute7 => :$column$.pa_expnd_attribute7, p_attribute8 => :$column$.pa_expnd_attribute8, p_attribute9 => :$column$.pa_expnd_attribute9, p_attribute10 => :$column$.pa_expnd_attribute10 ) ) lov order by value 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 275 and fdfv.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcuv.application_column_name = 'ATTRIBUTE8' 80 PA_EXPND_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_EXPENDITURE_ITEMS_DESC_FLEX', p_context_name => :$column$.party_dff_context, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.pa_expnd_attribute1, p_attribute2 => :$column$.pa_expnd_attribute2, p_attribute3 => :$column$.pa_expnd_attribute3, p_attribute4 => :$column$.pa_expnd_attribute4, p_attribute5 => :$column$.pa_expnd_attribute5, p_attribute6 => :$column$.pa_expnd_attribute6, p_attribute7 => :$column$.pa_expnd_attribute7, p_attribute8 => :$column$.pa_expnd_attribute8, p_attribute9 => :$column$.pa_expnd_attribute9, p_attribute10 => :$column$.pa_expnd_attribute10 ) ) lov order by value 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 275 and fdfv.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcuv.application_column_name = 'ATTRIBUTE9' 81 PA_EXPND_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_EXPENDITURE_ITEMS_DESC_FLEX', p_context_name => :$column$.party_dff_context, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.pa_expnd_attribute1, p_attribute2 => :$column$.pa_expnd_attribute2, p_attribute3 => :$column$.pa_expnd_attribute3, p_attribute4 => :$column$.pa_expnd_attribute4, p_attribute5 => :$column$.pa_expnd_attribute5, p_attribute6 => :$column$.pa_expnd_attribute6, p_attribute7 => :$column$.pa_expnd_attribute7, p_attribute8 => :$column$.pa_expnd_attribute8, p_attribute9 => :$column$.pa_expnd_attribute9, p_attribute10 => :$column$.pa_expnd_attribute10 ) ) lov order by value 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 fdfc.application_id = fdfv.application_id and fdfc.descriptive_flexfield_name = fdfv.descriptive_flexfield_name and fdfc.enabled_flag = 'Y' and fdfcuv.application_id = fdfc.application_id and fdfcuv.descriptive_flexfield_name = fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code = fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag = 'Y' and fdfv.application_id = 275 and fdfv.descriptive_flexfield_name = 'PA_EXPENDITURE_ITEMS_DESC_FLEX' and fdfcuv.application_column_name = 'ATTRIBUTE10' 82 IMPORT_TRANSACTIONS LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description xxen_util.meaning(:$flex$.Import_Transactions,'YES_NO',0) Y U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 request_id_ out Number REQUEST_ID_ U 5 p_row_id in/out Char ROW_ID U 6 p_transaction_source in Char TRANSACTION_SOURCE U 7 p_batch_name in Char BATCH_NAME U 8 p_expenditure_ending_date in Date EXPND_ENDING_DATE U 9 p_employee_name in Char EMPLOYEE_NAME value U 10 p_employee_number in Char EMPLOYEE_NUMBER value U 11 p_organization_name in Char ORGANIZATION_NAME value U 12 p_expenditure_item_date in Date EXPND_ITEM_DATE U 13 p_project_name in Char PROJECT_NAME value U 14 p_project_number in Char PROJECT_NUMBER value U 15 p_task_name in Char TASK_NAME value U 16 p_task_number in Char TASK_NUMBER value U 17 p_expenditure_type in Char EXPND_TYPE U 18 p_non_labor_resource in Char NON_LABOR_RESOURCE U 19 p_non_labor_resource_org_name in Char NON_LABOR_ORG value U 20 p_quantity in Number QUANTITY U 21 p_raw_cost in Number U 22 p_expenditure_comment in Char EXPENDITURE_COMMENT U 23 p_transaction_status_code in Char U 24 p_transaction_rejection_code in Char U 25 p_expenditure_id in Number U 26 p_orig_transaction_reference in Char ORIGINAL_TRANS_REF U 27 p_attribute_category in Char ATTRIBUTE_CATEGORY U 28 p_attribute1 in Char PA_EXPND_ATTRIBUTE1 U 29 p_attribute2 in Char PA_EXPND_ATTRIBUTE2 U 30 p_attribute3 in Char PA_EXPND_ATTRIBUTE3 U 31 p_attribute4 in Char PA_EXPND_ATTRIBUTE4 U 32 p_attribute5 in Char PA_EXPND_ATTRIBUTE5 U 33 p_attribute6 in Char PA_EXPND_ATTRIBUTE6 U 34 p_attribute7 in Char PA_EXPND_ATTRIBUTE7 U 35 p_attribute8 in Char PA_EXPND_ATTRIBUTE8 U 36 p_attribute9 in Char PA_EXPND_ATTRIBUTE9 U 37 p_attribute10 in Char PA_EXPND_ATTRIBUTE10 U 38 p_raw_cost_rate in Number RAW_COST_RATE U 39 p_interface_id in Number U 40 p_unmatched_negative_txn_flag in Char NEGATIVE_TXN_FLAG U 41 p_expenditure_item_id in Number U 42 p_org_id in Number OPERATING_UNIT U 43 p_dr_code_combination_id in Number DEBIT_ACCT U 44 p_cr_code_combination_id in Number CREDIT_ACCT U 45 p_cdl_system_reference1 in Char CDL_SYSTEM_REF1 U 46 p_cdl_system_reference2 in Char CDL_SYSTEM_REF2 U 47 p_cdl_system_reference3 in Char CDL_SYSTEM_REF3 U 48 p_gl_date in Date GL_DATE U 49 p_burdened_cost in Number U 50 p_burdened_cost_rate in Number BURDENED_COST_RATE U 51 p_system_linkage in Char EXPND_TYPE_CLASS U 52 p_txn_interface_id in Number U 53 p_user_transaction_source in Char U 54 p_receipt_currency_amount in Number RECEIPT_CURRENCY_AMOUNT U 55 p_receipt_currency_code in Char RECEIPT_CURRENCY_CODE U 56 p_receipt_exchange_rate in Number RECEIPT_EXCHANGE_RATE U 57 p_denom_currency_code in Char TRANS_CURR U 58 p_denom_raw_cost in Number TRANS_RAW_COST U 59 p_denom_burdened_cost in Number TRANS_BURDENED_COST U 60 p_acct_rate_date in Date ACCTD_EXCHANGE_RATE_DATE U 61 p_acct_rate_type in Char ACCTD_EXCHANGE_RATE_TYPE U 62 p_acct_exchange_rate in Number ACCTD_EXCHANGE_RATE U 63 p_acct_raw_cost in Number ACCTD_RAW_COST U 64 p_acct_burdened_cost in Number ACCTD_BURDENED_COST U 65 p_acct_exchange_rounding_limit in Number ACCTD_EXCHANGE_ROUNDING_LIMIT U 66 p_project_currency_code in Char U 67 p_project_rate_date in Date PROJECT_RATE_DATE U 68 p_project_rate_type in Char PROJECT_RATE_TYPE U 69 p_project_exchange_rate in Number PROJECT_EXCHANGE_RATE U 70 p_orig_exp_txn_reference1 in Char ORIG_EXPND_TRANS_REF1 U 71 p_orig_exp_txn_reference2 in Char ORIG_EXPND_TRANS_REF2 U 72 p_orig_exp_txn_reference3 in Char ORIG_EXPND_TRANS_REF3 U 73 p_orig_user_exp_txn_reference in Char ORIG_USER_EXPND_TRANS_REF U 74 p_vendor_number in Char VENDOR_NUMBER U 75 p_override_to_organization_nam in Char OVERRIDE_TO_ORGANIZATION value U 76 p_reversed_orig_txn_reference in Char REVERSED_ORIG_TRANS_REF U 77 p_billable_flag in Char BILLABLE_FLAG U 78 p_person_business_group_name in Char BUSINESS_GROUP value U 79 p_projfunc_currency_code in Char U 80 p_projfunc_cost_rate_type in Char PROJECT_FUNC_RATE_TYPE value U 81 p_projfunc_cost_rate_date in Date PROJECT_FUNC_RATE_DATE U 82 p_projfunc_cost_exchange_rate in Number PROJECT_FUNC_RATE_TYPE U 83 p_project_raw_cost in Number U 84 p_project_burdened_cost in Number U 85 p_assignment_name in Char ASSIGNMENT_NAME value U 86 p_work_type_name in Char WORK_TYPE_NAME value U 87 p_cdl_system_reference4 in Char CDL_SYSTEM_REF4 U 88 p_accrual_flag in Char ACCRUAL_FLAG U 89 p_project_id in Number U 90 p_task_id in Number U 91 p_person_id in Number U 92 p_organization_id in Number U 93 p_non_labor_resource_org_id in Number U 94 p_vendor_id in Number U 95 p_override_to_organization_id in Number U 96 p_assignment_id in Number U 97 p_work_type_id in Number U 98 p_person_business_group_id in Number U 99 p_inventory_item_id in Number U 100 p_wip_resource_id in Number U 101 p_unit_of_measure in Char U 102 p_po_number in Char PO_NUMBER value U 103 p_po_header_id in Number U 104 p_po_line_num in Number PO_LINE_NUMBER value U 105 p_po_line_id in Number U 106 p_person_type in Char PERSON_TYPE U 107 p_po_price_type in Char PO_PRICE_TYPE U 108 p_adjusted_expenditure_item_id in Number U 109 p_fc_document_type in Char U 110 p_document_type in Char U 111 p_document_distribution_type in Char U 112 p_si_assets_addition_flag in Char U 113 p_cdl_system_reference5 in Number CDL_SYSTEM_REF5 U 114 p_sc_xfer_code in Char U 115 p_adjusted_txn_interface_id in Number U 116 p_net_zero_adjustment_flag in Char U 117 p_legal_entity_id in Number U 118 p_receiver_legal_entity_id in Number U 119 p_legal_entity_name in Char U 120 p_receiver_legal_entity_name in Char P 1 p_submit_import in Char IMPORT_TRANSACTIONS P 2 p_transaction_source in Char TRANSACTION_SOURCE P 3 p_batch_name in Char BATCH_NAME P 4 p_org_id in Number OPERATING_UNIT P 5 request_id_ out Number REQUEST_ID_ P 6 status_ out Char STATUS_CODE_ P 7 message_ out Char MESSAGE_ Error SQL select xu.action_, xxen_upload.status_meaning(xxen_upload.status_error) status_, case when ptia.transaction_status_code = 'P' and nvl(:p_submit_import,'Y') = 'Y' then nvl(xu.message_,'Transaction Import has not been processed') when ptia.transaction_status_code = 'R' then case when ptia.transaction_rejection_code is not null then xxen_util.meaning(ptia.transaction_rejection_code,'TRANSACTION REJECTION REASON',275) else 'One or more related expenditure items is in error' end else xu.message_ end message_, xu.request_id_, xu.modified_columns_, xu.row_id, -- xu.operating_unit, xu.transaction_source, xu.expnd_type_class, xu.expnd_ending_date, xu.batch_name, xu.original_trans_ref, -- xu.organization_name, xu.employee_name, xu.employee_number, xu.business_group, xu.person_type, xu.override_to_organization, -- xu.expnd_item_date, xu.project_number, xu.project_name, xu.task_number, xu.task_name, xu.expnd_type, -- xu.non_labor_resource, --usages xu.non_labor_org, --usages xu.assignment_name, -- timecards xu.work_type_name, -- xu.quantity, -- xu.trans_curr, xu.trans_raw_cost, xu.trans_burdened_cost, xu.acctd_raw_cost, xu.acctd_burdened_cost, xu.raw_cost_rate, xu.burdened_cost_rate, -- xu.acctd_exchange_rate_type, xu.acctd_exchange_rate_date, xu.acctd_exchange_rate, xu.acctd_exchange_rounding_limit, -- xu.receipt_currency_code, xu.receipt_currency_amount, xu.receipt_exchange_rate, xu.project_rate_type, xu.project_rate_date, xu.project_exchange_rate, xu.project_func_rate_type, xu.project_func_rate_date, xu.project_func_exchange_rate, -- xu.reversed_orig_trans_ref, xu.negative_txn_flag, xu.accrual_flag, xu.billable_flag, -- xu.gl_date, xu.debit_acct, xu.credit_acct, -- xu.vendor_number, xu.po_number, xu.po_line_number, xu.po_price_type, -- xu.expenditure_comment, -- xu.orig_user_expnd_trans_ref, xu.orig_expnd_trans_ref1, xu.orig_expnd_trans_ref2, xu.orig_expnd_trans_ref3, xu.cdl_system_ref1, xu.cdl_system_ref2, xu.cdl_system_ref3, xu.cdl_system_ref4, xu.cdl_system_ref5, -- xu.attribute_category, xu.pa_expnd_attribute1, xu.pa_expnd_attribute2, xu.pa_expnd_attribute3, xu.pa_expnd_attribute4, xu.pa_expnd_attribute5, xu.pa_expnd_attribute6, xu.pa_expnd_attribute7, xu.pa_expnd_attribute8, xu.pa_expnd_attribute9, xu.pa_expnd_attribute10, -- xu.import_transactions from xxen_pa_project_transac_4491_u xu, pa_transaction_interface_all ptia where chartorowid(xu.row_id) = ptia.rowid (+) and (nvl(xu.status_code_,xxen_upload.status_error) != xxen_upload.status_success or nvl(ptia.transaction_status_code,'X') != decode(nvl(:p_submit_import,'Y'),'Y','A','P') ) Order By operating_unit, transaction_source, expnd_ending_date, batch_name, organization_name, employee_name, employee_number, expnd_item_date, original_trans_ref Success SQL select xu.action_, xu.status_, nvl(xu.message_,'Transaction Imported') message_, xu.request_id_, xu.modified_columns_, xu.row_id, -- ou.name operating_unit, (select pts.user_transaction_source from pa_transaction_sources pts where pts.transaction_source = peia.transaction_source) transaction_source, xxen_pa_upload.get_system_linkage_meaning(peia.system_linkage_function) expnd_type_class, pea.expenditure_ending_date expnd_ending_date, ptxca.batch_name batch_name, peia.orig_transaction_reference original_trans_ref, -- incur_org.name organization_name, pe.full_name employee_name, pe.employee_number employee_number, pbg.name business_group, xxen_util.meaning(pe.person_type,'PA_PERSON_TYPE',275) person_type, ovrd_org.name override_to_organization, -- peia.expenditure_item_date expnd_item_date, ppa.segment1 project_number, ppa.name project_name, pt.task_number task_number, pt.task_name task_name, peia.expenditure_type expnd_type, -- peia.non_labor_resource non_labor_resource, non_lab_org.name non_labor_org, case when peia.assignment_id = 0 then xxen_util.meaning('UNSCHEDULED','PA_EXP_ASSGN_ENTRY',275) else ppas.assignment_name end assignment_name, pwtv.name work_type_name, -- nvl(pcdla.quantity,peia.quantity) quantity, -- nvl(pcdla.denom_currency_code,peia.denom_currency_code) trans_curr, nvl(pcdla.denom_raw_cost,peia.denom_raw_cost) trans_raw_cost, nvl(pcdla.denom_burdened_cost,peia.denom_burdened_cost) trans_burdened_cost, nvl(pcdla.acct_raw_cost,peia.acct_raw_cost) acctd_raw_cost, nvl(pcdla.acct_burdened_cost,peia.acct_burdened_cost) acctd_burdened_cost, peia.raw_cost_rate, peia.burden_cost_rate burdened_cost_rate, -- nvl(pcdla.acct_rate_type,peia.acct_rate_type) acctd_exchange_rate_type, nvl(pcdla.acct_rate_date,peia.acct_rate_date) acctd_exchange_rate_date, nvl(pcdla.acct_exchange_rate,peia.acct_exchange_rate) acctd_exchange_rate, peia.acct_exchange_rounding_limit acctd_exchange_rounding_limit, -- peia.receipt_currency_code, peia.receipt_currency_amount, peia.receipt_exchange_rate, peia.project_rate_type, peia.project_rate_date, peia.project_exchange_rate, peia.projfunc_cost_rate_type project_func_rate_type, peia.projfunc_cost_rate_date project_func_rate_date, peia.projfunc_cost_exchange_rate project_func_exchange_rate, -- (select peia2.orig_transaction_reference from pa_expenditure_items_all peia2 where peia2.expenditure_item_id = peia.adjusted_expenditure_item_id) reversed_orig_trans_ref, xu.negative_txn_flag, xxen_util.meaning(pega.period_accrual_flag,'YES_NO',0) accrual_flag, xxen_util.meaning(peia.billable_flag,'YES_NO',0) billable_flag, -- pcdla.gl_date gl_date, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = pcdla.dr_code_combination_id) debit_acct, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = pcdla.cr_code_combination_id) credit_acct, -- asu.segment1 vendor_number, pha.segment1 po_number, pla.line_num po_line_number, peia.po_price_type po_price_type, -- (select pec.expenditure_comment from pa_expenditure_comments pec where pec.expenditure_item_id = peia.expenditure_item_id and rownum <= 1) expenditure_comment, -- pea.orig_user_exp_txn_reference orig_user_expnd_trans_ref, pea.orig_exp_txn_reference1 orig_expnd_trans_ref1, pea.orig_exp_txn_reference2 orig_expnd_trans_ref2, pea.orig_exp_txn_reference3 orig_expnd_trans_ref3, pcdla.system_reference1 cdl_system_ref1, pcdla.system_reference2 cdl_system_ref2, pcdla.system_reference3 cdl_system_ref3, pcdla.system_reference4 cdl_system_ref4, pcdla.system_reference5 cdl_system_ref5, -- xxen_util.display_flexfield_context(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category) attribute_category, xxen_util.display_flexfield_value(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category,'ATTRIBUTE1',peia.rowid,peia.attribute1) pa_expnd_attribute1, xxen_util.display_flexfield_value(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category,'ATTRIBUTE2',peia.rowid,peia.attribute2) pa_expnd_attribute2, xxen_util.display_flexfield_value(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category,'ATTRIBUTE3',peia.rowid,peia.attribute3) pa_expnd_attribute3, xxen_util.display_flexfield_value(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category,'ATTRIBUTE4',peia.rowid,peia.attribute4) pa_expnd_attribute4, xxen_util.display_flexfield_value(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category,'ATTRIBUTE5',peia.rowid,peia.attribute5) pa_expnd_attribute5, xxen_util.display_flexfield_value(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category,'ATTRIBUTE6',peia.rowid,peia.attribute6) pa_expnd_attribute6, xxen_util.display_flexfield_value(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category,'ATTRIBUTE7',peia.rowid,peia.attribute7) pa_expnd_attribute7, xxen_util.display_flexfield_value(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category,'ATTRIBUTE8',peia.rowid,peia.attribute8) pa_expnd_attribute8, xxen_util.display_flexfield_value(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category,'ATTRIBUTE9',peia.rowid,peia.attribute9) pa_expnd_attribute9, xxen_util.display_flexfield_value(275,'PA_EXPENDITURE_ITEMS_DESC_FLEX',peia.attribute_category,'ATTRIBUTE10',peia.rowid,peia.attribute10) pa_expnd_attribute10, -- xu.import_transactions from xxen_pa_project_transac_4491_u xu, pa_transaction_interface_all ptia, pa_transaction_xface_ctrl_all ptxca, pa_expenditures_all pea, pa_expenditure_items_all peia, pa_cost_distribution_lines_all pcdla, pa_expenditure_groups_all pega, pa_projects_all ppa, pa_tasks pt, hr_all_organization_units_vl ou, hr_all_organization_units_vl incur_org, hr_all_organization_units_vl non_lab_org, hr_all_organization_units_vl ovrd_org, pa_employees pe, per_business_groups pbg, pa_project_assignments ppas, pa_work_types_vl pwtv, ap_suppliers asu, po_lines_all pla, po_headers_all pha where chartorowid(xu.row_id) = ptia.rowid and ptia.interface_id = ptxca.interface_id and ptia.expenditure_id = pea.expenditure_id and pea.expenditure_group = pega.expenditure_group and pea.org_id = ou.organization_id and pea.incurred_by_person_id = pe.person_id (+) and pe.business_group_id = pbg.business_group_id (+) and pea.incurred_by_organization_id = incur_org.organization_id (+) and pea.vendor_id = asu.vendor_id (+) and peia.project_id = ppa.project_id and ptia.expenditure_item_id = peia.expenditure_item_id and peia.expenditure_item_id = pcdla.expenditure_item_id (+) and peia.task_id = pt.task_id and peia.organization_id = non_lab_org.organization_id (+) and peia.override_to_organization_id = ovrd_org.organization_id (+) and peia.assignment_id = ppas.assignment_id (+) and peia.work_type_id = pwtv.work_type_id (+) and peia.po_line_id = pla.po_line_id (+) and pla.po_header_id = pha.po_header_id (+) and xu.status_code_ = xxen_upload.status_success and ptia.transaction_status_code = 'A' and nvl(:p_submit_import,'Y') = 'Y' union all select xu.action_, xu.status_, nvl(xu.message_,'Transaction Interfaced. Please review and import the transactions from Oracle') message_, xu.request_id_, xu.modified_columns_, xu.row_id, -- haouv.name operating_unit, (select pts.user_transaction_source from pa_transaction_sources pts where pts.transaction_source = ptia.transaction_source) transaction_source, xxen_pa_upload.get_system_linkage_meaning(ptia.system_linkage) expnd_type_class, ptia.expenditure_ending_date expnd_ending_date, ptia.batch_name batch_name, ptia.orig_transaction_reference original_trans_ref, -- ptia.organization_name organization_name, xu.employee_name, ptia.employee_number employee_number, ptia.person_business_group_name business_group, xxen_util.meaning(ptia.person_type,'PA_PERSON_TYPE',275) person_type, ptia.override_to_organization_name override_to_organization, -- ptia.expenditure_item_date expnd_item_date, ptia.project_number project_number, xu.project_name, ptia.task_number task_number, xu.task_name, ptia.expenditure_type expnd_type, -- ptia.non_labor_resource non_labor_resource, --usages ptia.non_labor_resource_org_name non_labor_org, --usages ptia.assignment_name assignment_name, -- timecards ptia.work_type_name work_type_name, -- ptia.quantity quantity, -- ptia.denom_currency_code trans_curr, ptia.denom_raw_cost trans_raw_cost, ptia.denom_burdened_cost trans_burdened_cost, ptia.acct_raw_cost acctd_raw_cost, ptia.acct_burdened_cost acctd_burdened_cost, ptia.raw_cost_rate, ptia.burdened_cost_rate, -- (select pctv.user_conversion_type from pa_conversion_types_v pctv where pctv.conversion_type = ptia.acct_rate_type) acctd_exchange_rate_type, ptia.acct_rate_date acctd_exchange_rate_date, ptia.acct_exchange_rate acctd_exchange_rate, ptia.acct_exchange_rounding_limit acctd_exchange_rounding_limit, -- ptia.receipt_currency_code, ptia.receipt_currency_amount, ptia.receipt_exchange_rate, (select pctv.user_conversion_type from pa_conversion_types_v pctv where pctv.conversion_type = ptia.project_rate_type) project_rate_type, ptia.project_rate_date, ptia.project_exchange_rate, (select pctv.user_conversion_type from pa_conversion_types_v pctv where pctv.conversion_type = ptia.projfunc_cost_rate_type) project_func_rate_type, ptia.projfunc_cost_rate_date project_func_rate_date, ptia.projfunc_cost_exchange_rate project_func_exchange_rate, -- ptia.reversed_orig_txn_reference reversed_orig_trans_ref, xxen_util.meaning(ptia.unmatched_negative_txn_flag,'YES_NO',0) negative_txn_flag, xxen_util.meaning(ptia.accrual_flag,'YES_NO',0) accrual_flag, xxen_util.meaning(ptia.billable_flag,'YES_NO',0) billable_flag, -- ptia.gl_date gl_date, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = ptia.dr_code_combination_id) debit_acct, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where gcck.code_combination_id = ptia.cr_code_combination_id) credit_acct, -- ptia.vendor_number vendor_number, ptia.po_number po_number, ptia.po_line_num po_line_number, ptia.po_price_type po_price_type, -- ptia.expenditure_comment, -- ptia.orig_user_exp_txn_reference orig_user_expnd_trans_ref, ptia.orig_exp_txn_reference1 orig_expnd_trans_ref1, ptia.orig_exp_txn_reference2 orig_expnd_trans_ref2, ptia.orig_exp_txn_reference3 orig_expnd_trans_ref3, ptia.cdl_system_reference1 cdl_system_ref1, ptia.cdl_system_reference2 cdl_system_ref2, ptia.cdl_system_reference3 cdl_system_ref3, ptia.cdl_system_reference4 cdl_system_ref4, ptia.cdl_system_reference5 cdl_system_ref5, -- xu.attribute_category, xu.pa_expnd_attribute1, xu.pa_expnd_attribute2, xu.pa_expnd_attribute3, xu.pa_expnd_attribute4, xu.pa_expnd_attribute5, xu.pa_expnd_attribute6, xu.pa_expnd_attribute7, xu.pa_expnd_attribute8, xu.pa_expnd_attribute9, xu.pa_expnd_attribute10, -- xu.import_transactions from xxen_pa_project_transac_4491_u xu, pa_transaction_interface_all ptia, hr_all_organization_units_vl haouv where chartorowid(xu.row_id) = ptia.rowid and ptia.org_id = haouv.organization_id and xu.status_code_ = xxen_upload.status_success and ptia.transaction_status_code = 'P' and nvl(:p_submit_import,'Y') = 'N' Default value :$flex$.Reverse_in_Future_Period Reverse in Future Period|:p_accrual_flag| ACCRUAL_FLAG LOV query :$flex$.Reverse_in_Future_Period Reverse in Future Period|:p_accrual_flag| ACCRUAL_FLAG LOV query :$column$.business_group BUSINESS_GROUP ASSIGNMENT_NAME LOV query :$column$.employee_name EMPLOYEE_NAME ASSIGNMENT_NAME LOV query :$column$.employee_number EMPLOYEE_NUMBER ASSIGNMENT_NAME LOV query :$column$.expnd_item_date EXPND_ITEM_DATE ASSIGNMENT_NAME LOV query :$column$.expnd_type_class EXPND_TYPE_CLASS ASSIGNMENT_NAME LOV query :$column$.operating_unit OPERATING_UNIT ASSIGNMENT_NAME LOV query :$column$.project_number PROJECT_NUMBER ASSIGNMENT_NAME Default value :$flex$.batch_name Batch Name|:p_batch_name| BATCH_NAME LOV query :$column$.employee_name EMPLOYEE_NAME BUSINESS_GROUP Default value :$column$.employee_name EMPLOYEE_NAME BUSINESS_GROUP Default value :$column$.employee_number EMPLOYEE_NUMBER BUSINESS_GROUP LOV query :$column$.employee_number EMPLOYEE_NUMBER BUSINESS_GROUP Default value :$column$.expnd_ending_date EXPND_ENDING_DATE BUSINESS_GROUP LOV query :$column$.expnd_ending_date EXPND_ENDING_DATE BUSINESS_GROUP Default value :$column$.organization_name ORGANIZATION_NAME BUSINESS_GROUP LOV query :$column$.organization_name ORGANIZATION_NAME BUSINESS_GROUP LOV query :$column$.operating_unit OPERATING_UNIT CREDIT_ACCT LOV query :$column$.operating_unit OPERATING_UNIT DEBIT_ACCT LOV query :$column$.expnd_ending_date EXPND_ENDING_DATE EMPLOYEE_NAME LOV query :$column$.organization_name ORGANIZATION_NAME EMPLOYEE_NAME Default value :$column$.employee_name EMPLOYEE_NAME EMPLOYEE_NUMBER LOV query :$column$.employee_name EMPLOYEE_NAME EMPLOYEE_NUMBER LOV query :$column$.expnd_ending_date EXPND_ENDING_DATE EMPLOYEE_NUMBER Default value :$column$.expnd_ending_date EXPND_ENDING_DATE EMPLOYEE_NUMBER Default value :$column$.organization_name ORGANIZATION_NAME EMPLOYEE_NUMBER LOV query :$column$.organization_name ORGANIZATION_NAME EMPLOYEE_NUMBER Default value :$column$.operating_unit OPERATING_UNIT EXPND_ENDING_DATE Default value :$flex$.Expenditure_Ending_Date Expenditure Ending Date|:p_expnd_ending_date| EXPND_ENDING_DATE LOV query :$column$.expnd_item_date EXPND_ITEM_DATE EXPND_TYPE LOV query :$column$.expnd_type_class EXPND_TYPE_CLASS EXPND_TYPE LOV query :$column$.transaction_source TRANSACTION_SOURCE EXPND_TYPE_CLASS Default value :$column$.transaction_source TRANSACTION_SOURCE EXPND_TYPE_CLASS Default value :$flex$.Import_Transactions Import Transactions|:p_submit_import| IMPORT_TRANSACTIONS LOV query :$column$.quantity QUANTITY NEGATIVE_TXN_FLAG Default value :$column$.quantity QUANTITY NEGATIVE_TXN_FLAG Default value :$flex$.All_Negative_Expend_Unmatched All Negative Expend Unmatched|:p_unmatched_neg_txn_flag| NEGATIVE_TXN_FLAG LOV query :$column$.non_labor_resource NON_LABOR_RESOURCE NON_LABOR_ORG Default value :$column$.non_labor_resource NON_LABOR_RESOURCE NON_LABOR_ORG LOV query :$column$.expnd_type EXPND_TYPE NON_LABOR_RESOURCE Default value :$flex$.operating_unit Operating Unit|:p_operating_unit| OPERATING_UNIT LOV query :$flex$.operating_unit Operating Unit|:p_operating_unit| OPERATING_UNIT LOV query :$column$.operating_unit OPERATING_UNIT ORGANIZATION_NAME LOV query :$column$.business_group BUSINESS_GROUP OVERRIDE_TO_ORGANIZATION LOV query :$column$.pa_expnd_attribute1 PA_EXPND_ATTRIBUTE1 PA_EXPND_ATTRIBUTE1 LOV query :$column$.pa_expnd_attribute10 PA_EXPND_ATTRIBUTE10 PA_EXPND_ATTRIBUTE1 LOV query :$column$.pa_expnd_attribute2 PA_EXPND_ATTRIBUTE2 PA_EXPND_ATTRIBUTE1 LOV query :$column$.pa_expnd_attribute3 PA_EXPND_ATTRIBUTE3 PA_EXPND_ATTRIBUTE1 LOV query :$column$.pa_expnd_attribute4 PA_EXPND_ATTRIBUTE4 PA_EXPND_ATTRIBUTE1 LOV query :$column$.pa_expnd_attribute5 PA_EXPND_ATTRIBUTE5 PA_EXPND_ATTRIBUTE1 LOV query :$column$.pa_expnd_attribute6 PA_EXPND_ATTRIBUTE6 PA_EXPND_ATTRIBUTE1 LOV query :$column$.pa_expnd_attribute7 PA_EXPND_ATTRIBUTE7 PA_EXPND_ATTRIBUTE1 LOV query :$column$.pa_expnd_attribute8 PA_EXPND_ATTRIBUTE8 PA_EXPND_ATTRIBUTE1 LOV query :$column$.pa_expnd_attribute9 PA_EXPND_ATTRIBUTE9 PA_EXPND_ATTRIBUTE1 LOV query :$column$.pa_expnd_attribute1 PA_EXPND_ATTRIBUTE1 PA_EXPND_ATTRIBUTE10 LOV query :$column$.pa_expnd_attribute10 PA_EXPND_ATTRIBUTE10 PA_EXPND_ATTRIBUTE10 LOV query :$column$.pa_expnd_attribute2 PA_EXPND_ATTRIBUTE2 PA_EXPND_ATTRIBUTE10 LOV query :$column$.pa_expnd_attribute3 PA_EXPND_ATTRIBUTE3 PA_EXPND_ATTRIBUTE10 LOV query :$column$.pa_expnd_attribute4 PA_EXPND_ATTRIBUTE4 PA_EXPND_ATTRIBUTE10 LOV query :$column$.pa_expnd_attribute5 PA_EXPND_ATTRIBUTE5 PA_EXPND_ATTRIBUTE10 LOV query :$column$.pa_expnd_attribute6 PA_EXPND_ATTRIBUTE6 PA_EXPND_ATTRIBUTE10 LOV query :$column$.pa_expnd_attribute7 PA_EXPND_ATTRIBUTE7 PA_EXPND_ATTRIBUTE10 LOV query :$column$.pa_expnd_attribute8 PA_EXPND_ATTRIBUTE8 PA_EXPND_ATTRIBUTE10 LOV query :$column$.pa_expnd_attribute9 PA_EXPND_ATTRIBUTE9 PA_EXPND_ATTRIBUTE10 LOV query :$column$.pa_expnd_attribute1 PA_EXPND_ATTRIBUTE1 PA_EXPND_ATTRIBUTE2 LOV query :$column$.pa_expnd_attribute10 PA_EXPND_ATTRIBUTE10 PA_EXPND_ATTRIBUTE2 LOV query :$column$.pa_expnd_attribute2 PA_EXPND_ATTRIBUTE2 PA_EXPND_ATTRIBUTE2 LOV query :$column$.pa_expnd_attribute3 PA_EXPND_ATTRIBUTE3 PA_EXPND_ATTRIBUTE2 LOV query :$column$.pa_expnd_attribute4 PA_EXPND_ATTRIBUTE4 PA_EXPND_ATTRIBUTE2 LOV query :$column$.pa_expnd_attribute5 PA_EXPND_ATTRIBUTE5 PA_EXPND_ATTRIBUTE2 LOV query :$column$.pa_expnd_attribute6 PA_EXPND_ATTRIBUTE6 PA_EXPND_ATTRIBUTE2 LOV query :$column$.pa_expnd_attribute7 PA_EXPND_ATTRIBUTE7 PA_EXPND_ATTRIBUTE2 LOV query :$column$.pa_expnd_attribute8 PA_EXPND_ATTRIBUTE8 PA_EXPND_ATTRIBUTE2 LOV query :$column$.pa_expnd_attribute9 PA_EXPND_ATTRIBUTE9 PA_EXPND_ATTRIBUTE2 LOV query :$column$.pa_expnd_attribute1 PA_EXPND_ATTRIBUTE1 PA_EXPND_ATTRIBUTE3 LOV query :$column$.pa_expnd_attribute10 PA_EXPND_ATTRIBUTE10 PA_EXPND_ATTRIBUTE3 LOV query :$column$.pa_expnd_attribute2 PA_EXPND_ATTRIBUTE2 PA_EXPND_ATTRIBUTE3 LOV query :$column$.pa_expnd_attribute3 PA_EXPND_ATTRIBUTE3 PA_EXPND_ATTRIBUTE3 LOV query :$column$.pa_expnd_attribute4 PA_EXPND_ATTRIBUTE4 PA_EXPND_ATTRIBUTE3 LOV query :$column$.pa_expnd_attribute5 PA_EXPND_ATTRIBUTE5 PA_EXPND_ATTRIBUTE3 LOV query :$column$.pa_expnd_attribute6 PA_EXPND_ATTRIBUTE6 PA_EXPND_ATTRIBUTE3 LOV query :$column$.pa_expnd_attribute7 PA_EXPND_ATTRIBUTE7 PA_EXPND_ATTRIBUTE3 LOV query :$column$.pa_expnd_attribute8 PA_EXPND_ATTRIBUTE8 PA_EXPND_ATTRIBUTE3 LOV query :$column$.pa_expnd_attribute9 PA_EXPND_ATTRIBUTE9 PA_EXPND_ATTRIBUTE3 LOV query :$column$.pa_expnd_attribute1 PA_EXPND_ATTRIBUTE1 PA_EXPND_ATTRIBUTE4 LOV query :$column$.pa_expnd_attribute10 PA_EXPND_ATTRIBUTE10 PA_EXPND_ATTRIBUTE4 LOV query :$column$.pa_expnd_attribute2 PA_EXPND_ATTRIBUTE2 PA_EXPND_ATTRIBUTE4 LOV query :$column$.pa_expnd_attribute3 PA_EXPND_ATTRIBUTE3 PA_EXPND_ATTRIBUTE4 LOV query :$column$.pa_expnd_attribute4 PA_EXPND_ATTRIBUTE4 PA_EXPND_ATTRIBUTE4 LOV query :$column$.pa_expnd_attribute5 PA_EXPND_ATTRIBUTE5 PA_EXPND_ATTRIBUTE4 LOV query :$column$.pa_expnd_attribute6 PA_EXPND_ATTRIBUTE6 PA_EXPND_ATTRIBUTE4 LOV query :$column$.pa_expnd_attribute7 PA_EXPND_ATTRIBUTE7 PA_EXPND_ATTRIBUTE4 LOV query :$column$.pa_expnd_attribute8 PA_EXPND_ATTRIBUTE8 PA_EXPND_ATTRIBUTE4 LOV query :$column$.pa_expnd_attribute9 PA_EXPND_ATTRIBUTE9 PA_EXPND_ATTRIBUTE4 LOV query :$column$.pa_expnd_attribute1 PA_EXPND_ATTRIBUTE1 PA_EXPND_ATTRIBUTE5 LOV query :$column$.pa_expnd_attribute10 PA_EXPND_ATTRIBUTE10 PA_EXPND_ATTRIBUTE5 LOV query :$column$.pa_expnd_attribute2 PA_EXPND_ATTRIBUTE2 PA_EXPND_ATTRIBUTE5 LOV query :$column$.pa_expnd_attribute3 PA_EXPND_ATTRIBUTE3 PA_EXPND_ATTRIBUTE5 LOV query :$column$.pa_expnd_attribute4 PA_EXPND_ATTRIBUTE4 PA_EXPND_ATTRIBUTE5 LOV query :$column$.pa_expnd_attribute5 PA_EXPND_ATTRIBUTE5 PA_EXPND_ATTRIBUTE5 LOV query :$column$.pa_expnd_attribute6 PA_EXPND_ATTRIBUTE6 PA_EXPND_ATTRIBUTE5 LOV query :$column$.pa_expnd_attribute7 PA_EXPND_ATTRIBUTE7 PA_EXPND_ATTRIBUTE5 LOV query :$column$.pa_expnd_attribute8 PA_EXPND_ATTRIBUTE8 PA_EXPND_ATTRIBUTE5 LOV query :$column$.pa_expnd_attribute9 PA_EXPND_ATTRIBUTE9 PA_EXPND_ATTRIBUTE5 LOV query :$column$.pa_expnd_attribute1 PA_EXPND_ATTRIBUTE1 PA_EXPND_ATTRIBUTE6 LOV query :$column$.pa_expnd_attribute10 PA_EXPND_ATTRIBUTE10 PA_EXPND_ATTRIBUTE6 LOV query :$column$.pa_expnd_attribute2 PA_EXPND_ATTRIBUTE2 PA_EXPND_ATTRIBUTE6 LOV query :$column$.pa_expnd_attribute3 PA_EXPND_ATTRIBUTE3 PA_EXPND_ATTRIBUTE6 LOV query :$column$.pa_expnd_attribute4 PA_EXPND_ATTRIBUTE4 PA_EXPND_ATTRIBUTE6 LOV query :$column$.pa_expnd_attribute5 PA_EXPND_ATTRIBUTE5 PA_EXPND_ATTRIBUTE6 LOV query :$column$.pa_expnd_attribute6 PA_EXPND_ATTRIBUTE6 PA_EXPND_ATTRIBUTE6 LOV query :$column$.pa_expnd_attribute7 PA_EXPND_ATTRIBUTE7 PA_EXPND_ATTRIBUTE6 LOV query :$column$.pa_expnd_attribute8 PA_EXPND_ATTRIBUTE8 PA_EXPND_ATTRIBUTE6 LOV query :$column$.pa_expnd_attribute9 PA_EXPND_ATTRIBUTE9 PA_EXPND_ATTRIBUTE6 LOV query :$column$.pa_expnd_attribute1 PA_EXPND_ATTRIBUTE1 PA_EXPND_ATTRIBUTE7 LOV query :$column$.pa_expnd_attribute10 PA_EXPND_ATTRIBUTE10 PA_EXPND_ATTRIBUTE7 LOV query :$column$.pa_expnd_attribute2 PA_EXPND_ATTRIBUTE2 PA_EXPND_ATTRIBUTE7 LOV query :$column$.pa_expnd_attribute3 PA_EXPND_ATTRIBUTE3 PA_EXPND_ATTRIBUTE7 LOV query :$column$.pa_expnd_attribute4 PA_EXPND_ATTRIBUTE4 PA_EXPND_ATTRIBUTE7 LOV query :$column$.pa_expnd_attribute5 PA_EXPND_ATTRIBUTE5 PA_EXPND_ATTRIBUTE7 LOV query :$column$.pa_expnd_attribute6 PA_EXPND_ATTRIBUTE6 PA_EXPND_ATTRIBUTE7 LOV query :$column$.pa_expnd_attribute7 PA_EXPND_ATTRIBUTE7 PA_EXPND_ATTRIBUTE7 LOV query :$column$.pa_expnd_attribute8 PA_EXPND_ATTRIBUTE8 PA_EXPND_ATTRIBUTE7 LOV query :$column$.pa_expnd_attribute9 PA_EXPND_ATTRIBUTE9 PA_EXPND_ATTRIBUTE7 LOV query :$column$.pa_expnd_attribute1 PA_EXPND_ATTRIBUTE1 PA_EXPND_ATTRIBUTE8 LOV query :$column$.pa_expnd_attribute10 PA_EXPND_ATTRIBUTE10 PA_EXPND_ATTRIBUTE8 LOV query :$column$.pa_expnd_attribute2 PA_EXPND_ATTRIBUTE2 PA_EXPND_ATTRIBUTE8 LOV query :$column$.pa_expnd_attribute3 PA_EXPND_ATTRIBUTE3 PA_EXPND_ATTRIBUTE8 LOV query :$column$.pa_expnd_attribute4 PA_EXPND_ATTRIBUTE4 PA_EXPND_ATTRIBUTE8 LOV query :$column$.pa_expnd_attribute5 PA_EXPND_ATTRIBUTE5 PA_EXPND_ATTRIBUTE8 LOV query :$column$.pa_expnd_attribute6 PA_EXPND_ATTRIBUTE6 PA_EXPND_ATTRIBUTE8 LOV query :$column$.pa_expnd_attribute7 PA_EXPND_ATTRIBUTE7 PA_EXPND_ATTRIBUTE8 LOV query :$column$.pa_expnd_attribute8 PA_EXPND_ATTRIBUTE8 PA_EXPND_ATTRIBUTE8 LOV query :$column$.pa_expnd_attribute9 PA_EXPND_ATTRIBUTE9 PA_EXPND_ATTRIBUTE8 LOV query :$column$.pa_expnd_attribute1 PA_EXPND_ATTRIBUTE1 PA_EXPND_ATTRIBUTE9 LOV query :$column$.pa_expnd_attribute10 PA_EXPND_ATTRIBUTE10 PA_EXPND_ATTRIBUTE9 LOV query :$column$.pa_expnd_attribute2 PA_EXPND_ATTRIBUTE2 PA_EXPND_ATTRIBUTE9 LOV query :$column$.pa_expnd_attribute3 PA_EXPND_ATTRIBUTE3 PA_EXPND_ATTRIBUTE9 LOV query :$column$.pa_expnd_attribute4 PA_EXPND_ATTRIBUTE4 PA_EXPND_ATTRIBUTE9 LOV query :$column$.pa_expnd_attribute5 PA_EXPND_ATTRIBUTE5 PA_EXPND_ATTRIBUTE9 LOV query :$column$.pa_expnd_attribute6 PA_EXPND_ATTRIBUTE6 PA_EXPND_ATTRIBUTE9 LOV query :$column$.pa_expnd_attribute7 PA_EXPND_ATTRIBUTE7 PA_EXPND_ATTRIBUTE9 LOV query :$column$.pa_expnd_attribute8 PA_EXPND_ATTRIBUTE8 PA_EXPND_ATTRIBUTE9 LOV query :$column$.pa_expnd_attribute9 PA_EXPND_ATTRIBUTE9 PA_EXPND_ATTRIBUTE9 Default value :$column$.employee_name EMPLOYEE_NAME PERSON_TYPE LOV query :$column$.employee_name EMPLOYEE_NAME PERSON_TYPE Default value :$column$.employee_number EMPLOYEE_NUMBER PERSON_TYPE LOV query :$column$.employee_number EMPLOYEE_NUMBER PERSON_TYPE LOV query :$column$.expnd_ending_date EXPND_ENDING_DATE PERSON_TYPE Default value :$column$.expnd_ending_date EXPND_ENDING_DATE PERSON_TYPE LOV query :$column$.organization_name ORGANIZATION_NAME PERSON_TYPE Default value :$column$.organization_name ORGANIZATION_NAME PERSON_TYPE Default value :$column$.operating_unit OPERATING_UNIT PO_LINE_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT PO_LINE_NUMBER LOV query :$column$.po_number PO_NUMBER PO_LINE_NUMBER Default value :$column$.po_number PO_NUMBER PO_LINE_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT PO_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT PO_PRICE_TYPE Default value :$column$.operating_unit OPERATING_UNIT PO_PRICE_TYPE LOV query :$column$.po_line_number PO_LINE_NUMBER PO_PRICE_TYPE Default value :$column$.po_line_number PO_LINE_NUMBER PO_PRICE_TYPE LOV query :$column$.po_number PO_NUMBER PO_PRICE_TYPE Default value :$column$.po_number PO_NUMBER PO_PRICE_TYPE LOV query :$column$.expnd_item_date EXPND_ITEM_DATE PROJECT_NAME LOV query :$column$.operating_unit OPERATING_UNIT PROJECT_NAME LOV query :$column$.project_number PROJECT_NUMBER PROJECT_NAME LOV query :$column$.expnd_item_date EXPND_ITEM_DATE PROJECT_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT PROJECT_NUMBER LOV query :$column$.business_group BUSINESS_GROUP REVERSED_ORIG_TRANS_REF LOV query :$column$.employee_name EMPLOYEE_NAME REVERSED_ORIG_TRANS_REF LOV query :$column$.employee_number EMPLOYEE_NUMBER REVERSED_ORIG_TRANS_REF LOV query :$column$.expnd_item_date EXPND_ITEM_DATE REVERSED_ORIG_TRANS_REF LOV query :$column$.expnd_type EXPND_TYPE REVERSED_ORIG_TRANS_REF LOV query :$column$.non_labor_resource NON_LABOR_RESOURCE REVERSED_ORIG_TRANS_REF LOV query :$column$.operating_unit OPERATING_UNIT REVERSED_ORIG_TRANS_REF LOV query :$column$.organization_name ORGANIZATION_NAME REVERSED_ORIG_TRANS_REF LOV query :$column$.project_number PROJECT_NUMBER REVERSED_ORIG_TRANS_REF LOV query :$column$.task_number TASK_NUMBER REVERSED_ORIG_TRANS_REF LOV query :$column$.transaction_source TRANSACTION_SOURCE REVERSED_ORIG_TRANS_REF LOV query :$column$.expnd_item_date EXPND_ITEM_DATE TASK_NAME LOV query :$column$.operating_unit OPERATING_UNIT TASK_NAME LOV query :$column$.project_number PROJECT_NUMBER TASK_NAME LOV query :$column$.task_number TASK_NUMBER TASK_NAME LOV query :$column$.expnd_item_date EXPND_ITEM_DATE TASK_NUMBER LOV query :$column$.operating_unit OPERATING_UNIT TASK_NUMBER LOV query :$column$.project_number PROJECT_NUMBER TASK_NUMBER Default value :$flex$.transaction_source Transaction Source|:p_transaction_source| TRANSACTION_SOURCE LOV query :$flex$.transaction_source Transaction Source|:p_transaction_source| TRANSACTION_SOURCE Default value :$column$.employee_name EMPLOYEE_NAME VENDOR_NUMBER Default value :$column$.employee_number EMPLOYEE_NUMBER VENDOR_NUMBER Default value :$column$.expnd_ending_date EXPND_ENDING_DATE VENDOR_NUMBER Default value :$column$.organization_name ORGANIZATION_NAME VENDOR_NUMBER LOV query :$column$.expnd_item_date EXPND_ITEM_DATE WORK_TYPE_NAME LOV query :$column$.operating_unit OPERATING_UNIT WORK_TYPE_NAME LOV query :$column$.project_number PROJECT_NUMBER WORK_TYPE_NAME Excel validation :$column$.accrual_flag ACCRUAL_FLAG Excel validation :$column$.acctd_burdened_cost ACCTD_BURDENED_COST Excel validation :$column$.acctd_exchange_rate ACCTD_EXCHANGE_RATE Excel validation :$column$.acctd_exchange_rate_date ACCTD_EXCHANGE_RATE_DATE Excel validation :$column$.acctd_exchange_rate_type ACCTD_EXCHANGE_RATE_TYPE Excel validation :$column$.acctd_raw_cost ACCTD_RAW_COST Excel validation :$column$.business_group BUSINESS_GROUP Excel validation :$column$.credit_acct CREDIT_ACCT Excel validation :$column$.debit_acct DEBIT_ACCT Excel validation :$column$.employee_name EMPLOYEE_NAME Excel validation :$column$.employee_number EMPLOYEE_NUMBER Excel validation :$column$.expnd_ending_date EXPND_ENDING_DATE Excel validation :$column$.expnd_item_date EXPND_ITEM_DATE Excel validation :$column$.expnd_type_class EXPND_TYPE_CLASS Excel validation :$column$.gl_date GL_DATE Excel validation :$column$.non_labor_org NON_LABOR_ORG Excel validation :$column$.non_labor_resource NON_LABOR_RESOURCE Value to id query :$column$.operating_unit OPERATING_UNIT p_cr_code_combination_id Value to id query :$column$.operating_unit OPERATING_UNIT p_dr_code_combination_id Excel validation :$column$.operating_unit OPERATING_UNIT Excel validation :$column$.organization_name ORGANIZATION_NAME Excel validation :$column$.original_trans_ref ORIGINAL_TRANS_REF Excel validation :$column$.quantity QUANTITY Excel validation :$column$.transaction_source TRANSACTION_SOURCE Excel validation :$column$.trans_burdened_cost TRANS_BURDENED_COST Excel validation :$column$.trans_curr TRANS_CURR Excel validation :$column$.trans_raw_cost TRANS_RAW_COST