ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 9E2A605B98604782B52C3BEB7994A79AY select null action_, null status_, null message_, null modified_columns_, bd.department_id, mp.organization_code, bd.department_code department, bd.description, xxen_util.meaning(bd.maint_cost_category,'BOM_EAM_COST_CATEGORY',700) cost_category, bd.department_class_code class, bdc.description class_description, hl.location_code location, hl.description location_description, haouv.name project_expenditure_org, bd.disable_date inactive_on, gcck_s.concatenated_segments scrap_account, gcck_e.concatenated_segments estimated_absorption_account, xxen_util.display_flexfield_context(702,'BOM_DEPARTMENTS',bd.attribute_category) dept_attribute_category, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE1',bd.rowid,bd.attribute1) dept_attribute1, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE2',bd.rowid,bd.attribute2) dept_attribute2, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE3',bd.rowid,bd.attribute3) dept_attribute3, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE4',bd.rowid,bd.attribute4) dept_attribute4, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE5',bd.rowid,bd.attribute5) dept_attribute5, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE6',bd.rowid,bd.attribute6) dept_attribute6, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE7',bd.rowid,bd.attribute7) dept_attribute7, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE8',bd.rowid,bd.attribute8) dept_attribute8, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE9',bd.rowid,bd.attribute9) dept_attribute9, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE10',bd.rowid,bd.attribute10) dept_attribute10, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE11',bd.rowid,bd.attribute11) dept_attribute11, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE12',bd.rowid,bd.attribute12) dept_attribute12, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE13',bd.rowid,bd.attribute13) dept_attribute13, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE14',bd.rowid,bd.attribute14) dept_attribute14, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE15',bd.rowid,bd.attribute15) dept_attribute15, br.resource_code, br.description resource_description, bd_own.department_code owning_department, decode(bdr.available_24_hours_flag,1,xxen_util.meaning('1','SYS_YES_NO',700)) available_24_hours, decode(bdr.share_capacity_flag,1,xxen_util.meaning('1','SYS_YES_NO',700)) share_capacity, br.unit_of_measure uom, bdr.capacity_units units, decode(bdr.ctp_flag,1,xxen_util.meaning('1','SYS_YES_NO',700)) check_ctp, xxen_util.meaning(bdr.resource_group_name,'CRP_RESOURCE_GROUPS',3) resource_group, decode(bdr.schedule_to_instance,1,xxen_util.meaning('1','SYS_YES_NO',700)) schedule_by_instance, bdr.exception_set_name exception_set, mar.rule_name atp_rule, bdr.utilization*100 utilization_percent, bdr.efficiency*100 efficiency_percent, bdr.sequencing_window sequencing_window_days, null delete_resource, xxen_util.display_flexfield_context(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category) res_attribute_category, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE1',bdr.rowid,bdr.attribute1) res_attribute1, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE2',bdr.rowid,bdr.attribute2) res_attribute2, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE3',bdr.rowid,bdr.attribute3) res_attribute3, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE4',bdr.rowid,bdr.attribute4) res_attribute4, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE5',bdr.rowid,bdr.attribute5) res_attribute5, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE6',bdr.rowid,bdr.attribute6) res_attribute6, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE7',bdr.rowid,bdr.attribute7) res_attribute7, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE8',bdr.rowid,bdr.attribute8) res_attribute8, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE9',bdr.rowid,bdr.attribute9) res_attribute9, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE10',bdr.rowid,bdr.attribute10) res_attribute10, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE11',bdr.rowid,bdr.attribute11) res_attribute11, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE12',bdr.rowid,bdr.attribute12) res_attribute12, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE13',bdr.rowid,bdr.attribute13) res_attribute13, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE14',bdr.rowid,bdr.attribute14) res_attribute14, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE15',bdr.rowid,bdr.attribute15) res_attribute15, to_char(brs.shift_num) shift_num, (select bcs.description from bom_calendar_shifts bcs where mp.calendar_code=bcs.calendar_code and brs.shift_num=bcs.shift_num) shift_description, brs.capacity_units shift_units, null delete_shift, xxen_util.display_flexfield_context(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category) shift_attribute_category, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE1',brs.rowid,brs.attribute1) shift_attribute1, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE2',brs.rowid,brs.attribute2) shift_attribute2, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE3',brs.rowid,brs.attribute3) shift_attribute3, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE4',brs.rowid,brs.attribute4) shift_attribute4, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE5',brs.rowid,brs.attribute5) shift_attribute5, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE6',brs.rowid,brs.attribute6) shift_attribute6, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE7',brs.rowid,brs.attribute7) shift_attribute7, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE8',brs.rowid,brs.attribute8) shift_attribute8, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE9',brs.rowid,brs.attribute9) shift_attribute9, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE10',brs.rowid,brs.attribute10) shift_attribute10, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE11',brs.rowid,brs.attribute11) shift_attribute11, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE12',brs.rowid,brs.attribute12) shift_attribute12, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE13',brs.rowid,brs.attribute13) shift_attribute13, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE14',brs.rowid,brs.attribute14) shift_attribute14, xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE15',brs.rowid,brs.attribute15) shift_attribute15, to_number(null) upload_row from mtl_parameters mp, bom_departments bd, bom_department_classes bdc, hr_locations_all hl, hr_all_organization_units_vl haouv, gl_code_combinations_kfv gcck_s, gl_code_combinations_kfv gcck_e, bom_department_resources bdr, bom_resources br, bom_departments bd_own, mtl_atp_rules mar, bom_resource_shifts brs where 1=1 and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=bd.organization_id and bd.department_class_code=bdc.department_class_code(+) and bd.organization_id=bdc.organization_id(+) and bd.location_id=hl.location_id(+) and bd.pa_expenditure_org_id=haouv.organization_id(+) and bd.scrap_account=gcck_s.code_combination_id(+) and bd.est_absorption_account=gcck_e.code_combination_id(+) and bd.department_id=bdr.department_id(+) and bdr.resource_id=br.resource_id(+) and bdr.share_from_dept_id=bd_own.department_id(+) and bdr.atp_rule_id=mar.rule_id(+) and bdr.department_id=brs.department_id(+) and bdr.resource_id=brs.resource_id(+) Initial version. Creates and updates departments, department resources and resource shifts through the table handlers of the Departments form (BOMFDODP). U A xxen_bom_upload.upload_department US BOM Department Upload Creates and updates departments with their resources and resource shifts - the Departments form (Bills of Material > Routings > Departments). Each row holds one department, optionally one of its resources and one shift of that resource. The department and resource columns repeat on every row, and a change in any of these rows is applied. Departments cannot be deleted; enter an Inactive On date instead. A resource with an Owning Department is borrowed from that department: its availability, units, Check CTP, ATP rule, utilization and efficiency are copied from the owning department's resource, which must have Share set to Yes. Changing Available 24 Hours of a shared resource updates the departments borrowing it, as the form does. A resource that is not available 24 hours needs at least one shift. Deleting its last shift makes it available 24 hours. To remove a resource from a department, delete its shifts first, or enter Yes in Delete Shift and Delete Resource on the same row. Utilization % and Efficiency % are entered as percentages. Cost Category is available in eAM organizations only, Project Expenditure Org in organizations with project cost collection, and the scrap accounts in organizations with network manufacturing (WSM). 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 Create downloads an empty template. Create, Update also downloads the existing departments with their resources and shifts. 2 20 1=1 mp.organization_code=:organization_code LOV INV Organization Code (including master) 0B22DF18E239D64AE0630100007FBD85 select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code Inventory organization of the departments. Also the default Organization Code of new rows. 3 30 1=1 bd.department_code=:department LOV BOM Department 8E2FF36EDEDC79D2E0530100007F1FF2 select bd.department_code value, nvl2(bd.department_class_code,bd.department_class_code||': ',null)||bd.description description from bom_departments bd where :$flex$.organization_code is null and bd.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') or bd.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') order by bd.department_code US Department 4 40 1=1 bd.department_class_code=:department_class LOV custom select distinct bdc.department_class_code value, bdc.description from mtl_parameters mp, bom_department_classes bdc where (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and mp.organization_id=bdc.organization_id order by bdc.department_class_code US Department Class 5 50 1=1 br.resource_code=:resource_code LOV BOM Resource Code 8E2FF36EDF0E79D2E0530100007F1FF2 select br.resource_code value, br.description from bom_resources br where (:$flex$.organization_code is null or br.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code US Resource Downloads only the departments that have this resource, with this resource only. 6 60 1=1 nvl(bd.disable_date,sysdate+1)>sysdate LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Active only Yes excludes departments with an Inactive On date that has passed. B0587E266523492BB2B19E5A9B7D371C Create An empty sheet to enter new departments, resources and shifts. ENGINATICS 24 ATP_RULE 16 AVAILABLE_24_HOURS 20 CHECK_CTP 5 CLASS 6 CLASS_DESCRIPTION 4 COST_CATEGORY 28 DELETE_RESOURCE 32 DELETE_SHIFT 2 DEPARTMENT 3 DESCRIPTION Y 26 EFFICIENCY_PERCENT 12 ESTIMATED_ABSORPTION_ACCOUNT 23 EXCEPTION_SET 10 INACTIVE_ON 7 LOCATION 8 LOCATION_DESCRIPTION 1 ORGANIZATION_CODE 15 OWNING_DEPARTMENT 9 PROJECT_EXPENDITURE_ORG 13 RESOURCE_CODE 14 RESOURCE_DESCRIPTION 21 RESOURCE_GROUP 22 SCHEDULE_BY_INSTANCE 11 SCRAP_ACCOUNT 27 SEQUENCING_WINDOW_DAYS 17 SHARE_CAPACITY 30 SHIFT_DESCRIPTION 29 SHIFT_NUM 31 SHIFT_UNITS 19 UNITS 18 UOM 25 UTILIZATION_PERCENT Upload Mode C Y S Site Active only Department Department Class Resource 054AA2292CAD4CDEB0790BCDFFFEE4A9 Default Departments, resources and shifts without the descriptive flexfield attributes. ENGINATICS 24 ATP_RULE 16 AVAILABLE_24_HOURS 20 CHECK_CTP 5 CLASS 6 CLASS_DESCRIPTION 4 COST_CATEGORY 28 DELETE_RESOURCE 32 DELETE_SHIFT 2 DEPARTMENT 3 DESCRIPTION Y 26 EFFICIENCY_PERCENT 12 ESTIMATED_ABSORPTION_ACCOUNT 23 EXCEPTION_SET 10 INACTIVE_ON 7 LOCATION 8 LOCATION_DESCRIPTION 1 ORGANIZATION_CODE 15 OWNING_DEPARTMENT 9 PROJECT_EXPENDITURE_ORG 13 RESOURCE_CODE 14 RESOURCE_DESCRIPTION 21 RESOURCE_GROUP 22 SCHEDULE_BY_INSTANCE 11 SCRAP_ACCOUNT 27 SEQUENCING_WINDOW_DAYS 17 SHARE_CAPACITY 30 SHIFT_DESCRIPTION 29 SHIFT_NUM 31 SHIFT_UNITS 19 UNITS 18 UOM 25 UTILIZATION_PERCENT Upload Mode C,U S Site 00C595CD38A242DE8EC9B975620294F2 Flexfields The descriptive flexfield attributes of departments, department resources and resource shifts. ENGINATICS 2 DEPARTMENT 6 DEPT_ATTRIBUTE1 15 DEPT_ATTRIBUTE10 16 DEPT_ATTRIBUTE11 17 DEPT_ATTRIBUTE12 18 DEPT_ATTRIBUTE13 19 DEPT_ATTRIBUTE14 20 DEPT_ATTRIBUTE15 7 DEPT_ATTRIBUTE2 8 DEPT_ATTRIBUTE3 9 DEPT_ATTRIBUTE4 10 DEPT_ATTRIBUTE5 11 DEPT_ATTRIBUTE6 12 DEPT_ATTRIBUTE7 13 DEPT_ATTRIBUTE8 14 DEPT_ATTRIBUTE9 5 DEPT_ATTRIBUTE_CATEGORY Y 1 ORGANIZATION_CODE 3 RESOURCE_CODE 22 RES_ATTRIBUTE1 31 RES_ATTRIBUTE10 32 RES_ATTRIBUTE11 33 RES_ATTRIBUTE12 34 RES_ATTRIBUTE13 35 RES_ATTRIBUTE14 36 RES_ATTRIBUTE15 23 RES_ATTRIBUTE2 24 RES_ATTRIBUTE3 25 RES_ATTRIBUTE4 26 RES_ATTRIBUTE5 27 RES_ATTRIBUTE6 28 RES_ATTRIBUTE7 29 RES_ATTRIBUTE8 30 RES_ATTRIBUTE9 21 RES_ATTRIBUTE_CATEGORY 38 SHIFT_ATTRIBUTE1 47 SHIFT_ATTRIBUTE10 48 SHIFT_ATTRIBUTE11 49 SHIFT_ATTRIBUTE12 50 SHIFT_ATTRIBUTE13 51 SHIFT_ATTRIBUTE14 52 SHIFT_ATTRIBUTE15 39 SHIFT_ATTRIBUTE2 40 SHIFT_ATTRIBUTE3 41 SHIFT_ATTRIBUTE4 42 SHIFT_ATTRIBUTE5 43 SHIFT_ATTRIBUTE6 44 SHIFT_ATTRIBUTE7 45 SHIFT_ATTRIBUTE8 46 SHIFT_ATTRIBUTE9 37 SHIFT_ATTRIBUTE_CATEGORY 4 SHIFT_NUM Upload Mode C,U S Site 054AA2292CAD4CDEB0790BCDFFFEE4A9 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 DEPARTMENT_ID Number number Y 6 ORGANIZATION_CODE LOV varchar2 INV Organization Code (including master) 0B22DF18E239D64AE0630100007FBD85 select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='INV') and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code select mp.organization_id id, mp.organization_code value from mtl_parameters mp where mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) :$flex$.organization_code Y Y 7 DEPARTMENT LOV custom varchar2 Y select bd.department_code value, bd.description from mtl_parameters mp, bom_departments bd where mp.organization_code=:$column$.organization_code and mp.organization_id=bd.organization_id order by bd.department_code Y 8 DESCRIPTION Char varchar2 9 COST_CATEGORY LOV custom varchar2 select to_char(ml.lookup_code) id, ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='BOM_EAM_COST_CATEGORY' and ml.enabled_flag='Y' and sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and exists (select null from mtl_parameters mp where mp.organization_code=:$column$.organization_code and mp.eam_enabled_flag='Y') order by ml.lookup_code select to_char(ml.lookup_code) id, ml.meaning value from mfg_lookups ml where ml.lookup_type='BOM_EAM_COST_CATEGORY' 10 CLASS LOV custom varchar2 select bdc.department_class_code value, bdc.description from mtl_parameters mp, bom_department_classes bdc where mp.organization_code=:$column$.organization_code and mp.organization_id=bdc.organization_id order by bdc.department_class_code 11 CLASS_DESCRIPTION Char varchar2 select bdc.description from mtl_parameters mp, bom_department_classes bdc where mp.organization_code=:$column$.organization_code and mp.organization_id=bdc.organization_id and bdc.department_class_code=:$column$.class Y 12 LOCATION LOV custom varchar2 select hl.location_id id, hl.location_code value, hl.description from mtl_parameters mp, hr_locations hl where mp.organization_code=:$column$.organization_code and (hl.inventory_organization_id=mp.organization_id or hl.inventory_organization_id is null) and nvl(hl.inactive_date,sysdate+1)>sysdate order by hl.location_code select hla.location_id id, hla.location_code value from mtl_parameters mp, hr_locations_all hla where mp.organization_code=:$column$.organization_code and (hla.inventory_organization_id=mp.organization_id or hla.inventory_organization_id is null) 13 LOCATION_DESCRIPTION Char varchar2 select hl.description from mtl_parameters mp, hr_locations_all hl where mp.organization_code=:$column$.organization_code and (hl.inventory_organization_id=mp.organization_id or hl.inventory_organization_id is null) and hl.location_code=:$column$.location Y 14 PROJECT_EXPENDITURE_ORG LOV custom varchar2 select hou.organization_id id, hou.name value, null description from mtl_parameters mp, hr_organization_units hou, pa_all_organizations pao where mp.organization_code=:$column$.organization_code and mp.pm_cost_collection_enabled=1 and hou.organization_id=pao.organization_id and pao.pa_org_use_type='EXPENDITURES' and pao.inactive_date is null and trunc(sysdate) between hou.date_from and nvl(hou.date_to,trunc(sysdate)) and pao.org_id=nvl((select hoi.org_information3 from hr_organization_information hoi where hoi.org_information_context='Accounting Information' and mp.organization_id=hoi.organization_id),pao.org_id) order by hou.name select distinct haouv.organization_id id, haouv.name value from hr_all_organization_units_vl haouv, pa_all_organizations pao where haouv.organization_id=pao.organization_id and pao.pa_org_use_type='EXPENDITURES' 15 INACTIVE_ON Date date 16 SCRAP_ACCOUNT LOV custom varchar2 select gcck.code_combination_id id, gcck.concatenated_segments value, null description from org_organization_definitions ood, gl_code_combinations_kfv gcck where ood.organization_code=:$column$.organization_code and ood.organization_id in (select wp.organization_id from wsm_parameters wp) and ood.chart_of_accounts_id=gcck.chart_of_accounts_id and gcck.enabled_flag='Y' and gcck.summary_flag='N' and gcck.detail_posting_allowed='Y' order by gcck.concatenated_segments select gcck.code_combination_id id, gcck.concatenated_segments value from org_organization_definitions ood, gl_code_combinations_kfv gcck where ood.organization_code=:$column$.organization_code and ood.chart_of_accounts_id=gcck.chart_of_accounts_id 17 ESTIMATED_ABSORPTION_ACCOUNT LOV custom varchar2 select gcck.code_combination_id id, gcck.concatenated_segments value, null description from org_organization_definitions ood, gl_code_combinations_kfv gcck where ood.organization_code=:$column$.organization_code and ood.organization_id in (select wp.organization_id from wsm_parameters wp) and ood.chart_of_accounts_id=gcck.chart_of_accounts_id and gcck.enabled_flag='Y' and gcck.summary_flag='N' and gcck.detail_posting_allowed='Y' order by gcck.concatenated_segments select gcck.code_combination_id id, gcck.concatenated_segments value from org_organization_definitions ood, gl_code_combinations_kfv gcck where ood.organization_code=:$column$.organization_code and ood.chart_of_accounts_id=gcck.chart_of_accounts_id 18 DEPT_ATTRIBUTE_CATEGORY LOV custom varchar2 select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=702 and fdfcv.descriptive_flexfield_name='BOM_DEPARTMENTS' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 19 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE1' 20 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE2' 21 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE3' 22 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE4' 23 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE5' 24 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE6' 25 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE7' 26 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE8' 27 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE9' 28 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE10' 29 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE11' 30 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE12' 31 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE13' 32 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE14' 33 DEPT_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENTS', p_context_name=>:$column$.dept_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.dept_attribute1, p_attribute2=>:$column$.dept_attribute2, p_attribute3=>:$column$.dept_attribute3, p_attribute4=>:$column$.dept_attribute4, p_attribute5=>:$column$.dept_attribute5, p_attribute6=>:$column$.dept_attribute6, p_attribute7=>:$column$.dept_attribute7, p_attribute8=>:$column$.dept_attribute8, p_attribute9=>:$column$.dept_attribute9, p_attribute10=>:$column$.dept_attribute10, p_attribute11=>:$column$.dept_attribute11, p_attribute12=>:$column$.dept_attribute12, p_attribute13=>:$column$.dept_attribute13, p_attribute14=>:$column$.dept_attribute14, p_attribute15=>:$column$.dept_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENTS' and 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 fdfcuv.application_column_name='ATTRIBUTE15' 34 RESOURCE_CODE LOV custom varchar2 select br.resource_id id, br.resource_code value, br.description from mtl_parameters mp, bom_resources br where mp.organization_code=:$column$.organization_code and mp.organization_id=br.organization_id and br.cost_code_type in (3,4) and nvl(br.disable_date,sysdate+1)>sysdate order by br.resource_code select br.resource_id id, br.resource_code value from mtl_parameters mp, bom_resources br where mp.organization_code=:$column$.organization_code and mp.organization_id=br.organization_id 35 RESOURCE_DESCRIPTION Char varchar2 select br.description from mtl_parameters mp, bom_resources br where mp.organization_code=:$column$.organization_code and mp.organization_id=br.organization_id and br.resource_code=:$column$.resource_code Y 36 OWNING_DEPARTMENT LOV custom varchar2 select bd.department_id id, bd.department_code value, bd.description from mtl_parameters mp, bom_resources br, bom_department_resources bdr, bom_departments bd where mp.organization_code=:$column$.organization_code and mp.organization_id=br.organization_id and br.resource_code=:$column$.resource_code and br.resource_id=bdr.resource_id and bdr.share_capacity_flag=1 and bdr.department_id=bd.department_id and bd.department_code<>:$column$.department order by bd.department_code select bd.department_id id, bd.department_code value from mtl_parameters mp, bom_departments bd where mp.organization_code=:$column$.organization_code and mp.organization_id=bd.organization_id 37 AVAILABLE_24_HOURS LOV custom varchar2 select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='SYS_YES_NO' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) select xxen_util.meaning('1','SYS_YES_NO',700) from dual where :$column$.resource_code is not null and :$column$.owning_department is null and not exists ( select null from mtl_parameters mp, bom_departments bd, bom_resources br, bom_department_resources bdr where mp.organization_code=:$column$.organization_code and mp.organization_id=bd.organization_id and (:$column$.department_id is null and bd.department_code=:$column$.department or bd.department_id=:$column$.department_id) and mp.organization_id=br.organization_id and br.resource_code=:$column$.resource_code and bd.department_id=bdr.department_id and br.resource_id=bdr.resource_id ) 38 SHARE_CAPACITY LOV custom varchar2 select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='SYS_YES_NO' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) 39 UOM Char varchar2 select br.unit_of_measure from mtl_parameters mp, bom_resources br where mp.organization_code=:$column$.organization_code and mp.organization_id=br.organization_id and br.resource_code=:$column$.resource_code Y 40 UNITS Number number 41 CHECK_CTP LOV custom varchar2 select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='SYS_YES_NO' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by to_number(flvv.lookup_code) 42 RESOURCE_GROUP LOV custom varchar2 select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='CRP_RESOURCE_GROUPS' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and trunc(sysdate) between nvl(flvv.start_date_active,trunc(sysdate)) and nvl(flvv.end_date_active,trunc(sysdate)) order by flvv.meaning select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type='CRP_RESOURCE_GROUPS' and flvv.view_application_id=3 and flvv.security_group_id=0 43 SCHEDULE_BY_INSTANCE LOV custom varchar2 select flvv.lookup_code id, flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='SYS_YES_NO' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and ( flvv.lookup_code='2' or exists ( select null from mtl_parameters mp, bom_resources br where mp.organization_code=:$column$.organization_code and mp.organization_id=br.organization_id and br.resource_code=:$column$.resource_code and br.resource_type not in (2,4,5,6) ) ) order by to_number(flvv.lookup_code) 44 EXCEPTION_SET LOV custom varchar2 select mpes.exception_set_name value, null description from mtl_parameters mp, mrp_planning_exception_sets mpes where mp.organization_code=:$column$.organization_code and mp.organization_id=mpes.organization_id order by mpes.exception_set_name 45 ATP_RULE LOV custom varchar2 select mar.rule_id id, mar.rule_name value, mar.description from mtl_atp_rules mar order by mar.rule_name 46 UTILIZATION_PERCENT Number number 47 EFFICIENCY_PERCENT Number number 48 SEQUENCING_WINDOW_DAYS Number number 49 DELETE_RESOURCE LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where exists ( select null from mtl_parameters mp, bom_departments bd, bom_resources br, bom_department_resources bdr where mp.organization_code=:$column$.organization_code and mp.organization_id=bd.organization_id and (:$column$.department_id is null and bd.department_code=:$column$.department or bd.department_id=:$column$.department_id) and mp.organization_id=br.organization_id and br.resource_code=:$column$.resource_code and bd.department_id=bdr.department_id and br.resource_id=bdr.resource_id ) 50 RES_ATTRIBUTE_CATEGORY LOV custom varchar2 select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=702 and fdfcv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 51 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE1' 52 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE2' 53 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE3' 54 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE4' 55 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE5' 56 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE6' 57 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE7' 58 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE8' 59 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE9' 60 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE10' 61 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE11' 62 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE12' 63 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE13' 64 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE14' 65 RES_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=>702, p_descriptive_flexfield_name=>'BOM_DEPARTMENT_RESOURCES', p_context_name=>:$column$.res_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.res_attribute1, p_attribute2=>:$column$.res_attribute2, p_attribute3=>:$column$.res_attribute3, p_attribute4=>:$column$.res_attribute4, p_attribute5=>:$column$.res_attribute5, p_attribute6=>:$column$.res_attribute6, p_attribute7=>:$column$.res_attribute7, p_attribute8=>:$column$.res_attribute8, p_attribute9=>:$column$.res_attribute9, p_attribute10=>:$column$.res_attribute10, p_attribute11=>:$column$.res_attribute11, p_attribute12=>:$column$.res_attribute12, p_attribute13=>:$column$.res_attribute13, p_attribute14=>:$column$.res_attribute14, p_attribute15=>:$column$.res_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_DEPARTMENT_RESOURCES' and 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 fdfcuv.application_column_name='ATTRIBUTE15' 66 SHIFT_NUM LOV custom varchar2 select to_char(bcs.shift_num) value, bcs.description from mtl_parameters mp, bom_calendar_shifts bcs where mp.organization_code=:$column$.organization_code and mp.calendar_code=bcs.calendar_code order by bcs.shift_num 67 SHIFT_DESCRIPTION Char varchar2 select bcs.description from mtl_parameters mp, bom_calendar_shifts bcs where mp.organization_code=:$column$.organization_code and mp.calendar_code=bcs.calendar_code and to_char(bcs.shift_num)=:$column$.shift_num Y 68 SHIFT_UNITS Number number 69 DELETE_SHIFT LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where exists ( select null from mtl_parameters mp, bom_departments bd, bom_resources br, bom_resource_shifts brs where mp.organization_code=:$column$.organization_code and mp.organization_id=bd.organization_id and (:$column$.department_id is null and bd.department_code=:$column$.department or bd.department_id=:$column$.department_id) and mp.organization_id=br.organization_id and br.resource_code=:$column$.resource_code and bd.department_id=brs.department_id and br.resource_id=brs.resource_id and to_char(brs.shift_num)=:$column$.shift_num ) 70 SHIFT_ATTRIBUTE_CATEGORY LOV custom varchar2 select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=702 and fdfcv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 71 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE1' 72 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE2' 73 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE3' 74 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE4' 75 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE5' 76 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE6' 77 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE7' 78 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE8' 79 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE9' 80 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE10' 81 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE11' 82 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE12' 83 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE13' 84 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE14' 85 SHIFT_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=>702, p_descriptive_flexfield_name=>'BOM_RESOURCE_SHIFTS', p_context_name=>:$column$.shift_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.shift_attribute1, p_attribute2=>:$column$.shift_attribute2, p_attribute3=>:$column$.shift_attribute3, p_attribute4=>:$column$.shift_attribute4, p_attribute5=>:$column$.shift_attribute5, p_attribute6=>:$column$.shift_attribute6, p_attribute7=>:$column$.shift_attribute7, p_attribute8=>:$column$.shift_attribute8, p_attribute9=>:$column$.shift_attribute9, p_attribute10=>:$column$.shift_attribute10, p_attribute11=>:$column$.shift_attribute11, p_attribute12=>:$column$.shift_attribute12, p_attribute13=>:$column$.shift_attribute13, p_attribute14=>:$column$.shift_attribute14, p_attribute15=>:$column$.shift_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 fdfv.application_id=702 and fdfv.descriptive_flexfield_name='BOM_RESOURCE_SHIFTS' and 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 fdfcuv.application_column_name='ATTRIBUTE15' 86 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_department_id in Number Y DEPARTMENT_ID U 5 p_department_id_out out Number DEPARTMENT_ID U 6 p_organization_id in Number ORGANIZATION_CODE U 7 p_department_code in Char DEPARTMENT U 8 p_description in Char Y DESCRIPTION U 9 p_maint_cost_category in Char Y COST_CATEGORY U 10 p_department_class_code in Char Y CLASS U 11 p_location_id in Number Y LOCATION U 12 p_pa_expenditure_org_id in Number Y PROJECT_EXPENDITURE_ORG U 13 p_disable_date in Date Y INACTIVE_ON U 14 p_scrap_account in Number Y SCRAP_ACCOUNT U 15 p_est_absorption_account in Number Y ESTIMATED_ABSORPTION_ACCOUNT U 16 p_dept_attribute_category in Char Y DEPT_ATTRIBUTE_CATEGORY U 17 p_dept_attribute1 in Char Y DEPT_ATTRIBUTE1 U 18 p_dept_attribute2 in Char Y DEPT_ATTRIBUTE2 U 19 p_dept_attribute3 in Char Y DEPT_ATTRIBUTE3 U 20 p_dept_attribute4 in Char Y DEPT_ATTRIBUTE4 U 21 p_dept_attribute5 in Char Y DEPT_ATTRIBUTE5 U 22 p_dept_attribute6 in Char Y DEPT_ATTRIBUTE6 U 23 p_dept_attribute7 in Char Y DEPT_ATTRIBUTE7 U 24 p_dept_attribute8 in Char Y DEPT_ATTRIBUTE8 U 25 p_dept_attribute9 in Char Y DEPT_ATTRIBUTE9 U 26 p_dept_attribute10 in Char Y DEPT_ATTRIBUTE10 U 27 p_dept_attribute11 in Char Y DEPT_ATTRIBUTE11 U 28 p_dept_attribute12 in Char Y DEPT_ATTRIBUTE12 U 29 p_dept_attribute13 in Char Y DEPT_ATTRIBUTE13 U 30 p_dept_attribute14 in Char Y DEPT_ATTRIBUTE14 U 31 p_dept_attribute15 in Char Y DEPT_ATTRIBUTE15 U 32 p_resource_id in Number Y RESOURCE_CODE U 33 p_share_from_dept_id in Number Y OWNING_DEPARTMENT U 34 p_available_24_hours_flag in Number Y AVAILABLE_24_HOURS U 35 p_share_capacity_flag in Number Y SHARE_CAPACITY U 36 p_capacity_units in Number Y UNITS U 37 p_ctp_flag in Number Y CHECK_CTP U 38 p_resource_group_name in Char Y RESOURCE_GROUP U 39 p_schedule_to_instance in Number Y SCHEDULE_BY_INSTANCE U 40 p_exception_set_name in Char Y EXCEPTION_SET U 41 p_atp_rule_id in Number Y ATP_RULE U 42 p_utilization in Number Y UTILIZATION_PERCENT U 43 p_efficiency in Number Y EFFICIENCY_PERCENT U 44 p_sequencing_window in Number Y SEQUENCING_WINDOW_DAYS U 45 p_delete_resource in Char Y DELETE_RESOURCE U 46 p_res_attribute_category in Char Y RES_ATTRIBUTE_CATEGORY U 47 p_res_attribute1 in Char Y RES_ATTRIBUTE1 U 48 p_res_attribute2 in Char Y RES_ATTRIBUTE2 U 49 p_res_attribute3 in Char Y RES_ATTRIBUTE3 U 50 p_res_attribute4 in Char Y RES_ATTRIBUTE4 U 51 p_res_attribute5 in Char Y RES_ATTRIBUTE5 U 52 p_res_attribute6 in Char Y RES_ATTRIBUTE6 U 53 p_res_attribute7 in Char Y RES_ATTRIBUTE7 U 54 p_res_attribute8 in Char Y RES_ATTRIBUTE8 U 55 p_res_attribute9 in Char Y RES_ATTRIBUTE9 U 56 p_res_attribute10 in Char Y RES_ATTRIBUTE10 U 57 p_res_attribute11 in Char Y RES_ATTRIBUTE11 U 58 p_res_attribute12 in Char Y RES_ATTRIBUTE12 U 59 p_res_attribute13 in Char Y RES_ATTRIBUTE13 U 60 p_res_attribute14 in Char Y RES_ATTRIBUTE14 U 61 p_res_attribute15 in Char Y RES_ATTRIBUTE15 U 62 p_shift_num in Number Y SHIFT_NUM U 63 p_shift_capacity_units in Number Y SHIFT_UNITS U 64 p_delete_shift in Char Y DELETE_SHIFT U 65 p_shift_attribute_category in Char Y SHIFT_ATTRIBUTE_CATEGORY U 66 p_shift_attribute1 in Char Y SHIFT_ATTRIBUTE1 U 67 p_shift_attribute2 in Char Y SHIFT_ATTRIBUTE2 U 68 p_shift_attribute3 in Char Y SHIFT_ATTRIBUTE3 U 69 p_shift_attribute4 in Char Y SHIFT_ATTRIBUTE4 U 70 p_shift_attribute5 in Char Y SHIFT_ATTRIBUTE5 U 71 p_shift_attribute6 in Char Y SHIFT_ATTRIBUTE6 U 72 p_shift_attribute7 in Char Y SHIFT_ATTRIBUTE7 U 73 p_shift_attribute8 in Char Y SHIFT_ATTRIBUTE8 U 74 p_shift_attribute9 in Char Y SHIFT_ATTRIBUTE9 U 75 p_shift_attribute10 in Char Y SHIFT_ATTRIBUTE10 U 76 p_shift_attribute11 in Char Y SHIFT_ATTRIBUTE11 U 77 p_shift_attribute12 in Char Y SHIFT_ATTRIBUTE12 U 78 p_shift_attribute13 in Char Y SHIFT_ATTRIBUTE13 U 79 p_shift_attribute14 in Char Y SHIFT_ATTRIBUTE14 U 80 p_shift_attribute15 in Char Y SHIFT_ATTRIBUTE15 Error SQL Order By upload_row, organization_code, department, resource_code, to_number(shift_num) Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.department_id, mp.organization_code, bd.department_code department, bd.description, xxen_util.meaning(bd.maint_cost_category,'BOM_EAM_COST_CATEGORY',700) cost_category, bd.department_class_code class, bdc.description class_description, hl.location_code location, hl.description location_description, haouv.name project_expenditure_org, bd.disable_date inactive_on, gcck_s.concatenated_segments scrap_account, gcck_e.concatenated_segments estimated_absorption_account, xxen_util.display_flexfield_context(702,'BOM_DEPARTMENTS',bd.attribute_category) dept_attribute_category, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE1',bd.rowid,bd.attribute1) dept_attribute1, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE2',bd.rowid,bd.attribute2) dept_attribute2, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE3',bd.rowid,bd.attribute3) dept_attribute3, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE4',bd.rowid,bd.attribute4) dept_attribute4, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE5',bd.rowid,bd.attribute5) dept_attribute5, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE6',bd.rowid,bd.attribute6) dept_attribute6, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE7',bd.rowid,bd.attribute7) dept_attribute7, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE8',bd.rowid,bd.attribute8) dept_attribute8, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE9',bd.rowid,bd.attribute9) dept_attribute9, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE10',bd.rowid,bd.attribute10) dept_attribute10, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE11',bd.rowid,bd.attribute11) dept_attribute11, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE12',bd.rowid,bd.attribute12) dept_attribute12, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE13',bd.rowid,bd.attribute13) dept_attribute13, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE14',bd.rowid,bd.attribute14) dept_attribute14, xxen_util.display_flexfield_value(702,'BOM_DEPARTMENTS',bd.attribute_category,'ATTRIBUTE15',bd.rowid,bd.attribute15) dept_attribute15, nvl(br.resource_code,xu.resource_code) resource_code, nvl(br.description,xu.resource_description) resource_description, case when bdr.rowid is null then xu.owning_department else bd_own.department_code end owning_department, case when bdr.rowid is null then xu.available_24_hours else decode(bdr.available_24_hours_flag,1,xxen_util.meaning('1','SYS_YES_NO',700)) end available_24_hours, case when bdr.rowid is null then xu.share_capacity else decode(bdr.share_capacity_flag,1,xxen_util.meaning('1','SYS_YES_NO',700)) end share_capacity, nvl(br.unit_of_measure,xu.uom) uom, case when bdr.rowid is null then xu.units else bdr.capacity_units end units, case when bdr.rowid is null then xu.check_ctp else decode(bdr.ctp_flag,1,xxen_util.meaning('1','SYS_YES_NO',700)) end check_ctp, case when bdr.rowid is null then xu.resource_group else xxen_util.meaning(bdr.resource_group_name,'CRP_RESOURCE_GROUPS',3) end resource_group, case when bdr.rowid is null then xu.schedule_by_instance else decode(bdr.schedule_to_instance,1,xxen_util.meaning('1','SYS_YES_NO',700)) end schedule_by_instance, case when bdr.rowid is null then xu.exception_set else bdr.exception_set_name end exception_set, case when bdr.rowid is null then xu.atp_rule else mar.rule_name end atp_rule, case when bdr.rowid is null then xu.utilization_percent else bdr.utilization*100 end utilization_percent, case when bdr.rowid is null then xu.efficiency_percent else bdr.efficiency*100 end efficiency_percent, case when bdr.rowid is null then xu.sequencing_window_days else bdr.sequencing_window end sequencing_window_days, xu.delete_resource, case when bdr.rowid is null then xu.res_attribute_category else xxen_util.display_flexfield_context(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category) end res_attribute_category, case when bdr.rowid is null then xu.res_attribute1 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE1',bdr.rowid,bdr.attribute1) end res_attribute1, case when bdr.rowid is null then xu.res_attribute2 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE2',bdr.rowid,bdr.attribute2) end res_attribute2, case when bdr.rowid is null then xu.res_attribute3 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE3',bdr.rowid,bdr.attribute3) end res_attribute3, case when bdr.rowid is null then xu.res_attribute4 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE4',bdr.rowid,bdr.attribute4) end res_attribute4, case when bdr.rowid is null then xu.res_attribute5 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE5',bdr.rowid,bdr.attribute5) end res_attribute5, case when bdr.rowid is null then xu.res_attribute6 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE6',bdr.rowid,bdr.attribute6) end res_attribute6, case when bdr.rowid is null then xu.res_attribute7 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE7',bdr.rowid,bdr.attribute7) end res_attribute7, case when bdr.rowid is null then xu.res_attribute8 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE8',bdr.rowid,bdr.attribute8) end res_attribute8, case when bdr.rowid is null then xu.res_attribute9 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE9',bdr.rowid,bdr.attribute9) end res_attribute9, case when bdr.rowid is null then xu.res_attribute10 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE10',bdr.rowid,bdr.attribute10) end res_attribute10, case when bdr.rowid is null then xu.res_attribute11 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE11',bdr.rowid,bdr.attribute11) end res_attribute11, case when bdr.rowid is null then xu.res_attribute12 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE12',bdr.rowid,bdr.attribute12) end res_attribute12, case when bdr.rowid is null then xu.res_attribute13 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE13',bdr.rowid,bdr.attribute13) end res_attribute13, case when bdr.rowid is null then xu.res_attribute14 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE14',bdr.rowid,bdr.attribute14) end res_attribute14, case when bdr.rowid is null then xu.res_attribute15 else xxen_util.display_flexfield_value(702,'BOM_DEPARTMENT_RESOURCES',bdr.attribute_category,'ATTRIBUTE15',bdr.rowid,bdr.attribute15) end res_attribute15, xu.shift_num, nvl((select bcs.description from bom_calendar_shifts bcs where mp.calendar_code=bcs.calendar_code and brs.shift_num=bcs.shift_num),xu.shift_description) shift_description, case when brs.rowid is null then xu.shift_units else brs.capacity_units end shift_units, xu.delete_shift, case when brs.rowid is null then xu.shift_attribute_category else xxen_util.display_flexfield_context(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category) end shift_attribute_category, case when brs.rowid is null then xu.shift_attribute1 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE1',brs.rowid,brs.attribute1) end shift_attribute1, case when brs.rowid is null then xu.shift_attribute2 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE2',brs.rowid,brs.attribute2) end shift_attribute2, case when brs.rowid is null then xu.shift_attribute3 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE3',brs.rowid,brs.attribute3) end shift_attribute3, case when brs.rowid is null then xu.shift_attribute4 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE4',brs.rowid,brs.attribute4) end shift_attribute4, case when brs.rowid is null then xu.shift_attribute5 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE5',brs.rowid,brs.attribute5) end shift_attribute5, case when brs.rowid is null then xu.shift_attribute6 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE6',brs.rowid,brs.attribute6) end shift_attribute6, case when brs.rowid is null then xu.shift_attribute7 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE7',brs.rowid,brs.attribute7) end shift_attribute7, case when brs.rowid is null then xu.shift_attribute8 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE8',brs.rowid,brs.attribute8) end shift_attribute8, case when brs.rowid is null then xu.shift_attribute9 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE9',brs.rowid,brs.attribute9) end shift_attribute9, case when brs.rowid is null then xu.shift_attribute10 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE10',brs.rowid,brs.attribute10) end shift_attribute10, case when brs.rowid is null then xu.shift_attribute11 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE11',brs.rowid,brs.attribute11) end shift_attribute11, case when brs.rowid is null then xu.shift_attribute12 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE12',brs.rowid,brs.attribute12) end shift_attribute12, case when brs.rowid is null then xu.shift_attribute13 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE13',brs.rowid,brs.attribute13) end shift_attribute13, case when brs.rowid is null then xu.shift_attribute14 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE14',brs.rowid,brs.attribute14) end shift_attribute14, case when brs.rowid is null then xu.shift_attribute15 else xxen_util.display_flexfield_value(702,'BOM_RESOURCE_SHIFTS',brs.attribute_category,'ATTRIBUTE15',brs.rowid,brs.attribute15) end shift_attribute15, xu.upload_row from ( select x.*, (select br0.resource_id from mtl_parameters mp0, bom_resources br0 where x.organization_code=mp0.organization_code and mp0.organization_id=br0.organization_id and x.resource_code=br0.resource_code) resource_id from xxen_bom_department_upl_0568_u x ) xu, --before 12c an outer joined table may reference at most one other table, so the resource id is resolved inside the view bom_departments bd, mtl_parameters mp, bom_department_classes bdc, hr_locations_all hl, hr_all_organization_units_vl haouv, gl_code_combinations_kfv gcck_s, gl_code_combinations_kfv gcck_e, bom_resources br, bom_department_resources bdr, bom_departments bd_own, mtl_atp_rules mar, bom_resource_shifts brs where xu.status_code_=xxen_upload.status_success and xu.department_id=bd.department_id and bd.organization_id=mp.organization_id and bd.department_class_code=bdc.department_class_code(+) and bd.organization_id=bdc.organization_id(+) and bd.location_id=hl.location_id(+) and bd.pa_expenditure_org_id=haouv.organization_id(+) and bd.scrap_account=gcck_s.code_combination_id(+) and bd.est_absorption_account=gcck_e.code_combination_id(+) and xu.resource_id=br.resource_id(+) and xu.department_id=bdr.department_id(+) and xu.resource_id=bdr.resource_id(+) and bdr.share_from_dept_id=bd_own.department_id(+) and bdr.atp_rule_id=mar.rule_id(+) and xu.department_id=brs.department_id(+) and xu.resource_id=brs.resource_id(+) and to_number(xu.shift_num)=brs.shift_num(+)