ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8C622B9AB93A476E850E95E64D5A10ECY select null action_, null status_, null message_, null modified_columns_, jrrev.resource_number, jov.name category, jrrev.resource_name, jrrev.start_date_active resource_start_date, jrrev.end_date_active resource_end_date, (select papf.employee_number from per_all_people_f papf where jrrev.category='EMPLOYEE' and jrrev.source_id=papf.person_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date) employee_number, hou.name operating_unit, jrs.salesrep_number salesperson_number, ost.name sales_credit_type, jrs.start_date_active start_date, jrs.end_date_active end_date, jrs.email_address email, xxen_util.yes(decode(jrs.sales_tax_inside_city_limits,'1','Y')) inside_city_limits, jrs.sales_tax_geocode geo_override, xxen_util.yes(decode(jrs.status,'I',null,'Y')) active_for_receivables, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where jrs.gl_id_freight=gcck.code_combination_id) freight_account, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where jrs.gl_id_rev=gcck.code_combination_id) revenue_account, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where jrs.gl_id_rec=gcck.code_combination_id) receivable_account, rtk.concatenated_segments territory, rtk.name territory_name, rst.start_date_active territory_start_date, rst.end_date_active territory_end_date, xxen_util.display_flexfield_context(690,'JTF_RS_SALESREPS',jrs.attribute_category) srp_attribute_category, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE1',jrs.rowid,jrs.attribute1) srp_attribute1, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE2',jrs.rowid,jrs.attribute2) srp_attribute2, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE3',jrs.rowid,jrs.attribute3) srp_attribute3, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE4',jrs.rowid,jrs.attribute4) srp_attribute4, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE5',jrs.rowid,jrs.attribute5) srp_attribute5, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE6',jrs.rowid,jrs.attribute6) srp_attribute6, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE7',jrs.rowid,jrs.attribute7) srp_attribute7, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE8',jrs.rowid,jrs.attribute8) srp_attribute8, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE9',jrs.rowid,jrs.attribute9) srp_attribute9, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE10',jrs.rowid,jrs.attribute10) srp_attribute10, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE11',jrs.rowid,jrs.attribute11) srp_attribute11, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE12',jrs.rowid,jrs.attribute12) srp_attribute12, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE13',jrs.rowid,jrs.attribute13) srp_attribute13, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE14',jrs.rowid,jrs.attribute14) srp_attribute14, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE15',jrs.rowid,jrs.attribute15) srp_attribute15, to_number(null) upload_row from hr_operating_units hou, jtf_rs_salesreps jrs, jtf_rs_resource_extns_vl jrrev, jtf_objects_vl jov, oe_sales_credit_types ost, ra_salesrep_territories rst, ra_territories_kfv rtk where 1=1 and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') and hou.organization_id=jrs.org_id and jrs.resource_id=jrrev.resource_id and jrrev.category=jov.object_code and jrs.sales_credit_type_id=ost.sales_credit_type_id and jrs.salesrep_id=rst.salesrep_id(+) and rst.territory_id=rtk.territory_id(+) Initial version. U A xxen_jtf_upload.upload_salesperson US JTF Salesperson Upload Creates and updates salespersons as in the Resources form of Resource Manager (Receivables > Setup > Transactions > Salespersons): the resource, its salesperson in an operating unit, and the salesperson territories. A row updates the salesperson with the Salesperson Number in the Operating Unit, or the salesperson of the same resource in that operating unit, which is then renumbered. Otherwise it creates the salesperson. A new salesperson uses the resource of the Resource Number, or else the employee resource of the Employee Number or the resource of the Category and Resource Name, and creates that resource when it does not exist. Only resources of category Employee or Other are created; resources of other categories must exist. Resource Name, Resource Start Date and Resource End Date apply to the resource and so to its salespersons in every operating unit. Each row carries one territory. Enter further territories of a salesperson on further rows; a territory is end-dated with its Territory End Date, not deleted. Enginatics R12 only Upload 1=1 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 hou.name=:operating_unit LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name US Operating Unit 3 30 1=1 jrrev.category=:category LOV custom select jov.object_code id, jov.name value, null description from jtf_objects_vl jov, jtf_object_usages jou where jov.object_code=jou.object_code and jou.object_user_code='RESOURCE_CATEGORIES' order by jov.name US Category 4 40 1=1 jrrev.resource_name=:resource_name LOV custom select distinct jrrev.resource_name value, null description from jtf_rs_resource_extns_vl jrrev where jrrev.resource_id in (select jrs.resource_id from jtf_rs_salesreps jrs) and (:$flex$.category is null or jrrev.category=:$flex$.category) order by jrrev.resource_name US Resource Name 5 50 1=1 jrs.salesrep_number=:salesperson_number LOV custom select distinct jrs.salesrep_number value, null description from jtf_rs_salesreps jrs where (:$flex$.operating_unit is null or jrs.org_id in (select hou.organization_id from hr_operating_units hou where xxen_util.contains(:$flex$.operating_unit,hou.name)='Y')) order by jrs.salesrep_number US Salesperson Number 6 60 1=1 nvl(jrs.end_date_active,sysdate)>=trunc(sysdate) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Exclude End Dated Excludes salespersons whose end date has passed. 4214AD72DA6D481D8B2BF22BF0BED0C3 Default Creates and updates salespersons with the fields of the Resources form, Receivables tab, without the flexfield. ENGINATICS 15 ACTIVE_FOR_RECEIVABLES 2 CATEGORY 12 EMAIL 6 EMPLOYEE_NUMBER 11 END_DATE 16 FREIGHT_ACCOUNT 14 GEO_OVERRIDE 13 INSIDE_CITY_LIMITS 7 OPERATING_UNIT 18 RECEIVABLE_ACCOUNT 5 RESOURCE_END_DATE 3 RESOURCE_NAME 1 RESOURCE_NUMBER 4 RESOURCE_START_DATE Y 17 REVENUE_ACCOUNT 8 SALESPERSON_NUMBER 9 SALES_CREDIT_TYPE 10 START_DATE 19 TERRITORY 22 TERRITORY_END_DATE 20 TERRITORY_NAME 21 TERRITORY_START_DATE Upload Mode C,U S Site 74E4300AF0734D0E9F42163020176D82 Flexfield Maintains the salesperson descriptive flexfield of existing salespersons. ENGINATICS 2 CATEGORY 4 OPERATING_UNIT 3 RESOURCE_NAME 1 RESOURCE_NUMBER 5 SALESPERSON_NUMBER 7 SRP_ATTRIBUTE1 16 SRP_ATTRIBUTE10 17 SRP_ATTRIBUTE11 18 SRP_ATTRIBUTE12 19 SRP_ATTRIBUTE13 20 SRP_ATTRIBUTE14 21 SRP_ATTRIBUTE15 8 SRP_ATTRIBUTE2 9 SRP_ATTRIBUTE3 10 SRP_ATTRIBUTE4 11 SRP_ATTRIBUTE5 12 SRP_ATTRIBUTE6 13 SRP_ATTRIBUTE7 14 SRP_ATTRIBUTE8 15 SRP_ATTRIBUTE9 6 SRP_ATTRIBUTE_CATEGORY Y Upload Mode C,U S Site D27E0713D4B04E938DC73AB52E9FF004 New Salespersons Opens an empty sheet to create salespersons. Enter an Employee Number for an employee, or Category Other and a Resource Name. The upload creates the resource when it does not exist yet. ENGINATICS 14 ACTIVE_FOR_RECEIVABLES 1 CATEGORY 11 EMAIL 5 EMPLOYEE_NUMBER 10 END_DATE 15 FREIGHT_ACCOUNT 13 GEO_OVERRIDE 12 INSIDE_CITY_LIMITS 6 OPERATING_UNIT 17 RECEIVABLE_ACCOUNT 4 RESOURCE_END_DATE 2 RESOURCE_NAME 3 RESOURCE_START_DATE Y 16 REVENUE_ACCOUNT 7 SALESPERSON_NUMBER 8 SALES_CREDIT_TYPE 9 START_DATE 18 TERRITORY 21 TERRITORY_END_DATE 19 TERRITORY_NAME 20 TERRITORY_START_DATE Upload Mode C Y S Site Category Exclude End Dated Operating Unit Resource Name Salesperson Number DA7826FDCE9B4A33B5A996204682F38D Territories Assigns territories to salespersons and maintains their dates. Enter one row per salesperson and territory. ENGINATICS 2 CATEGORY 7 END_DATE 4 OPERATING_UNIT 3 RESOURCE_NAME 1 RESOURCE_NUMBER 5 SALESPERSON_NUMBER 6 START_DATE Y 8 TERRITORY 11 TERRITORY_END_DATE 9 TERRITORY_NAME 10 TERRITORY_START_DATE Upload Mode C,U S Site 4214AD72DA6D481D8B2BF22BF0BED0C3 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 RESOURCE_NUMBER Char varchar2 Identifies the existing resource of a new salesperson, for example to add a salesperson in another operating unit. Assigned when the upload creates the resource. Y 6 CATEGORY LOV custom varchar2 select jov.object_code id, jov.name value, null description from jtf_objects_vl jov, jtf_object_usages jou where jov.object_code=jou.object_code and jou.object_user_code='RESOURCE_CATEGORIES' order by jov.name select jov.name from jtf_objects_vl jov where jov.object_code='EMPLOYEE' Resource category. The upload creates resources of category Employee, from the Employee Number, or Other, from the Resource Name. Resources of other categories must exist in Resource Manager. Y Y 7 RESOURCE_NAME Char varchar2 select distinct nvl((select max(jrrev.resource_name) from jtf_rs_resource_extns_vl jrrev where jrrev.category='EMPLOYEE' and papf.person_id=jrrev.source_id),papf.full_name) from per_all_people_f papf where papf.employee_number=:$column$.employee_number and (:$column$.operating_unit is null or papf.business_group_id in (select hou.business_group_id from hr_operating_units hou where hou.name=:$column$.operating_unit)) and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date 8 RESOURCE_START_DATE Date date Defaults to the salesperson Start Date when the upload creates the resource. 9 RESOURCE_END_DATE Date date 10 EMPLOYEE_NUMBER LOV custom varchar2 select papf.person_id id, papf.employee_number value, papf.full_name description from hr_operating_units hou, per_all_people_f papf where hou.name=:$column$.operating_unit and hou.business_group_id=papf.business_group_id and papf.employee_number is not null and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date order by papf.employee_number Employee of a resource of category Employee, in the business group of the operating unit. Y 11 OPERATING_UNIT LOV varchar2 HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name select hou.organization_id id, hou.name value from hr_operating_units hou Y Y 12 SALESPERSON_NUMBER Char varchar2 Y 13 SALES_CREDIT_TYPE LOV custom varchar2 select ost.sales_credit_type_id id, ost.name value, ost.description from oe_sales_credit_types ost where ost.quota_flag='Y' and ost.enabled_flag='Y' order by ost.name Y 14 START_DATE Date date trunc(sysdate) Y 15 END_DATE Date date Required when the salesperson is not Active for Receivables. 16 EMAIL Char varchar2 17 INSIDE_CITY_LIMITS LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 18 GEO_OVERRIDE Char varchar2 19 ACTIVE_FOR_RECEIVABLES LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual xxen_util.meaning('Y','YES_NO',0) 20 FREIGHT_ACCOUNT LOV custom varchar2 select gcck.code_combination_id id, gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id=(select gl.chart_of_accounts_id from hr_operating_units hou, gl_ledgers gl where hou.name=:$column$.operating_unit and hou.set_of_books_id=gl.ledger_id) and gcck.detail_posting_allowed='Y' and gcck.enabled_flag='Y' and gcck.summary_flag='N' order by gcck.concatenated_segments 21 REVENUE_ACCOUNT LOV custom varchar2 select gcck.code_combination_id id, gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id=(select gl.chart_of_accounts_id from hr_operating_units hou, gl_ledgers gl where hou.name=:$column$.operating_unit and hou.set_of_books_id=gl.ledger_id) and gcck.detail_posting_allowed='Y' and gcck.enabled_flag='Y' and gcck.summary_flag='N' order by gcck.concatenated_segments 22 RECEIVABLE_ACCOUNT LOV custom varchar2 select gcck.code_combination_id id, gcck.concatenated_segments value, xxen_util.segments_description(gcck.code_combination_id) description from gl_code_combinations_kfv gcck where gcck.chart_of_accounts_id=(select gl.chart_of_accounts_id from hr_operating_units hou, gl_ledgers gl where hou.name=:$column$.operating_unit and hou.set_of_books_id=gl.ledger_id) and gcck.detail_posting_allowed='Y' and gcck.enabled_flag='Y' and gcck.summary_flag='N' order by gcck.concatenated_segments 23 TERRITORY LOV custom varchar2 select rtk.territory_id id, rtk.concatenated_segments value, rtk.name description from ra_territories_kfv rtk where rtk.enabled_flag='Y' order by rtk.concatenated_segments One territory of the salesperson per row. Enter further territories on further rows with the same salesperson. 24 TERRITORY_NAME Char varchar2 select rtk.name from ra_territories_kfv rtk where rtk.concatenated_segments=:$column$.territory Y 25 TERRITORY_START_DATE Date date select trunc(sysdate) from dual where :$column$.territory is not null 26 TERRITORY_END_DATE Date date 27 SRP_ATTRIBUTE_CATEGORY LOV custom varchar2 select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=690 and fdfcv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 28 SRP_ATTRIBUTE1 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE1' 29 SRP_ATTRIBUTE2 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE2' 30 SRP_ATTRIBUTE3 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE3' 31 SRP_ATTRIBUTE4 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE4' 32 SRP_ATTRIBUTE5 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE5' 33 SRP_ATTRIBUTE6 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE6' 34 SRP_ATTRIBUTE7 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE7' 35 SRP_ATTRIBUTE8 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE8' 36 SRP_ATTRIBUTE9 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE9' 37 SRP_ATTRIBUTE10 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE10' 38 SRP_ATTRIBUTE11 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE11' 39 SRP_ATTRIBUTE12 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE12' 40 SRP_ATTRIBUTE13 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE13' 41 SRP_ATTRIBUTE14 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE14' 42 SRP_ATTRIBUTE15 LOV custom varchar2 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=>690, p_descriptive_flexfield_name=>'JTF_RS_SALESREPS', p_context_name=>:$column$.srp_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.srp_attribute1, p_attribute2=>:$column$.srp_attribute2, p_attribute3=>:$column$.srp_attribute3, p_attribute4=>:$column$.srp_attribute4, p_attribute5=>:$column$.srp_attribute5, p_attribute6=>:$column$.srp_attribute6, p_attribute7=>:$column$.srp_attribute7, p_attribute8=>:$column$.srp_attribute8, p_attribute9=>:$column$.srp_attribute9, p_attribute10=>:$column$.srp_attribute10, p_attribute11=>:$column$.srp_attribute11, p_attribute12=>:$column$.srp_attribute12, p_attribute13=>:$column$.srp_attribute13, p_attribute14=>:$column$.srp_attribute14, p_attribute15=>:$column$.srp_attribute15 ) ) 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=690 and fdfv.descriptive_flexfield_name='JTF_RS_SALESREPS' and fdfcuv.application_column_name='ATTRIBUTE15' 43 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_resource_number in Char Y RESOURCE_NUMBER U 5 p_category in Char Y CATEGORY U 6 p_resource_name in Char Y RESOURCE_NAME U 7 p_resource_start_date in Date Y RESOURCE_START_DATE U 8 p_resource_end_date in Date Y RESOURCE_END_DATE U 9 p_person_id in Number Y EMPLOYEE_NUMBER U 10 p_org_id in Number Y OPERATING_UNIT U 11 p_salesrep_number in Char Y SALESPERSON_NUMBER U 12 p_sales_credit_type_id in Number Y SALES_CREDIT_TYPE U 13 p_start_date in Date Y START_DATE U 14 p_end_date in Date Y END_DATE U 15 p_email_address in Char Y EMAIL U 16 p_inside_city_limits in Char Y INSIDE_CITY_LIMITS U 17 p_sales_tax_geocode in Char Y GEO_OVERRIDE U 18 p_active in Char Y ACTIVE_FOR_RECEIVABLES U 19 p_gl_id_freight in Number Y FREIGHT_ACCOUNT U 20 p_gl_id_rev in Number Y REVENUE_ACCOUNT U 21 p_gl_id_rec in Number Y RECEIVABLE_ACCOUNT U 22 p_territory_id in Number Y TERRITORY U 23 p_territory_start_date in Date Y TERRITORY_START_DATE U 24 p_territory_end_date in Date Y TERRITORY_END_DATE U 25 p_attribute_category in Char Y SRP_ATTRIBUTE_CATEGORY U 26 p_attribute1 in Char Y SRP_ATTRIBUTE1 U 27 p_attribute2 in Char Y SRP_ATTRIBUTE2 U 28 p_attribute3 in Char Y SRP_ATTRIBUTE3 U 29 p_attribute4 in Char Y SRP_ATTRIBUTE4 U 30 p_attribute5 in Char Y SRP_ATTRIBUTE5 U 31 p_attribute6 in Char Y SRP_ATTRIBUTE6 U 32 p_attribute7 in Char Y SRP_ATTRIBUTE7 U 33 p_attribute8 in Char Y SRP_ATTRIBUTE8 U 34 p_attribute9 in Char Y SRP_ATTRIBUTE9 U 35 p_attribute10 in Char Y SRP_ATTRIBUTE10 U 36 p_attribute11 in Char Y SRP_ATTRIBUTE11 U 37 p_attribute12 in Char Y SRP_ATTRIBUTE12 U 38 p_attribute13 in Char Y SRP_ATTRIBUTE13 U 39 p_attribute14 in Char Y SRP_ATTRIBUTE14 U 40 p_attribute15 in Char Y SRP_ATTRIBUTE15 Error SQL Order By upload_row, operating_unit, salesperson_number, territory Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, x.resource_number, nvl(x.category,xu.category) category, nvl(x.resource_name,xu.resource_name) resource_name, nvl(x.resource_start_date,xu.resource_start_date) resource_start_date, nvl(x.resource_end_date,xu.resource_end_date) resource_end_date, nvl(x.employee_number,xu.employee_number) employee_number, nvl(x.operating_unit,xu.operating_unit) operating_unit, nvl(x.salesperson_number,xu.salesperson_number) salesperson_number, nvl(x.sales_credit_type,xu.sales_credit_type) sales_credit_type, nvl(x.start_date,xu.start_date) start_date, nvl(x.end_date,xu.end_date) end_date, nvl(x.email,xu.email) email, x.inside_city_limits, nvl(x.geo_override,xu.geo_override) geo_override, x.active_for_receivables, nvl(x.freight_account,xu.freight_account) freight_account, nvl(x.revenue_account,xu.revenue_account) revenue_account, nvl(x.receivable_account,xu.receivable_account) receivable_account, nvl((select rtk.concatenated_segments from ra_salesrep_territories rst, ra_territories_kfv rtk where x.salesrep_id=rst.salesrep_id and rst.territory_id=rtk.territory_id and rtk.concatenated_segments=xu.territory),xu.territory) territory, nvl((select rtk.name from ra_territories_kfv rtk where rtk.concatenated_segments=xu.territory),xu.territory_name) territory_name, nvl((select rst.start_date_active from ra_salesrep_territories rst where x.salesrep_id=rst.salesrep_id and rst.territory_id=(select rtk.territory_id from ra_territories_kfv rtk where rtk.concatenated_segments=xu.territory)),xu.territory_start_date) territory_start_date, (select rst.end_date_active from ra_salesrep_territories rst where x.salesrep_id=rst.salesrep_id and rst.territory_id=(select rtk.territory_id from ra_territories_kfv rtk where rtk.concatenated_segments=xu.territory)) territory_end_date, x.srp_attribute_category, x.srp_attribute1, x.srp_attribute2, x.srp_attribute3, x.srp_attribute4, x.srp_attribute5, x.srp_attribute6, x.srp_attribute7, x.srp_attribute8, x.srp_attribute9, x.srp_attribute10, x.srp_attribute11, x.srp_attribute12, x.srp_attribute13, x.srp_attribute14, x.srp_attribute15, xu.upload_row from xxen_jtf_salesperson_up_5265_u xu, ( select jrs.salesrep_id, jrrev.resource_number, jov.name category, jrrev.resource_name, jrrev.start_date_active resource_start_date, jrrev.end_date_active resource_end_date, (select papf.employee_number from per_all_people_f papf where jrrev.category='EMPLOYEE' and jrrev.source_id=papf.person_id and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date) employee_number, hou.name operating_unit, jrs.salesrep_number salesperson_number, ost.name sales_credit_type, jrs.start_date_active start_date, jrs.end_date_active end_date, jrs.email_address email, xxen_util.yes(decode(jrs.sales_tax_inside_city_limits,'1','Y')) inside_city_limits, jrs.sales_tax_geocode geo_override, xxen_util.yes(decode(jrs.status,'I',null,'Y')) active_for_receivables, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where jrs.gl_id_freight=gcck.code_combination_id) freight_account, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where jrs.gl_id_rev=gcck.code_combination_id) revenue_account, (select gcck.concatenated_segments from gl_code_combinations_kfv gcck where jrs.gl_id_rec=gcck.code_combination_id) receivable_account, xxen_util.display_flexfield_context(690,'JTF_RS_SALESREPS',jrs.attribute_category) srp_attribute_category, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE1',jrs.rowid,jrs.attribute1) srp_attribute1, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE2',jrs.rowid,jrs.attribute2) srp_attribute2, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE3',jrs.rowid,jrs.attribute3) srp_attribute3, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE4',jrs.rowid,jrs.attribute4) srp_attribute4, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE5',jrs.rowid,jrs.attribute5) srp_attribute5, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE6',jrs.rowid,jrs.attribute6) srp_attribute6, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE7',jrs.rowid,jrs.attribute7) srp_attribute7, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE8',jrs.rowid,jrs.attribute8) srp_attribute8, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE9',jrs.rowid,jrs.attribute9) srp_attribute9, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE10',jrs.rowid,jrs.attribute10) srp_attribute10, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE11',jrs.rowid,jrs.attribute11) srp_attribute11, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE12',jrs.rowid,jrs.attribute12) srp_attribute12, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE13',jrs.rowid,jrs.attribute13) srp_attribute13, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE14',jrs.rowid,jrs.attribute14) srp_attribute14, xxen_util.display_flexfield_value(690,'JTF_RS_SALESREPS',jrs.attribute_category,'ATTRIBUTE15',jrs.rowid,jrs.attribute15) srp_attribute15 from hr_operating_units hou, jtf_rs_salesreps jrs, jtf_rs_resource_extns_vl jrrev, jtf_objects_vl jov, oe_sales_credit_types ost where hou.organization_id=jrs.org_id and jrs.resource_id=jrrev.resource_id and jrrev.category=jov.object_code and jrs.sales_credit_type_id=ost.sales_credit_type_id ) x where xu.status_code_=xxen_upload.status_success and xu.operating_unit=x.operating_unit(+) and xu.salesperson_number=x.salesperson_number(+)