ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 0CAB74FD86BE4AD686D95F306B204611Y select null action_, null status_, null message_, null modified_columns_, eri.revised_item_sequence_id revised_item_seq_id, bcb.component_sequence_id component_seq_id, mp.organization_code, eec.change_notice eco, ecotv.change_order_type eco_type, ecsv.status_name eco_status, xxen_eng_upload.requestor(eec.requestor_id) requestor, haouv.name eco_department, eec.reason_code reason, eec.priority_code priority, xxen_util.meaning(eec.approval_status_type,'ENG_ECN_APPROVAL_STATUS',700) approval_status, eec.description eco_description, eec.estimated_eng_cost engineering_cost, eec.estimated_mfg_cost manufacturing_cost, xxen_util.display_flexfield_context(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category) eco_attribute_category, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE1',eec.rowid,eec.attribute1) eco_attribute1, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE2',eec.rowid,eec.attribute2) eco_attribute2, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE3',eec.rowid,eec.attribute3) eco_attribute3, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE4',eec.rowid,eec.attribute4) eco_attribute4, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE5',eec.rowid,eec.attribute5) eco_attribute5, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE6',eec.rowid,eec.attribute6) eco_attribute6, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE7',eec.rowid,eec.attribute7) eco_attribute7, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE8',eec.rowid,eec.attribute8) eco_attribute8, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE9',eec.rowid,eec.attribute9) eco_attribute9, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE10',eec.rowid,eec.attribute10) eco_attribute10, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE11',eec.rowid,eec.attribute11) eco_attribute11, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE12',eec.rowid,eec.attribute12) eco_attribute12, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE13',eec.rowid,eec.attribute13) eco_attribute13, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE14',eec.rowid,eec.attribute14) eco_attribute14, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE15',eec.rowid,eec.attribute15) eco_attribute15, msiv.concatenated_segments revised_item, msiv.description revised_item_description, eri.alternate_bom_designator alternate, eri.new_item_revision, mirv.description item_revision_description, eri.new_routing_revision, eri.scheduled_date effective_date, xxen_util.meaning(eri.status_type,'ECG_ECN_STATUS',700) revised_item_status, decode(eri.mrp_active,1,xxen_util.meaning('1','SYS_YES_NO',700)) mrp_active, eri.early_schedule_date early_effective_date, eri.implementation_date implemented_date, decode(eri.update_wip,1,xxen_util.meaning('1','SYS_YES_NO',700)) update_jobs, xxen_util.meaning(eri.disposition_type,'ECG_MATERIAL_DISPOSITION',700) disposition, eri.descriptive_text change_description, xxen_util.display_flexfield_context(703,'ENG_REVISED_ITEMS',eri.attribute_category) ri_attribute_category, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE1',eri.rowid,eri.attribute1) ri_attribute1, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE2',eri.rowid,eri.attribute2) ri_attribute2, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE3',eri.rowid,eri.attribute3) ri_attribute3, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE4',eri.rowid,eri.attribute4) ri_attribute4, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE5',eri.rowid,eri.attribute5) ri_attribute5, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE6',eri.rowid,eri.attribute6) ri_attribute6, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE7',eri.rowid,eri.attribute7) ri_attribute7, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE8',eri.rowid,eri.attribute8) ri_attribute8, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE9',eri.rowid,eri.attribute9) ri_attribute9, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE10',eri.rowid,eri.attribute10) ri_attribute10, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE11',eri.rowid,eri.attribute11) ri_attribute11, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE12',eri.rowid,eri.attribute12) ri_attribute12, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE13',eri.rowid,eri.attribute13) ri_attribute13, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE14',eri.rowid,eri.attribute14) ri_attribute14, xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE15',eri.rowid,eri.attribute15) ri_attribute15, xxen_util.meaning(bcb.acd_type,'ECG_ACTION',700) component_action, (select msiv_c.concatenated_segments from mtl_system_items_vl msiv_c where bcb.component_item_id=msiv_c.inventory_item_id and eri.organization_id=msiv_c.organization_id) component, (select msiv_c.description from mtl_system_items_vl msiv_c where bcb.component_item_id=msiv_c.inventory_item_id and eri.organization_id=msiv_c.organization_id) component_description, decode(bcb.acd_type,1,to_number(null),bcb_old.operation_seq_num) old_operation_seq, bcb.operation_seq_num operation_seq, bcb.item_num item_seq, xxen_util.meaning(bcb.basis_type,'BOM_BASIS_TYPE',700) basis, bcb.component_quantity quantity, bcb.disable_date, bcb.planning_factor planning_percent, bcb.component_yield_factor yield, xxen_util.meaning(bcb.enforce_int_requirements,'BOM_ENFORCE_INT_REQUIREMENTS',700) enforce_int_requirements, decode(bcb.include_in_cost_rollup,1,xxen_util.meaning('1','SYS_YES_NO',700)) include_in_cost_rollup, xxen_util.meaning(bcb.wip_supply_type,'WIP_SUPPLY',700) supply_type, bcb.supply_subinventory, decode(bcb.check_atp,1,xxen_util.meaning('1','SYS_YES_NO',700)) check_atp, decode(bcb.optional,1,xxen_util.meaning('1','SYS_YES_NO',700)) optional, decode(bcb.mutually_exclusive_options,1,xxen_util.meaning('1','SYS_YES_NO',700)) mutually_exclusive, bcb.low_quantity minimum_quantity, bcb.high_quantity maximum_quantity, decode(bcb.include_on_ship_docs,1,xxen_util.meaning('1','SYS_YES_NO',700)) include_on_ship_docs, decode(bcb.required_to_ship,1,xxen_util.meaning('1','SYS_YES_NO',700)) required_to_ship, decode(bcb.required_for_revenue,1,xxen_util.meaning('1','SYS_YES_NO',700)) required_for_revenue, bcb.component_remarks component_comments, null delete_component, xxen_util.display_flexfield_context(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category) comp_attribute_category, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE1',bcb.rowid,bcb.attribute1) comp_attribute1, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE2',bcb.rowid,bcb.attribute2) comp_attribute2, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE3',bcb.rowid,bcb.attribute3) comp_attribute3, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE4',bcb.rowid,bcb.attribute4) comp_attribute4, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE5',bcb.rowid,bcb.attribute5) comp_attribute5, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE6',bcb.rowid,bcb.attribute6) comp_attribute6, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE7',bcb.rowid,bcb.attribute7) comp_attribute7, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE8',bcb.rowid,bcb.attribute8) comp_attribute8, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE9',bcb.rowid,bcb.attribute9) comp_attribute9, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE10',bcb.rowid,bcb.attribute10) comp_attribute10, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE11',bcb.rowid,bcb.attribute11) comp_attribute11, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE12',bcb.rowid,bcb.attribute12) comp_attribute12, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE13',bcb.rowid,bcb.attribute13) comp_attribute13, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE14',bcb.rowid,bcb.attribute14) comp_attribute14, xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE15',bcb.rowid,bcb.attribute15) comp_attribute15, to_number(null) upload_row from mtl_parameters mp, eng_engineering_changes eec, eng_change_order_types_vl ecotv, eng_change_statuses_vl ecsv, hr_all_organization_units_vl haouv, (select eri.* from eng_revised_items eri where eri.transfer_or_copy in ('L','O') or eri.transfer_or_copy is null) eri, mtl_system_items_vl msiv, mtl_item_revisions_vl mirv, bom_components_b bcb, bom_components_b bcb_old 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=eec.organization_id and eec.change_order_type_id=ecotv.change_order_type_id and ecotv.base_change_mgmt_type_code='CHANGE_ORDER' and eec.status_type=ecsv.status_code(+) and eec.responsible_organization_id=haouv.organization_id(+) and eec.change_notice=eri.change_notice(+) and eec.organization_id=eri.organization_id(+) and eri.revised_item_id=msiv.inventory_item_id(+) and eri.organization_id=msiv.organization_id(+) and eri.new_item_revision_id=mirv.revision_id(+) and eri.revised_item_sequence_id=bcb.revised_item_sequence_id(+) and bcb.old_component_sequence_id=bcb_old.component_sequence_id(+) Initial version. Creates and updates engineering change orders with their revised items and revised components through the engineering change order business object api (eng_eco_pub.process_eco), as the Engineering Change Orders form (ENGFDECN) does. U A xxen_eng_upload.upload_eco US ENG Engineering Change Order Upload Creates and updates engineering change orders (ECOs) with their revised items and revised components - the Engineering Change Orders form (Engineering > ECOs > ECOs). Each row holds one ECO, optionally one of its revised items and one revised component of that revised item. The ECO and revised item columns repeat on every row, and a change in any of these rows is applied. A new ECO is created with status Open. A revised item is identified by item and alternate. An Effective Date in the past is moved to the current date, as in the form. Changing the Effective Date of an existing revised item reschedules it with its revised components, and changing New Item Revision renames the new revision. Revised items are not deleted; set their status to Cancelled instead. Component Action Add adds a component to the bill. Change and Disable refer to the implemented component of the revised item's bill at Old Operation Seq (or Operation Seq when Old Operation Seq is blank) effective at the revised item's effective date; for Change enter only the values that change. Delete Component removes a pending revised component from the ECO. Approval, implementation, substitute components, reference designators and revised operations are maintained in the form. 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 ECOs with their revised items and revised components. 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') Y US Organization Code Inventory organization of the ECOs. Also the default Organization Code of new rows. 3 30 1=1 eec.change_notice=:eco LOV custom select eec.change_notice value, eec.description from mtl_parameters mp, eng_engineering_changes eec, eng_change_order_types_vl ecotv where mp.organization_code=:$flex$.organization_code and mp.organization_id=eec.organization_id and eec.change_order_type_id=ecotv.change_order_type_id and ecotv.base_change_mgmt_type_code='CHANGE_ORDER' order by eec.change_notice US ECO 4 40 1=1 ecotv.change_order_type=:eco_type LOV custom select ecotv.change_order_type value, ecotv.description from eng_change_order_types_vl ecotv where ecotv.change_mgmt_type_code='CHANGE_ORDER' and ecotv.type_classification='HEADER' order by ecotv.change_order_type US ECO Type 5 50 1=1 msiv.concatenated_segments=:revised_item LOV custom select distinct msiv.concatenated_segments value, msiv.description from mtl_parameters mp, eng_revised_items eri, mtl_system_items_vl msiv where mp.organization_code=:$flex$.organization_code and mp.organization_id=eri.organization_id and eri.revised_item_id=msiv.inventory_item_id and eri.organization_id=msiv.organization_id order by msiv.concatenated_segments US Revised Item Downloads only the ECOs that revise this item, with this revised item only. 6 60 1=1 eec.status_type not in (5,6) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Pending only Yes excludes implemented and cancelled ECOs. 410FB397A21543A59331156FBD2477CA Create An empty sheet to enter new ECOs, revised items and revised components. ENGINATICS 14 ALTERNATE 8 APPROVAL_STATUS 31 BASIS 24 CHANGE_DESCRIPTION 40 CHECK_ATP 26 COMPONENT 25 COMPONENT_ACTION 48 COMPONENT_COMMENTS 27 COMPONENT_DESCRIPTION 33 DISABLE_DATE 23 DISPOSITION 21 EARLY_EFFECTIVE_DATE 2 ECO 5 ECO_DEPARTMENT 9 ECO_DESCRIPTION 3 ECO_TYPE Y 18 EFFECTIVE_DATE 36 ENFORCE_INT_REQUIREMENTS 10 ENGINEERING_COST 37 INCLUDE_IN_COST_ROLLUP 45 INCLUDE_ON_SHIP_DOCS 16 ITEM_REVISION_DESCRIPTION 30 ITEM_SEQ 11 MANUFACTURING_COST 44 MAXIMUM_QUANTITY 43 MINIMUM_QUANTITY 20 MRP_ACTIVE 42 MUTUALLY_EXCLUSIVE 15 NEW_ITEM_REVISION 17 NEW_ROUTING_REVISION 28 OLD_OPERATION_SEQ 29 OPERATION_SEQ 41 OPTIONAL 1 ORGANIZATION_CODE 34 PLANNING_PERCENT 7 PRIORITY 32 QUANTITY 6 REASON 4 REQUESTOR 47 REQUIRED_FOR_REVENUE 46 REQUIRED_TO_SHIP 12 REVISED_ITEM 13 REVISED_ITEM_DESCRIPTION 19 REVISED_ITEM_STATUS 39 SUPPLY_SUBINVENTORY 38 SUPPLY_TYPE 22 UPDATE_JOBS 35 YIELD Upload Mode C Y S Site ECO ECO Type Pending only Revised Item E66D61C474A24C8EB99820E7DB0BDA0D Default ECOs with their revised items and revised components without the descriptive flexfield attributes. ENGINATICS 15 ALTERNATE 9 APPROVAL_STATUS 33 BASIS 26 CHANGE_DESCRIPTION 42 CHECK_ATP 28 COMPONENT 27 COMPONENT_ACTION 50 COMPONENT_COMMENTS 29 COMPONENT_DESCRIPTION 51 DELETE_COMPONENT 35 DISABLE_DATE 25 DISPOSITION 22 EARLY_EFFECTIVE_DATE 2 ECO 6 ECO_DEPARTMENT 10 ECO_DESCRIPTION 4 ECO_STATUS 3 ECO_TYPE Y 19 EFFECTIVE_DATE 38 ENFORCE_INT_REQUIREMENTS 11 ENGINEERING_COST 23 IMPLEMENTED_DATE 39 INCLUDE_IN_COST_ROLLUP 47 INCLUDE_ON_SHIP_DOCS 17 ITEM_REVISION_DESCRIPTION 32 ITEM_SEQ 12 MANUFACTURING_COST 46 MAXIMUM_QUANTITY 45 MINIMUM_QUANTITY 21 MRP_ACTIVE 44 MUTUALLY_EXCLUSIVE 16 NEW_ITEM_REVISION 18 NEW_ROUTING_REVISION 30 OLD_OPERATION_SEQ 31 OPERATION_SEQ 43 OPTIONAL 1 ORGANIZATION_CODE 36 PLANNING_PERCENT 8 PRIORITY 34 QUANTITY 7 REASON 5 REQUESTOR 49 REQUIRED_FOR_REVENUE 48 REQUIRED_TO_SHIP 13 REVISED_ITEM 14 REVISED_ITEM_DESCRIPTION 20 REVISED_ITEM_STATUS 41 SUPPLY_SUBINVENTORY 40 SUPPLY_TYPE 24 UPDATE_JOBS 37 YIELD Upload Mode C,U S Site 082C6C8AEBD14AADAD239687480715B5 Flexfields The descriptive flexfield attributes of ECOs, revised items and revised components. ENGINATICS 4 ALTERNATE 6 COMPONENT 5 COMPONENT_ACTION 41 COMP_ATTRIBUTE1 50 COMP_ATTRIBUTE10 51 COMP_ATTRIBUTE11 52 COMP_ATTRIBUTE12 53 COMP_ATTRIBUTE13 54 COMP_ATTRIBUTE14 55 COMP_ATTRIBUTE15 42 COMP_ATTRIBUTE2 43 COMP_ATTRIBUTE3 44 COMP_ATTRIBUTE4 45 COMP_ATTRIBUTE5 46 COMP_ATTRIBUTE6 47 COMP_ATTRIBUTE7 48 COMP_ATTRIBUTE8 49 COMP_ATTRIBUTE9 40 COMP_ATTRIBUTE_CATEGORY 2 ECO 9 ECO_ATTRIBUTE1 18 ECO_ATTRIBUTE10 19 ECO_ATTRIBUTE11 20 ECO_ATTRIBUTE12 21 ECO_ATTRIBUTE13 22 ECO_ATTRIBUTE14 23 ECO_ATTRIBUTE15 10 ECO_ATTRIBUTE2 11 ECO_ATTRIBUTE3 12 ECO_ATTRIBUTE4 13 ECO_ATTRIBUTE5 14 ECO_ATTRIBUTE6 15 ECO_ATTRIBUTE7 16 ECO_ATTRIBUTE8 17 ECO_ATTRIBUTE9 8 ECO_ATTRIBUTE_CATEGORY Y 7 OPERATION_SEQ 1 ORGANIZATION_CODE 3 REVISED_ITEM 25 RI_ATTRIBUTE1 34 RI_ATTRIBUTE10 35 RI_ATTRIBUTE11 36 RI_ATTRIBUTE12 37 RI_ATTRIBUTE13 38 RI_ATTRIBUTE14 39 RI_ATTRIBUTE15 26 RI_ATTRIBUTE2 27 RI_ATTRIBUTE3 28 RI_ATTRIBUTE4 29 RI_ATTRIBUTE5 30 RI_ATTRIBUTE6 31 RI_ATTRIBUTE7 32 RI_ATTRIBUTE8 33 RI_ATTRIBUTE9 24 RI_ATTRIBUTE_CATEGORY Upload Mode C,U S Site 5E862F46A10C406089EE8CEE58719914 Revised Items The revised item columns, to reschedule revised items or change their status, revision and disposition. A revised item with several revised components is downloaded once per component; change it on one of these rows. ENGINATICS 7 ALTERNATE 16 CHANGE_DESCRIPTION 14 DISPOSITION 15 EARLY_EFFECTIVE_DATE 2 ECO 3 ECO_DESCRIPTION 4 ECO_STATUS 10 EFFECTIVE_DATE 17 IMPLEMENTED_DATE 9 ITEM_REVISION_DESCRIPTION 12 MRP_ACTIVE 8 NEW_ITEM_REVISION 1 ORGANIZATION_CODE 5 REVISED_ITEM Y 6 REVISED_ITEM_DESCRIPTION 11 REVISED_ITEM_STATUS 13 UPDATE_JOBS Upload Mode U S Site E66D61C474A24C8EB99820E7DB0BDA0D 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 REVISED_ITEM_SEQ_ID Number number Y 6 COMPONENT_SEQ_ID Number number Y 7 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 :$flex$.organization_code Y Y 8 ECO LOV custom varchar2 Y select eec.change_notice value, eec.description from mtl_parameters mp, eng_engineering_changes eec, eng_change_order_types_vl ecotv where mp.organization_code=:$column$.organization_code and mp.organization_id=eec.organization_id and eec.change_order_type_id=ecotv.change_order_type_id and ecotv.base_change_mgmt_type_code='CHANGE_ORDER' order by eec.change_notice Y Y 9 ECO_TYPE LOV custom varchar2 select ecotv.change_order_type value, ecotv.description from eng_change_order_types_vl ecotv where ecotv.change_mgmt_type_code='CHANGE_ORDER' and ecotv.type_classification='HEADER' and nvl(ecotv.disable_date,sysdate+1)>sysdate order by ecotv.change_order_type 10 ECO_STATUS Char varchar2 Y 11 REQUESTOR LOV custom varchar2 select x.party_id id, case when count(*) over (partition by x.full_name)>1 then x.full_name||' ('||x.employee_number||')' else x.full_name end value, x.employee_number description from ( select papf.party_id, papf.full_name, papf.employee_number from per_all_people_f papf where trunc(sysdate) between papf.effective_start_date and papf.effective_end_date and papf.current_employee_flag='Y' and papf.party_id is not null ) x order by value 12 ECO_DEPARTMENT LOV custom varchar2 select hou.name value from hr_organization_units hou where hou.organization_id in (select hoi.organization_id from hr_organization_information hoi where hoi.org_information_context='CLASS' and hoi.org_information1='BOM_ECOD' and hoi.org_information2='Y') order by hou.name 13 REASON LOV custom varchar2 select ecr.eng_change_reason_code value, ecr.description from eng_change_reasons ecr where ecr.organization_id=-1 and nvl(ecr.disable_date,sysdate+1)>sysdate order by ecr.eng_change_reason_code 14 PRIORITY LOV custom varchar2 select ecp.eng_change_priority_code value, ecp.description from eng_change_priorities ecp where ecp.organization_id=-1 and nvl(ecp.disable_date,sysdate+1)>sysdate order by ecp.eng_change_priority_code 15 APPROVAL_STATUS LOV custom varchar2 select ml.meaning value from mfg_lookups ml where ml.lookup_type='ENG_ECN_APPROVAL_STATUS' and ml.lookup_code not in (6,7,8) 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 16 ECO_DESCRIPTION Char varchar2 17 ENGINEERING_COST Number number 18 MANUFACTURING_COST Number number 19 ECO_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=703 and fdfcv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 20 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 21 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 22 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 23 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 24 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 25 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 26 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 27 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 28 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 29 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 30 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 31 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 32 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 33 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 34 ECO_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=>703, p_descriptive_flexfield_name=>'ENG_ENGINEERING_CHANGES', p_context_name=>:$column$.eco_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.eco_attribute1, p_attribute2=>:$column$.eco_attribute2, p_attribute3=>:$column$.eco_attribute3, p_attribute4=>:$column$.eco_attribute4, p_attribute5=>:$column$.eco_attribute5, p_attribute6=>:$column$.eco_attribute6, p_attribute7=>:$column$.eco_attribute7, p_attribute8=>:$column$.eco_attribute8, p_attribute9=>:$column$.eco_attribute9, p_attribute10=>:$column$.eco_attribute10, p_attribute11=>:$column$.eco_attribute11, p_attribute12=>:$column$.eco_attribute12, p_attribute13=>:$column$.eco_attribute13, p_attribute14=>:$column$.eco_attribute14, p_attribute15=>:$column$.eco_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=703 and fdfv.descriptive_flexfield_name='ENG_ENGINEERING_CHANGES' 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' 35 REVISED_ITEM LOV custom varchar2 select 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 order by msiv.concatenated_segments 36 REVISED_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$.revised_item Y 37 ALTERNATE LOV custom varchar2 select bad.alternate_designator_code value, bad.description from mtl_parameters mp, bom_alternate_designators bad where mp.organization_code=:$column$.organization_code and mp.organization_id=bad.organization_id and nvl(bad.disable_date,sysdate+1)>sysdate order by bad.alternate_designator_code 38 NEW_ITEM_REVISION Char varchar2 39 ITEM_REVISION_DESCRIPTION Char varchar2 40 NEW_ROUTING_REVISION Char varchar2 41 EFFECTIVE_DATE Date date select sysdate from dual where :$column$.revised_item is not null 42 REVISED_ITEM_STATUS LOV custom varchar2 select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='ECG_ECN_STATUS' and ml.lookup_code in (1,2,4,5) 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 43 MRP_ACTIVE 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$.revised_item is not null and fnd_profile.value('ENG:DEFAULT_MRP_ACTIVE')='1' 44 EARLY_EFFECTIVE_DATE Date date 45 IMPLEMENTED_DATE Date date Y 46 UPDATE_JOBS 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 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$.revised_item and msiv.build_in_wip_flag='Y' 47 DISPOSITION LOV custom varchar2 select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='ECG_MATERIAL_DISPOSITION' 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 select xxen_util.meaning('1','ECG_MATERIAL_DISPOSITION',700) from dual where :$column$.revised_item is not null 48 CHANGE_DESCRIPTION Char varchar2 49 RI_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=703 and fdfcv.descriptive_flexfield_name='ENG_REVISED_ITEMS' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 50 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 51 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 52 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 53 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 54 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 55 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 56 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 57 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 58 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 59 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 60 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 61 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 62 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 63 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 64 RI_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=>703, p_descriptive_flexfield_name=>'ENG_REVISED_ITEMS', p_context_name=>:$column$.ri_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.ri_attribute1, p_attribute2=>:$column$.ri_attribute2, p_attribute3=>:$column$.ri_attribute3, p_attribute4=>:$column$.ri_attribute4, p_attribute5=>:$column$.ri_attribute5, p_attribute6=>:$column$.ri_attribute6, p_attribute7=>:$column$.ri_attribute7, p_attribute8=>:$column$.ri_attribute8, p_attribute9=>:$column$.ri_attribute9, p_attribute10=>:$column$.ri_attribute10, p_attribute11=>:$column$.ri_attribute11, p_attribute12=>:$column$.ri_attribute12, p_attribute13=>:$column$.ri_attribute13, p_attribute14=>:$column$.ri_attribute14, p_attribute15=>:$column$.ri_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=703 and fdfv.descriptive_flexfield_name='ENG_REVISED_ITEMS' 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' 65 COMPONENT_ACTION LOV custom varchar2 select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='ECG_ACTION' 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 66 COMPONENT LOV custom varchar2 select 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.bom_enabled_flag='Y' order by msiv.concatenated_segments 67 COMPONENT_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$.component Y 68 OLD_OPERATION_SEQ Number number 69 OPERATION_SEQ Number number select 1 from dual where :$column$.component is not null 70 ITEM_SEQ Number number 71 BASIS LOV custom varchar2 select ml.lookup_code id, ml.meaning value, null 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 72 QUANTITY Number number 73 DISABLE_DATE Date date 74 PLANNING_PERCENT Number number 75 YIELD Number number 76 ENFORCE_INT_REQUIREMENTS LOV custom varchar2 select ml.meaning value from mfg_lookups ml where ml.lookup_type='BOM_ENFORCE_INT_REQUIREMENTS' and ml.enabled_flag='Y' order by ml.lookup_code 77 INCLUDE_IN_COST_ROLLUP 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$.component is not null and :$column$.component_action=xxen_util.meaning('1','ECG_ACTION',700) 78 SUPPLY_TYPE LOV custom varchar2 select ml.lookup_code id, ml.meaning value, null description from mfg_lookups ml where ml.lookup_type='WIP_SUPPLY' 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 79 SUPPLY_SUBINVENTORY LOV custom varchar2 select msi.secondary_inventory_name value, msi.description from mtl_parameters mp, mtl_secondary_inventories msi where mp.organization_code=:$column$.organization_code and mp.organization_id=msi.organization_id and nvl(msi.disable_date,sysdate+1)>sysdate order by msi.secondary_inventory_name 80 CHECK_ATP 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) 81 OPTIONAL 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) 82 MUTUALLY_EXCLUSIVE 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) 83 MINIMUM_QUANTITY Number number 84 MAXIMUM_QUANTITY Number number 85 INCLUDE_ON_SHIP_DOCS 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) 86 REQUIRED_TO_SHIP 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) 87 REQUIRED_FOR_REVENUE 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) 88 COMPONENT_COMMENTS Char varchar2 89 DELETE_COMPONENT LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.component_seq_id is not null 90 COMP_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_INVENTORY_COMPONENTS' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 91 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 92 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 93 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 94 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 95 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 96 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 97 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 98 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 99 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 100 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 101 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 102 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 103 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 104 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 105 COMP_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_INVENTORY_COMPONENTS', p_context_name=>:$column$.comp_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.comp_attribute1, p_attribute2=>:$column$.comp_attribute2, p_attribute3=>:$column$.comp_attribute3, p_attribute4=>:$column$.comp_attribute4, p_attribute5=>:$column$.comp_attribute5, p_attribute6=>:$column$.comp_attribute6, p_attribute7=>:$column$.comp_attribute7, p_attribute8=>:$column$.comp_attribute8, p_attribute9=>:$column$.comp_attribute9, p_attribute10=>:$column$.comp_attribute10, p_attribute11=>:$column$.comp_attribute11, p_attribute12=>:$column$.comp_attribute12, p_attribute13=>:$column$.comp_attribute13, p_attribute14=>:$column$.comp_attribute14, p_attribute15=>:$column$.comp_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_INVENTORY_COMPONENTS' 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' 106 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_revised_item_seq_id in Number Y REVISED_ITEM_SEQ_ID U 5 p_revised_item_seq_id_out out Number REVISED_ITEM_SEQ_ID U 6 p_component_seq_id in Number Y COMPONENT_SEQ_ID U 7 p_component_seq_id_out out Number COMPONENT_SEQ_ID U 8 p_organization_code in Char ORGANIZATION_CODE U 9 p_eco in Char ECO U 10 p_eco_type in Char Y ECO_TYPE U 11 p_requestor_id in Number Y REQUESTOR U 12 p_eco_department in Char Y ECO_DEPARTMENT U 13 p_reason in Char Y REASON U 14 p_priority in Char Y PRIORITY U 15 p_approval_status in Char Y APPROVAL_STATUS U 16 p_eco_description in Char Y ECO_DESCRIPTION U 17 p_engineering_cost in Number Y ENGINEERING_COST U 18 p_manufacturing_cost in Number Y MANUFACTURING_COST U 19 p_eco_attribute_category in Char Y ECO_ATTRIBUTE_CATEGORY U 20 p_eco_attribute1 in Char Y ECO_ATTRIBUTE1 U 21 p_eco_attribute2 in Char Y ECO_ATTRIBUTE2 U 22 p_eco_attribute3 in Char Y ECO_ATTRIBUTE3 U 23 p_eco_attribute4 in Char Y ECO_ATTRIBUTE4 U 24 p_eco_attribute5 in Char Y ECO_ATTRIBUTE5 U 25 p_eco_attribute6 in Char Y ECO_ATTRIBUTE6 U 26 p_eco_attribute7 in Char Y ECO_ATTRIBUTE7 U 27 p_eco_attribute8 in Char Y ECO_ATTRIBUTE8 U 28 p_eco_attribute9 in Char Y ECO_ATTRIBUTE9 U 29 p_eco_attribute10 in Char Y ECO_ATTRIBUTE10 U 30 p_eco_attribute11 in Char Y ECO_ATTRIBUTE11 U 31 p_eco_attribute12 in Char Y ECO_ATTRIBUTE12 U 32 p_eco_attribute13 in Char Y ECO_ATTRIBUTE13 U 33 p_eco_attribute14 in Char Y ECO_ATTRIBUTE14 U 34 p_eco_attribute15 in Char Y ECO_ATTRIBUTE15 U 35 p_revised_item in Char Y REVISED_ITEM U 36 p_alternate in Char Y ALTERNATE U 37 p_new_item_revision in Char Y NEW_ITEM_REVISION U 38 p_item_revision_description in Char Y ITEM_REVISION_DESCRIPTION U 39 p_new_routing_revision in Char Y NEW_ROUTING_REVISION U 40 p_effective_date in Date Y EFFECTIVE_DATE U 41 p_revised_item_status in Number Y REVISED_ITEM_STATUS U 42 p_mrp_active in Number Y MRP_ACTIVE U 43 p_early_effective_date in Date Y EARLY_EFFECTIVE_DATE U 44 p_update_jobs in Number Y UPDATE_JOBS U 45 p_disposition in Number Y DISPOSITION U 46 p_change_description in Char Y CHANGE_DESCRIPTION U 47 p_ri_attribute_category in Char Y RI_ATTRIBUTE_CATEGORY U 48 p_ri_attribute1 in Char Y RI_ATTRIBUTE1 U 49 p_ri_attribute2 in Char Y RI_ATTRIBUTE2 U 50 p_ri_attribute3 in Char Y RI_ATTRIBUTE3 U 51 p_ri_attribute4 in Char Y RI_ATTRIBUTE4 U 52 p_ri_attribute5 in Char Y RI_ATTRIBUTE5 U 53 p_ri_attribute6 in Char Y RI_ATTRIBUTE6 U 54 p_ri_attribute7 in Char Y RI_ATTRIBUTE7 U 55 p_ri_attribute8 in Char Y RI_ATTRIBUTE8 U 56 p_ri_attribute9 in Char Y RI_ATTRIBUTE9 U 57 p_ri_attribute10 in Char Y RI_ATTRIBUTE10 U 58 p_ri_attribute11 in Char Y RI_ATTRIBUTE11 U 59 p_ri_attribute12 in Char Y RI_ATTRIBUTE12 U 60 p_ri_attribute13 in Char Y RI_ATTRIBUTE13 U 61 p_ri_attribute14 in Char Y RI_ATTRIBUTE14 U 62 p_ri_attribute15 in Char Y RI_ATTRIBUTE15 U 63 p_component_action in Number Y COMPONENT_ACTION U 64 p_component in Char Y COMPONENT U 65 p_old_operation_seq in Number Y OLD_OPERATION_SEQ U 66 p_operation_seq in Number Y OPERATION_SEQ U 67 p_item_seq in Number Y ITEM_SEQ U 68 p_basis in Number Y BASIS U 69 p_quantity in Number Y QUANTITY U 70 p_disable_date in Date Y DISABLE_DATE U 71 p_planning_percent in Number Y PLANNING_PERCENT U 72 p_yield in Number Y YIELD U 73 p_enforce_int_requirements in Char Y ENFORCE_INT_REQUIREMENTS U 74 p_include_in_cost_rollup in Number Y INCLUDE_IN_COST_ROLLUP U 75 p_supply_type in Number Y SUPPLY_TYPE U 76 p_supply_subinventory in Char Y SUPPLY_SUBINVENTORY U 77 p_check_atp in Number Y CHECK_ATP U 78 p_optional in Number Y OPTIONAL U 79 p_mutually_exclusive in Number Y MUTUALLY_EXCLUSIVE U 80 p_minimum_quantity in Number Y MINIMUM_QUANTITY U 81 p_maximum_quantity in Number Y MAXIMUM_QUANTITY U 82 p_include_on_ship_docs in Number Y INCLUDE_ON_SHIP_DOCS U 83 p_required_to_ship in Number Y REQUIRED_TO_SHIP U 84 p_required_for_revenue in Number Y REQUIRED_FOR_REVENUE U 85 p_component_comments in Char Y COMPONENT_COMMENTS U 86 p_delete_component in Char Y DELETE_COMPONENT U 87 p_comp_attribute_category in Char Y COMP_ATTRIBUTE_CATEGORY U 88 p_comp_attribute1 in Char Y COMP_ATTRIBUTE1 U 89 p_comp_attribute2 in Char Y COMP_ATTRIBUTE2 U 90 p_comp_attribute3 in Char Y COMP_ATTRIBUTE3 U 91 p_comp_attribute4 in Char Y COMP_ATTRIBUTE4 U 92 p_comp_attribute5 in Char Y COMP_ATTRIBUTE5 U 93 p_comp_attribute6 in Char Y COMP_ATTRIBUTE6 U 94 p_comp_attribute7 in Char Y COMP_ATTRIBUTE7 U 95 p_comp_attribute8 in Char Y COMP_ATTRIBUTE8 U 96 p_comp_attribute9 in Char Y COMP_ATTRIBUTE9 U 97 p_comp_attribute10 in Char Y COMP_ATTRIBUTE10 U 98 p_comp_attribute11 in Char Y COMP_ATTRIBUTE11 U 99 p_comp_attribute12 in Char Y COMP_ATTRIBUTE12 U 100 p_comp_attribute13 in Char Y COMP_ATTRIBUTE13 U 101 p_comp_attribute14 in Char Y COMP_ATTRIBUTE14 U 102 p_comp_attribute15 in Char Y COMP_ATTRIBUTE15 Error SQL Order By upload_row, organization_code, eco, revised_item, effective_date, operation_seq, component Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.revised_item_seq_id, xu.component_seq_id, mp.organization_code, eec.change_notice eco, ecotv.change_order_type eco_type, ecsv.status_name eco_status, xxen_eng_upload.requestor(eec.requestor_id) requestor, haouv.name eco_department, eec.reason_code reason, eec.priority_code priority, xxen_util.meaning(eec.approval_status_type,'ENG_ECN_APPROVAL_STATUS',700) approval_status, eec.description eco_description, eec.estimated_eng_cost engineering_cost, eec.estimated_mfg_cost manufacturing_cost, xxen_util.display_flexfield_context(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category) eco_attribute_category, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE1',eec.rowid,eec.attribute1) eco_attribute1, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE2',eec.rowid,eec.attribute2) eco_attribute2, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE3',eec.rowid,eec.attribute3) eco_attribute3, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE4',eec.rowid,eec.attribute4) eco_attribute4, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE5',eec.rowid,eec.attribute5) eco_attribute5, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE6',eec.rowid,eec.attribute6) eco_attribute6, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE7',eec.rowid,eec.attribute7) eco_attribute7, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE8',eec.rowid,eec.attribute8) eco_attribute8, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE9',eec.rowid,eec.attribute9) eco_attribute9, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE10',eec.rowid,eec.attribute10) eco_attribute10, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE11',eec.rowid,eec.attribute11) eco_attribute11, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE12',eec.rowid,eec.attribute12) eco_attribute12, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE13',eec.rowid,eec.attribute13) eco_attribute13, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE14',eec.rowid,eec.attribute14) eco_attribute14, xxen_util.display_flexfield_value(703,'ENG_ENGINEERING_CHANGES',eec.attribute_category,'ATTRIBUTE15',eec.rowid,eec.attribute15) eco_attribute15, case when eri.rowid is null then xu.revised_item else msiv.concatenated_segments end revised_item, case when eri.rowid is null then xu.revised_item_description else msiv.description end revised_item_description, case when eri.rowid is null then xu.alternate else eri.alternate_bom_designator end alternate, case when eri.rowid is null then xu.new_item_revision else eri.new_item_revision end new_item_revision, case when eri.rowid is null then xu.item_revision_description else mirv.description end item_revision_description, case when eri.rowid is null then xu.new_routing_revision else eri.new_routing_revision end new_routing_revision, case when eri.rowid is null then xu.effective_date else eri.scheduled_date end effective_date, case when eri.rowid is null then xu.revised_item_status else xxen_util.meaning(eri.status_type,'ECG_ECN_STATUS',700) end revised_item_status, case when eri.rowid is null then xu.mrp_active else decode(eri.mrp_active,1,xxen_util.meaning('1','SYS_YES_NO',700)) end mrp_active, case when eri.rowid is null then xu.early_effective_date else eri.early_schedule_date end early_effective_date, case when eri.rowid is null then xu.implemented_date else eri.implementation_date end implemented_date, case when eri.rowid is null then xu.update_jobs else decode(eri.update_wip,1,xxen_util.meaning('1','SYS_YES_NO',700)) end update_jobs, case when eri.rowid is null then xu.disposition else xxen_util.meaning(eri.disposition_type,'ECG_MATERIAL_DISPOSITION',700) end disposition, case when eri.rowid is null then xu.change_description else eri.descriptive_text end change_description, case when eri.rowid is null then xu.ri_attribute_category else xxen_util.display_flexfield_context(703,'ENG_REVISED_ITEMS',eri.attribute_category) end ri_attribute_category, case when eri.rowid is null then xu.ri_attribute1 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE1',eri.rowid,eri.attribute1) end ri_attribute1, case when eri.rowid is null then xu.ri_attribute2 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE2',eri.rowid,eri.attribute2) end ri_attribute2, case when eri.rowid is null then xu.ri_attribute3 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE3',eri.rowid,eri.attribute3) end ri_attribute3, case when eri.rowid is null then xu.ri_attribute4 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE4',eri.rowid,eri.attribute4) end ri_attribute4, case when eri.rowid is null then xu.ri_attribute5 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE5',eri.rowid,eri.attribute5) end ri_attribute5, case when eri.rowid is null then xu.ri_attribute6 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE6',eri.rowid,eri.attribute6) end ri_attribute6, case when eri.rowid is null then xu.ri_attribute7 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE7',eri.rowid,eri.attribute7) end ri_attribute7, case when eri.rowid is null then xu.ri_attribute8 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE8',eri.rowid,eri.attribute8) end ri_attribute8, case when eri.rowid is null then xu.ri_attribute9 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE9',eri.rowid,eri.attribute9) end ri_attribute9, case when eri.rowid is null then xu.ri_attribute10 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE10',eri.rowid,eri.attribute10) end ri_attribute10, case when eri.rowid is null then xu.ri_attribute11 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE11',eri.rowid,eri.attribute11) end ri_attribute11, case when eri.rowid is null then xu.ri_attribute12 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE12',eri.rowid,eri.attribute12) end ri_attribute12, case when eri.rowid is null then xu.ri_attribute13 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE13',eri.rowid,eri.attribute13) end ri_attribute13, case when eri.rowid is null then xu.ri_attribute14 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE14',eri.rowid,eri.attribute14) end ri_attribute14, case when eri.rowid is null then xu.ri_attribute15 else xxen_util.display_flexfield_value(703,'ENG_REVISED_ITEMS',eri.attribute_category,'ATTRIBUTE15',eri.rowid,eri.attribute15) end ri_attribute15, case when bcb.rowid is null then xu.component_action else xxen_util.meaning(bcb.acd_type,'ECG_ACTION',700) end component_action, case when bcb.rowid is null then xu.component else (select msiv_c.concatenated_segments from mtl_system_items_vl msiv_c where bcb.component_item_id=msiv_c.inventory_item_id and mp.organization_id=msiv_c.organization_id) end component, case when bcb.rowid is null then xu.component_description else (select msiv_c.description from mtl_system_items_vl msiv_c where bcb.component_item_id=msiv_c.inventory_item_id and mp.organization_id=msiv_c.organization_id) end component_description, case when bcb.rowid is null then xu.old_operation_seq else decode(bcb.acd_type,1,to_number(null),bcb_old.operation_seq_num) end old_operation_seq, case when bcb.rowid is null then xu.operation_seq else bcb.operation_seq_num end operation_seq, case when bcb.rowid is null then xu.item_seq else bcb.item_num end item_seq, case when bcb.rowid is null then xu.basis else xxen_util.meaning(bcb.basis_type,'BOM_BASIS_TYPE',700) end basis, case when bcb.rowid is null then xu.quantity else bcb.component_quantity end quantity, case when bcb.rowid is null then xu.disable_date else bcb.disable_date end disable_date, case when bcb.rowid is null then xu.planning_percent else bcb.planning_factor end planning_percent, case when bcb.rowid is null then xu.yield else bcb.component_yield_factor end yield, case when bcb.rowid is null then xu.enforce_int_requirements else xxen_util.meaning(bcb.enforce_int_requirements,'BOM_ENFORCE_INT_REQUIREMENTS',700) end enforce_int_requirements, case when bcb.rowid is null then xu.include_in_cost_rollup else decode(bcb.include_in_cost_rollup,1,xxen_util.meaning('1','SYS_YES_NO',700)) end include_in_cost_rollup, case when bcb.rowid is null then xu.supply_type else xxen_util.meaning(bcb.wip_supply_type,'WIP_SUPPLY',700) end supply_type, case when bcb.rowid is null then xu.supply_subinventory else bcb.supply_subinventory end supply_subinventory, case when bcb.rowid is null then xu.check_atp else decode(bcb.check_atp,1,xxen_util.meaning('1','SYS_YES_NO',700)) end check_atp, case when bcb.rowid is null then xu.optional else decode(bcb.optional,1,xxen_util.meaning('1','SYS_YES_NO',700)) end optional, case when bcb.rowid is null then xu.mutually_exclusive else decode(bcb.mutually_exclusive_options,1,xxen_util.meaning('1','SYS_YES_NO',700)) end mutually_exclusive, case when bcb.rowid is null then xu.minimum_quantity else bcb.low_quantity end minimum_quantity, case when bcb.rowid is null then xu.maximum_quantity else bcb.high_quantity end maximum_quantity, case when bcb.rowid is null then xu.include_on_ship_docs else decode(bcb.include_on_ship_docs,1,xxen_util.meaning('1','SYS_YES_NO',700)) end include_on_ship_docs, case when bcb.rowid is null then xu.required_to_ship else decode(bcb.required_to_ship,1,xxen_util.meaning('1','SYS_YES_NO',700)) end required_to_ship, case when bcb.rowid is null then xu.required_for_revenue else decode(bcb.required_for_revenue,1,xxen_util.meaning('1','SYS_YES_NO',700)) end required_for_revenue, case when bcb.rowid is null then xu.component_comments else bcb.component_remarks end component_comments, xu.delete_component, case when bcb.rowid is null then xu.comp_attribute_category else xxen_util.display_flexfield_context(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category) end comp_attribute_category, case when bcb.rowid is null then xu.comp_attribute1 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE1',bcb.rowid,bcb.attribute1) end comp_attribute1, case when bcb.rowid is null then xu.comp_attribute2 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE2',bcb.rowid,bcb.attribute2) end comp_attribute2, case when bcb.rowid is null then xu.comp_attribute3 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE3',bcb.rowid,bcb.attribute3) end comp_attribute3, case when bcb.rowid is null then xu.comp_attribute4 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE4',bcb.rowid,bcb.attribute4) end comp_attribute4, case when bcb.rowid is null then xu.comp_attribute5 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE5',bcb.rowid,bcb.attribute5) end comp_attribute5, case when bcb.rowid is null then xu.comp_attribute6 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE6',bcb.rowid,bcb.attribute6) end comp_attribute6, case when bcb.rowid is null then xu.comp_attribute7 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE7',bcb.rowid,bcb.attribute7) end comp_attribute7, case when bcb.rowid is null then xu.comp_attribute8 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE8',bcb.rowid,bcb.attribute8) end comp_attribute8, case when bcb.rowid is null then xu.comp_attribute9 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE9',bcb.rowid,bcb.attribute9) end comp_attribute9, case when bcb.rowid is null then xu.comp_attribute10 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE10',bcb.rowid,bcb.attribute10) end comp_attribute10, case when bcb.rowid is null then xu.comp_attribute11 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE11',bcb.rowid,bcb.attribute11) end comp_attribute11, case when bcb.rowid is null then xu.comp_attribute12 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE12',bcb.rowid,bcb.attribute12) end comp_attribute12, case when bcb.rowid is null then xu.comp_attribute13 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE13',bcb.rowid,bcb.attribute13) end comp_attribute13, case when bcb.rowid is null then xu.comp_attribute14 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE14',bcb.rowid,bcb.attribute14) end comp_attribute14, case when bcb.rowid is null then xu.comp_attribute15 else xxen_util.display_flexfield_value(702,'BOM_INVENTORY_COMPONENTS',bcb.attribute_category,'ATTRIBUTE15',bcb.rowid,bcb.attribute15) end comp_attribute15, xu.upload_row from xxen_eng_engineering_ch_4151_u xu, mtl_parameters mp, eng_engineering_changes eec, eng_change_order_types_vl ecotv, eng_change_statuses_vl ecsv, hr_all_organization_units_vl haouv, eng_revised_items eri, mtl_system_items_vl msiv, mtl_item_revisions_vl mirv, bom_components_b bcb, bom_components_b bcb_old where xu.status_code_=xxen_upload.status_success and xu.organization_code=mp.organization_code and mp.organization_id=eec.organization_id and xu.eco=eec.change_notice and eec.change_order_type_id=ecotv.change_order_type_id and eec.status_type=ecsv.status_code(+) and eec.responsible_organization_id=haouv.organization_id(+) and xu.revised_item_seq_id=eri.revised_item_sequence_id(+) and eri.revised_item_id=msiv.inventory_item_id(+) and eri.organization_id=msiv.organization_id(+) and eri.new_item_revision_id=mirv.revision_id(+) and xu.component_seq_id=bcb.component_sequence_id(+) and bcb.old_component_sequence_id=bcb_old.component_sequence_id(+)