ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 7279CDCE4FC84E52BA2BA0EBF2F414E4Y select null action_, null status_, null message_, null modified_columns_, br.resource_id, mp.organization_code, br.resource_code, br.disable_date inactive_on, br.description, decode(br.functional_currency_flag,1,fnd_message.get_string('FND','CURRENCY'),xxen_util.meaning(br.resource_type,'BOM_RESOURCE_TYPE',700)) resource_type, br.unit_of_measure uom, xxen_util.meaning(br.autocharge_type,'BOM_AUTOCHARGE_TYPE',700) charge_type, xxen_util.meaning(br.default_basis_type,'BOM_BASIS_TYPE',700) basis, br.expenditure_type, br.supply_subinventory, milk.concatenated_segments supply_locator, xxen_util.yes(decode(br.cost_code_type,4,'Y')) outside_processing, msiv_p.concatenated_segments outside_processing_item, msiv_p.description outside_processing_item_desc, msiv_b.concatenated_segments billable_item, msiv_b.description billable_item_description, decode(br.allow_costs_flag,1,xxen_util.meaning('1','SYS_YES_NO',700)) costed, ca.activity, decode(br.standard_rate_flag,1,xxen_util.meaning('1','SYS_YES_NO',700)) standard_rate, gcck_a.concatenated_segments absorption_account, gcck_v.concatenated_segments variance_account, pc.name competence, (select to_char(prl.step_value)||'-'||prl.name from per_rating_levels prl where br.rating_level_id=prl.rating_level_id) skill_level, pqt.name qualification, decode(br.batchable,1,xxen_util.meaning('1','SYS_YES_NO',700)) batchable, br.min_batch_capacity minimum_batch_capacity, br.max_batch_capacity maximum_batch_capacity, br.batch_capacity_uom, br.batch_window batching_window, br.batch_window_uom batching_window_uom, xxen_util.display_flexfield_context(702,'BOM_RESOURCES',br.attribute_category) res_attribute_category, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE1',br.rowid,br.attribute1) res_attribute1, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE2',br.rowid,br.attribute2) res_attribute2, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE3',br.rowid,br.attribute3) res_attribute3, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE4',br.rowid,br.attribute4) res_attribute4, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE5',br.rowid,br.attribute5) res_attribute5, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE6',br.rowid,br.attribute6) res_attribute6, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE7',br.rowid,br.attribute7) res_attribute7, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE8',br.rowid,br.attribute8) res_attribute8, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE9',br.rowid,br.attribute9) res_attribute9, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE10',br.rowid,br.attribute10) res_attribute10, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE11',br.rowid,br.attribute11) res_attribute11, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE12',br.rowid,br.attribute12) res_attribute12, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE13',br.rowid,br.attribute13) res_attribute13, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE14',br.rowid,br.attribute14) res_attribute14, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE15',br.rowid,br.attribute15) res_attribute15, to_number(null) upload_row from mtl_parameters mp, bom_resources br, mtl_item_locations_kfv milk, mtl_system_items_vl msiv_p, mtl_system_items_vl msiv_b, cst_activities ca, gl_code_combinations_kfv gcck_a, gl_code_combinations_kfv gcck_v, per_competences pc, per_qualification_types pqt 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=br.organization_id and br.cost_code_type in (3,4) and br.supply_locator_id=milk.inventory_location_id(+) and br.organization_id=milk.organization_id(+) and br.purchase_item_id=msiv_p.inventory_item_id(+) and br.organization_id=msiv_p.organization_id(+) and br.billable_item_id=msiv_b.inventory_item_id(+) and br.organization_id=msiv_b.organization_id(+) and br.default_activity_id=ca.activity_id(+) and br.absorption_account=gcck_a.code_combination_id(+) and br.rate_variance_account=gcck_v.code_combination_id(+) and br.competence_id=pc.competence_id(+) and br.qualification_type_id=pqt.qualification_type_id(+) Initial version. Creates and updates resources through the table handler of the Resources form (BOMFDORS). U A xxen_bom_upload.upload_resource US BOM Resource Upload Creates and updates resources - the Resources form (Bills of Material > Routings > Resources). Resources cannot be deleted; enter an Inactive On date instead. Their rates and overhead associations per cost type are maintained with the CST Resource Rate Upload and the CST Resource Overhead Association Upload. As in the form, Outside Processing defaults from a PO charge type and Costed from Outside Processing, and an outside processing resource takes the receiving inspection account of the organization as Absorption Account and its purchase price variance account as Variance Account. Outside Processing and Costed cannot be changed once the resource is used in routings, overheads, WIP or (Costed) has rates, and the UOM only with profile BOM: Update Resource UOM for resources not scheduled in routings or used in standard operations. Supply Subinventory and Supply Locator apply to machines, Competence, Skill Level and Qualification to persons, Billable Item to types other than Amount. A currency resource takes the functional currency as UOM and is always costed. A batchable resource has basis Lot. 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 resources. 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 resources. Also the default Organization Code of new rows. 3 30 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 4 40 1=1 decode(br.functional_currency_flag,1,6,br.resource_type)=:resource_type LOV custom select to_char(ml.lookup_code) id, ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='BOM_RESOURCE_TYPE' and ml.enabled_flag='Y' and trunc(sysdate) between nvl(ml.start_date_active,trunc(sysdate)) and nvl(ml.end_date_active,trunc(sysdate)) union all select '6' id, fnd_message.get_string('FND','CURRENCY') value, null description from dual order by 1 US Resource Type 5 50 1=1 br.cost_code_type=decode(:outside_processing,'Y',4,3) LOV Oracle Yes_No select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description US Outside Processing 6 60 1=1 nvl(br.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 resources with an Inactive On date that has passed. 41508DDDFB88446BAA63DFF108693D09 Costing The costing setup of resources: outside processing, costed, activity, standard rate and accounts. ANDY.HAACK 10 ABSORPTION_ACCOUNT 8 ACTIVITY 5 CHARGE_TYPE 7 COSTED 3 DESCRIPTION Y 1 ORGANIZATION_CODE 6 OUTSIDE_PROCESSING 2 RESOURCE_CODE 4 RESOURCE_TYPE 9 STANDARD_RATE 11 VARIANCE_ACCOUNT Upload Mode C,U S Site 1B11053DE01749ACB1FBF215293C9903 Create An empty sheet to enter new resources. ANDY.HAACK 20 ABSORPTION_ACCOUNT 18 ACTIVITY 8 BASIS 25 BATCHABLE 29 BATCHING_WINDOW 30 BATCHING_WINDOW_UOM 28 BATCH_CAPACITY_UOM 15 BILLABLE_ITEM 16 BILLABLE_ITEM_DESCRIPTION 7 CHARGE_TYPE 22 COMPETENCE 17 COSTED 4 DESCRIPTION 9 EXPENDITURE_TYPE 3 INACTIVE_ON Y 27 MAXIMUM_BATCH_CAPACITY 26 MINIMUM_BATCH_CAPACITY 1 ORGANIZATION_CODE 12 OUTSIDE_PROCESSING 13 OUTSIDE_PROCESSING_ITEM 14 OUTSIDE_PROCESSING_ITEM_DESC 24 QUALIFICATION 2 RESOURCE_CODE 5 RESOURCE_TYPE 23 SKILL_LEVEL 19 STANDARD_RATE 11 SUPPLY_LOCATOR 10 SUPPLY_SUBINVENTORY 6 UOM 21 VARIANCE_ACCOUNT Upload Mode C Y S Site Active only Outside Processing Resource Resource Type 669CD011DF384AB5A395D32C937F1AB7 Default Resources without the descriptive flexfield attributes. ANDY.HAACK 20 ABSORPTION_ACCOUNT 18 ACTIVITY 8 BASIS 25 BATCHABLE 29 BATCHING_WINDOW 30 BATCHING_WINDOW_UOM 28 BATCH_CAPACITY_UOM 15 BILLABLE_ITEM 16 BILLABLE_ITEM_DESCRIPTION 7 CHARGE_TYPE 22 COMPETENCE 17 COSTED 4 DESCRIPTION 9 EXPENDITURE_TYPE 3 INACTIVE_ON Y 27 MAXIMUM_BATCH_CAPACITY 26 MINIMUM_BATCH_CAPACITY 1 ORGANIZATION_CODE 12 OUTSIDE_PROCESSING 13 OUTSIDE_PROCESSING_ITEM 14 OUTSIDE_PROCESSING_ITEM_DESC 24 QUALIFICATION 2 RESOURCE_CODE 5 RESOURCE_TYPE 23 SKILL_LEVEL 19 STANDARD_RATE 11 SUPPLY_LOCATOR 10 SUPPLY_SUBINVENTORY 6 UOM 21 VARIANCE_ACCOUNT Upload Mode C,U S Site C19226EA02404EDABAD2D5824205463D Flexfields The descriptive flexfield attributes of resources. ANDY.HAACK 3 DESCRIPTION Y 1 ORGANIZATION_CODE 2 RESOURCE_CODE 5 RES_ATTRIBUTE1 14 RES_ATTRIBUTE10 15 RES_ATTRIBUTE11 16 RES_ATTRIBUTE12 17 RES_ATTRIBUTE13 18 RES_ATTRIBUTE14 19 RES_ATTRIBUTE15 6 RES_ATTRIBUTE2 7 RES_ATTRIBUTE3 8 RES_ATTRIBUTE4 9 RES_ATTRIBUTE5 10 RES_ATTRIBUTE6 11 RES_ATTRIBUTE7 12 RES_ATTRIBUTE8 13 RES_ATTRIBUTE9 4 RES_ATTRIBUTE_CATEGORY Upload Mode C,U S Site 669CD011DF384AB5A395D32C937F1AB7 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 RESOURCE_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 RESOURCE_CODE LOV custom varchar2 Y select 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) order by br.resource_code Y 8 INACTIVE_ON Date date 9 DESCRIPTION Char varchar2 10 RESOURCE_TYPE LOV custom varchar2 select to_char(ml.lookup_code) id, ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='BOM_RESOURCE_TYPE' and ml.enabled_flag='Y' and trunc(sysdate) between nvl(ml.start_date_active,trunc(sysdate)) and nvl(ml.end_date_active,trunc(sysdate)) union all select '6' id, fnd_message.get_string('FND','CURRENCY') value, null description from dual order by 1 xxen_util.meaning('2','BOM_RESOURCE_TYPE',700) Y 11 UOM LOV custom varchar2 select muomv.uom_code value, muomv.unit_of_measure_tl description from mtl_units_of_measure_vl muomv where nvl(:$column$.resource_type,'x')<>fnd_message.get_string('FND','CURRENCY') and nvl(muomv.disable_date,sysdate+1)>sysdate union all select bom_resources_pkg.get_uom_from_gl_sets_of_books(mp.organization_id) value, null description from mtl_parameters mp where mp.organization_code=:$column$.organization_code and :$column$.resource_type=fnd_message.get_string('FND','CURRENCY') order by 1 select bom_resources_pkg.get_uom_from_gl_sets_of_books(mp.organization_id) from mtl_parameters mp where mp.organization_code=:$column$.organization_code and :$column$.resource_type=fnd_message.get_string('FND','CURRENCY') Y 12 CHARGE_TYPE LOV custom varchar2 select to_char(ml.lookup_code) id, ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='BOM_AUTOCHARGE_TYPE' and ml.enabled_flag='Y' and trunc(sysdate) between nvl(ml.start_date_active,trunc(sysdate)) and nvl(ml.end_date_active,trunc(sysdate)) order by ml.lookup_code Y 13 BASIS LOV custom varchar2 select to_char(ml.lookup_code) id, ml.meaning value, ml.description from mfg_lookups ml where ml.lookup_type='BOM_BASIS_TYPE' and ml.enabled_flag='Y' and trunc(sysdate) between nvl(ml.start_date_active,trunc(sysdate)) and nvl(ml.end_date_active,trunc(sysdate)) order by ml.lookup_code xxen_util.meaning(decode(:$column$.batchable,xxen_util.meaning('1','SYS_YES_NO',700),'2','1'),'BOM_BASIS_TYPE',700) 14 EXPENDITURE_TYPE LOV custom varchar2 select cpetvv.expenditure_type value, cpetvv.description from mtl_parameters mp, cst_proj_exp_types_val_v cpetvv where mp.organization_code=:$column$.organization_code and mp.pm_cost_collection_enabled=1 and mp.project_reference_enabled=1 and cpetvv.cost_element_id=decode(:$column$.outside_processing,null,3,4) and trunc(sysdate) between cpetvv.sys_link_start_date and nvl(cpetvv.sys_link_end_date,trunc(sysdate)) and trunc(sysdate) between cpetvv.exp_type_start_date and nvl(cpetvv.exp_type_end_date,trunc(sysdate)) order by cpetvv.expenditure_type Required in organizations with project cost collection and project references enabled, and not available in other organizations. 15 SUPPLY_SUBINVENTORY LOV custom varchar2 select msatvv.secondary_inventory_name value, msatvv.description from mtl_parameters mp, mtl_sub_ast_trk_val_v msatvv where mp.organization_code=:$column$.organization_code and mp.organization_id=msatvv.organization_id and :$column$.resource_type=xxen_util.meaning('1','BOM_RESOURCE_TYPE',700) order by msatvv.secondary_inventory_name Machines only. 16 SUPPLY_LOCATOR LOV custom varchar2 select milk.inventory_location_id id, milk.concatenated_segments value, milk.description from mtl_parameters mp, mtl_item_locations_kfv milk where mp.organization_code=:$column$.organization_code and mp.organization_id=milk.organization_id and milk.subinventory_code=:$column$.supply_subinventory and nvl(milk.disable_date,sysdate+1)>sysdate order by milk.concatenated_segments select milk.inventory_location_id id, milk.concatenated_segments value from mtl_parameters mp, mtl_item_locations_kfv milk where mp.organization_code=:$column$.organization_code and mp.organization_id=milk.organization_id and milk.subinventory_code=:$column$.supply_subinventory 17 OUTSIDE_PROCESSING LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_util.meaning('Y','YES_NO',0) from dual where :$column$.charge_type in (xxen_util.meaning('3','BOM_AUTOCHARGE_TYPE',700),xxen_util.meaning('4','BOM_AUTOCHARGE_TYPE',700)) 18 OUTSIDE_PROCESSING_ITEM LOV custom varchar2 select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.outside_operation_flag='Y' order by msiv.concatenated_segments select msiv.inventory_item_id id, msiv.concatenated_segments value from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id 19 OUTSIDE_PROCESSING_ITEM_DESC Char varchar2 select msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.outside_processing_item Y 20 BILLABLE_ITEM LOV custom varchar2 select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.material_billable_flag in (select cbtc.billing_type from cs_billing_type_categories cbtc where cbtc.billing_category='L') and nvl(:$column$.resource_type,'x')<>xxen_util.meaning('5','BOM_RESOURCE_TYPE',700) order by msiv.concatenated_segments select msiv.inventory_item_id id, msiv.concatenated_segments value from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id Labor items. Not available for resources of type Amount. 21 BILLABLE_ITEM_DESCRIPTION Char varchar2 select msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.billable_item Y 22 COSTED 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$.outside_processing is not null or :$column$.resource_type=fnd_message.get_string('FND','CURRENCY') 23 ACTIVITY LOV custom varchar2 select ca.activity_id id, ca.activity value, ca.description from mtl_parameters mp, cst_activities ca where mp.organization_code=:$column$.organization_code and (ca.organization_id=mp.organization_id or ca.organization_id is null) and nvl(ca.disable_date,sysdate+1)>sysdate order by ca.activity select ca.activity_id id, ca.activity value from mtl_parameters mp, cst_activities ca where mp.organization_code=:$column$.organization_code and (ca.organization_id=mp.organization_id or ca.organization_id is null) 24 STANDARD_RATE 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) 25 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.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 select gcck.concatenated_segments from mtl_parameters mp, rcv_parameters rp, gl_code_combinations_kfv gcck where mp.organization_code=:$column$.organization_code and mp.organization_id=rp.organization_id and rp.receiving_account_id=gcck.code_combination_id and :$column$.outside_processing is not null 26 VARIANCE_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.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 select gcck.concatenated_segments from mtl_parameters mp, gl_code_combinations_kfv gcck where mp.organization_code=:$column$.organization_code and mp.purchase_price_var_account=gcck.code_combination_id and :$column$.outside_processing is not null 27 COMPETENCE LOV custom varchar2 select pc.competence_id id, pc.name value, pc.description from hr_all_organization_units haou, mtl_parameters mp, per_competences pc where mp.organization_code=:$column$.organization_code and mp.organization_id=haou.organization_id and (pc.business_group_id=haou.business_group_id or pc.business_group_id is null) and trunc(sysdate) between nvl(pc.date_from,trunc(sysdate)) and nvl(pc.date_to,trunc(sysdate)) and nvl(:$column$.resource_type,'x')=xxen_util.meaning('2','BOM_RESOURCE_TYPE',700) order by pc.name select pc.competence_id id, pc.name value from hr_all_organization_units haou, mtl_parameters mp, per_competences pc where mp.organization_code=:$column$.organization_code and mp.organization_id=haou.organization_id and (pc.business_group_id=haou.business_group_id or pc.business_group_id is null) Persons only. 28 SKILL_LEVEL LOV custom varchar2 select prl.rating_level_id id, to_char(prl.step_value)||'-'||prl.name value, prl.behavioural_indicator description from hr_all_organization_units haou, mtl_parameters mp, per_competences pc, per_rating_levels prl where mp.organization_code=:$column$.organization_code and mp.organization_id=haou.organization_id and (pc.business_group_id=haou.business_group_id or pc.business_group_id is null) and pc.name=:$column$.competence and (prl.business_group_id=haou.business_group_id or prl.business_group_id is null) and (prl.rating_scale_id=pc.rating_scale_id or prl.competence_id=pc.competence_id) order by prl.step_value Rating levels of the competence. 29 QUALIFICATION LOV custom varchar2 select pqt.qualification_type_id id, pqt.name value, null description from per_qualification_types pqt where nvl(:$column$.resource_type,'x')=xxen_util.meaning('2','BOM_RESOURCE_TYPE',700) order by pqt.name select pqt.qualification_type_id id, pqt.name value from per_qualification_types pqt Persons only. 30 BATCHABLE 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) 31 MINIMUM_BATCH_CAPACITY Number number 32 MAXIMUM_BATCH_CAPACITY Number number 33 BATCH_CAPACITY_UOM LOV custom varchar2 select muomv.uom_code value, muomv.unit_of_measure_tl description from mtl_units_of_measure_vl muomv where nvl(muomv.disable_date,sysdate+1)>sysdate order by muomv.uom_code 34 BATCHING_WINDOW Number number 35 BATCHING_WINDOW_UOM LOV custom varchar2 select muomv.uom_code value, muomv.unit_of_measure_tl description from mtl_units_of_measure_vl muomv where muomv.uom_class=fnd_profile.value('BOM:TIME_UOM_CLASS') and nvl(muomv.disable_date,sysdate+1)>sysdate order by muomv.uom_code 36 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_RESOURCES' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 37 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_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_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' 38 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_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_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' 39 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_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_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' 40 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_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_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' 41 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_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_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' 42 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_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_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' 43 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_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_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' 44 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_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_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' 45 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_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_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' 46 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_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_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' 47 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_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_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' 48 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_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_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' 49 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_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_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' 50 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_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_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' 51 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_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_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' 52 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_resource_id in Number Y RESOURCE_ID U 5 p_resource_id_out out Number RESOURCE_ID U 6 p_organization_id in Number ORGANIZATION_CODE U 7 p_resource_code in Char RESOURCE_CODE U 8 p_disable_date in Date Y INACTIVE_ON U 9 p_description in Char Y DESCRIPTION U 10 p_resource_type in Number Y RESOURCE_TYPE U 11 p_unit_of_measure in Char Y UOM U 12 p_autocharge_type in Number Y CHARGE_TYPE U 13 p_default_basis_type in Number Y BASIS U 14 p_expenditure_type in Char Y EXPENDITURE_TYPE U 15 p_supply_subinventory in Char Y SUPPLY_SUBINVENTORY U 16 p_supply_locator_id in Number Y SUPPLY_LOCATOR U 17 p_outside_processing in Char Y OUTSIDE_PROCESSING U 18 p_purchase_item_id in Number Y OUTSIDE_PROCESSING_ITEM U 19 p_billable_item_id in Number Y BILLABLE_ITEM U 20 p_allow_costs_flag in Number Y COSTED U 21 p_default_activity_id in Number Y ACTIVITY U 22 p_standard_rate_flag in Number Y STANDARD_RATE U 23 p_absorption_account in Number Y ABSORPTION_ACCOUNT U 24 p_rate_variance_account in Number Y VARIANCE_ACCOUNT U 25 p_competence_id in Number Y COMPETENCE U 26 p_rating_level_id in Number Y SKILL_LEVEL U 27 p_qualification_type_id in Number Y QUALIFICATION U 28 p_batchable in Number Y BATCHABLE U 29 p_min_batch_capacity in Number Y MINIMUM_BATCH_CAPACITY U 30 p_max_batch_capacity in Number Y MAXIMUM_BATCH_CAPACITY U 31 p_batch_capacity_uom in Char Y BATCH_CAPACITY_UOM U 32 p_batch_window in Number Y BATCHING_WINDOW U 33 p_batch_window_uom in Char Y BATCHING_WINDOW_UOM U 34 p_res_attribute_category in Char Y RES_ATTRIBUTE_CATEGORY U 35 p_res_attribute1 in Char Y RES_ATTRIBUTE1 U 36 p_res_attribute2 in Char Y RES_ATTRIBUTE2 U 37 p_res_attribute3 in Char Y RES_ATTRIBUTE3 U 38 p_res_attribute4 in Char Y RES_ATTRIBUTE4 U 39 p_res_attribute5 in Char Y RES_ATTRIBUTE5 U 40 p_res_attribute6 in Char Y RES_ATTRIBUTE6 U 41 p_res_attribute7 in Char Y RES_ATTRIBUTE7 U 42 p_res_attribute8 in Char Y RES_ATTRIBUTE8 U 43 p_res_attribute9 in Char Y RES_ATTRIBUTE9 U 44 p_res_attribute10 in Char Y RES_ATTRIBUTE10 U 45 p_res_attribute11 in Char Y RES_ATTRIBUTE11 U 46 p_res_attribute12 in Char Y RES_ATTRIBUTE12 U 47 p_res_attribute13 in Char Y RES_ATTRIBUTE13 U 48 p_res_attribute14 in Char Y RES_ATTRIBUTE14 U 49 p_res_attribute15 in Char Y RES_ATTRIBUTE15 Error SQL Order By upload_row, organization_code, resource_code Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.resource_id, mp.organization_code, br.resource_code, br.disable_date inactive_on, br.description, decode(br.functional_currency_flag,1,fnd_message.get_string('FND','CURRENCY'),xxen_util.meaning(br.resource_type,'BOM_RESOURCE_TYPE',700)) resource_type, br.unit_of_measure uom, xxen_util.meaning(br.autocharge_type,'BOM_AUTOCHARGE_TYPE',700) charge_type, xxen_util.meaning(br.default_basis_type,'BOM_BASIS_TYPE',700) basis, br.expenditure_type, br.supply_subinventory, milk.concatenated_segments supply_locator, xxen_util.yes(decode(br.cost_code_type,4,'Y')) outside_processing, msiv_p.concatenated_segments outside_processing_item, msiv_p.description outside_processing_item_desc, msiv_b.concatenated_segments billable_item, msiv_b.description billable_item_description, decode(br.allow_costs_flag,1,xxen_util.meaning('1','SYS_YES_NO',700)) costed, ca.activity, decode(br.standard_rate_flag,1,xxen_util.meaning('1','SYS_YES_NO',700)) standard_rate, gcck_a.concatenated_segments absorption_account, gcck_v.concatenated_segments variance_account, pc.name competence, (select to_char(prl.step_value)||'-'||prl.name from per_rating_levels prl where br.rating_level_id=prl.rating_level_id) skill_level, pqt.name qualification, decode(br.batchable,1,xxen_util.meaning('1','SYS_YES_NO',700)) batchable, br.min_batch_capacity minimum_batch_capacity, br.max_batch_capacity maximum_batch_capacity, br.batch_capacity_uom, br.batch_window batching_window, br.batch_window_uom batching_window_uom, xxen_util.display_flexfield_context(702,'BOM_RESOURCES',br.attribute_category) res_attribute_category, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE1',br.rowid,br.attribute1) res_attribute1, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE2',br.rowid,br.attribute2) res_attribute2, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE3',br.rowid,br.attribute3) res_attribute3, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE4',br.rowid,br.attribute4) res_attribute4, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE5',br.rowid,br.attribute5) res_attribute5, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE6',br.rowid,br.attribute6) res_attribute6, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE7',br.rowid,br.attribute7) res_attribute7, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE8',br.rowid,br.attribute8) res_attribute8, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE9',br.rowid,br.attribute9) res_attribute9, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE10',br.rowid,br.attribute10) res_attribute10, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE11',br.rowid,br.attribute11) res_attribute11, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE12',br.rowid,br.attribute12) res_attribute12, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE13',br.rowid,br.attribute13) res_attribute13, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE14',br.rowid,br.attribute14) res_attribute14, xxen_util.display_flexfield_value(702,'BOM_RESOURCES',br.attribute_category,'ATTRIBUTE15',br.rowid,br.attribute15) res_attribute15, xu.upload_row from xxen_bom_resource_uploa_0489_u xu, bom_resources br, mtl_parameters mp, mtl_item_locations_kfv milk, mtl_system_items_vl msiv_p, mtl_system_items_vl msiv_b, cst_activities ca, gl_code_combinations_kfv gcck_a, gl_code_combinations_kfv gcck_v, per_competences pc, per_qualification_types pqt where xu.status_code_=xxen_upload.status_success and xu.resource_id=br.resource_id and br.organization_id=mp.organization_id and br.supply_locator_id=milk.inventory_location_id(+) and br.organization_id=milk.organization_id(+) and br.purchase_item_id=msiv_p.inventory_item_id(+) and br.organization_id=msiv_p.organization_id(+) and br.billable_item_id=msiv_b.inventory_item_id(+) and br.organization_id=msiv_b.organization_id(+) and br.default_activity_id=ca.activity_id(+) and br.absorption_account=gcck_a.code_combination_id(+) and br.rate_variance_account=gcck_v.code_combination_id(+) and br.competence_id=pc.competence_id(+) and br.qualification_type_id=pqt.qualification_type_id(+)