ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual US B1A7F0C2D3E4F506172839AA5B6C7D01Y select null action_, null status_, null message_, null modified_columns_, row_number() over (order by x.formula, x.formula_version, x.line_type_sort, x.line_no) upload_row, x.organization_code, x.formula, x.formula_version, x.formula_description, x.formula_description_2, x.formula_class, x.owner, x.header_scale_type, x.calculate_product_quantity, x.formula_status, x.line_type, x.line_no, x.item, x.item_description, x.revision, x.quantity, x.detail_uom, x.line_scale_type, x.release_type, x.scrap_factor, x.phantom_type, x.rework_type, x.contribute_to_yield, x.contribute_to_step_quantity, x.cost_allocation, x.product_percent, x.by_product_type, x.scale_multiple, x.scale_rounding_variance, x.rounding_direction, x.ingredient_end_date, x.delete_line, x.fa_attribute_category, x.fa_attribute1, x.fa_attribute2, x.fa_attribute3, x.fa_attribute4, x.fa_attribute5, x.fa_attribute6, x.fa_attribute7, x.fa_attribute8, x.fa_attribute9, x.fa_attribute10, x.fa_attribute11, x.fa_attribute12, x.fa_attribute13, x.fa_attribute14, x.fa_attribute15, x.fa_attribute16, x.fa_attribute17, x.fa_attribute18, x.fa_attribute19, x.fa_attribute20, x.fa_attribute21, x.fa_attribute22, x.fa_attribute23, x.fa_attribute24, x.fa_attribute25, x.fa_attribute26, x.fa_attribute27, x.fa_attribute28, x.fa_attribute29, x.fa_attribute30, x.ld_attribute_category, x.ld_attribute1, x.ld_attribute2, x.ld_attribute3, x.ld_attribute4, x.ld_attribute5, x.ld_attribute6, x.ld_attribute7, x.ld_attribute8, x.ld_attribute9, x.ld_attribute10, x.ld_attribute11, x.ld_attribute12, x.ld_attribute13, x.ld_attribute14, x.ld_attribute15, x.ld_attribute16, x.ld_attribute17, x.ld_attribute18, x.ld_attribute19, x.ld_attribute20, x.ld_attribute21, x.ld_attribute22, x.ld_attribute23, x.ld_attribute24, x.ld_attribute25, x.ld_attribute26, x.ld_attribute27, x.ld_attribute28, x.ld_attribute29, x.ld_attribute30, x.formula_id, x.formula_line_id from ( select mp.organization_code, ffmv.formula_no formula, ffmv.formula_vers formula_version, ffmv.formula_desc1 formula_description, ffmv.formula_desc2 formula_description_2, ffmv.formula_class, (select fu.user_name from fnd_user fu where fu.user_id=ffmv.owner_id) owner, xxen_util.meaning(to_char(ffmv.scale_type),'SCALE_TYPE',552) header_scale_type, xxen_util.meaning(ffmv.auto_product_calc,'YES_NO',552) calculate_product_quantity, (select gsv.meaning from gmd_status_vl gsv where gsv.status_code=ffmv.formula_status) formula_status, xxen_util.meaning(to_char(fmd.line_type),'GMD_FORMULA_ITEM_TYPE',552) line_type, fmd.line_no, msiv.concatenated_segments item, msiv.description item_description, fmd.revision, fmd.qty quantity, fmd.detail_uom, xxen_util.meaning(to_char(fmd.scale_type),'SCALE_TYPE',552) line_scale_type, xxen_util.meaning(to_char(fmd.release_type),'GMD_MATERIAL_RELEASE_TYPE',552) release_type, fmd.scrap_factor, decode(fmd.phantom_type,0,'Not Phantom',1,'Automatic Phantom',2,'Manual Phantom') phantom_type, xxen_util.meaning(to_char(fmd.rework_type),'GMD_REWORK_TYPE',552) rework_type, xxen_util.meaning(fmd.contribute_yield_ind,'YES_NO',552) contribute_to_yield, xxen_util.meaning(fmd.contribute_step_qty_ind,'YES_NO',552) contribute_to_step_quantity, fmd.cost_alloc cost_allocation, fmd.prod_percent product_percent, xxen_util.meaning(fmd.by_product_type,'GMD_BY_PRODUCT_TYPE',552) by_product_type, fmd.scale_multiple, fmd.scale_rounding_variance, xxen_util.meaning(to_char(fmd.rounding_direction),'GMD_ROUNDING_DIRECTION',552) rounding_direction, fmd.ingredient_end_date, to_char(null) delete_line, xxen_util.display_flexfield_context(552,'FORMULA_FLEX',ffmv.attribute_category) fa_attribute_category, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE1',ffmv.rowid,ffmv.attribute1) fa_attribute1, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE2',ffmv.rowid,ffmv.attribute2) fa_attribute2, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE3',ffmv.rowid,ffmv.attribute3) fa_attribute3, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE4',ffmv.rowid,ffmv.attribute4) fa_attribute4, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE5',ffmv.rowid,ffmv.attribute5) fa_attribute5, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE6',ffmv.rowid,ffmv.attribute6) fa_attribute6, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE7',ffmv.rowid,ffmv.attribute7) fa_attribute7, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE8',ffmv.rowid,ffmv.attribute8) fa_attribute8, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE9',ffmv.rowid,ffmv.attribute9) fa_attribute9, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE10',ffmv.rowid,ffmv.attribute10) fa_attribute10, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE11',ffmv.rowid,ffmv.attribute11) fa_attribute11, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE12',ffmv.rowid,ffmv.attribute12) fa_attribute12, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE13',ffmv.rowid,ffmv.attribute13) fa_attribute13, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE14',ffmv.rowid,ffmv.attribute14) fa_attribute14, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE15',ffmv.rowid,ffmv.attribute15) fa_attribute15, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE16',ffmv.rowid,ffmv.attribute16) fa_attribute16, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE17',ffmv.rowid,ffmv.attribute17) fa_attribute17, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE18',ffmv.rowid,ffmv.attribute18) fa_attribute18, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE19',ffmv.rowid,ffmv.attribute19) fa_attribute19, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE20',ffmv.rowid,ffmv.attribute20) fa_attribute20, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE21',ffmv.rowid,ffmv.attribute21) fa_attribute21, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE22',ffmv.rowid,ffmv.attribute22) fa_attribute22, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE23',ffmv.rowid,ffmv.attribute23) fa_attribute23, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE24',ffmv.rowid,ffmv.attribute24) fa_attribute24, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE25',ffmv.rowid,ffmv.attribute25) fa_attribute25, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE26',ffmv.rowid,ffmv.attribute26) fa_attribute26, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE27',ffmv.rowid,ffmv.attribute27) fa_attribute27, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE28',ffmv.rowid,ffmv.attribute28) fa_attribute28, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE29',ffmv.rowid,ffmv.attribute29) fa_attribute29, xxen_util.display_flexfield_value(552,'FORMULA_FLEX',ffmv.attribute_category,'ATTRIBUTE30',ffmv.rowid,ffmv.attribute30) fa_attribute30, xxen_util.display_flexfield_context(552,'FM_DETAIL_FLEX',fmd.attribute_category) ld_attribute_category, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE1',fmd.rowid,fmd.attribute1) ld_attribute1, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE2',fmd.rowid,fmd.attribute2) ld_attribute2, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE3',fmd.rowid,fmd.attribute3) ld_attribute3, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE4',fmd.rowid,fmd.attribute4) ld_attribute4, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE5',fmd.rowid,fmd.attribute5) ld_attribute5, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE6',fmd.rowid,fmd.attribute6) ld_attribute6, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE7',fmd.rowid,fmd.attribute7) ld_attribute7, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE8',fmd.rowid,fmd.attribute8) ld_attribute8, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE9',fmd.rowid,fmd.attribute9) ld_attribute9, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE10',fmd.rowid,fmd.attribute10) ld_attribute10, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE11',fmd.rowid,fmd.attribute11) ld_attribute11, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE12',fmd.rowid,fmd.attribute12) ld_attribute12, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE13',fmd.rowid,fmd.attribute13) ld_attribute13, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE14',fmd.rowid,fmd.attribute14) ld_attribute14, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE15',fmd.rowid,fmd.attribute15) ld_attribute15, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE16',fmd.rowid,fmd.attribute16) ld_attribute16, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE17',fmd.rowid,fmd.attribute17) ld_attribute17, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE18',fmd.rowid,fmd.attribute18) ld_attribute18, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE19',fmd.rowid,fmd.attribute19) ld_attribute19, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE20',fmd.rowid,fmd.attribute20) ld_attribute20, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE21',fmd.rowid,fmd.attribute21) ld_attribute21, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE22',fmd.rowid,fmd.attribute22) ld_attribute22, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE23',fmd.rowid,fmd.attribute23) ld_attribute23, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE24',fmd.rowid,fmd.attribute24) ld_attribute24, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE25',fmd.rowid,fmd.attribute25) ld_attribute25, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE26',fmd.rowid,fmd.attribute26) ld_attribute26, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE27',fmd.rowid,fmd.attribute27) ld_attribute27, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE28',fmd.rowid,fmd.attribute28) ld_attribute28, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE29',fmd.rowid,fmd.attribute29) ld_attribute29, xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE30',fmd.rowid,fmd.attribute30) ld_attribute30, ffmv.formula_id, fmd.formulaline_id formula_line_id, decode(fmd.line_type,1,1,-1,2,2,3) line_type_sort from fm_form_mst_vl ffmv, fm_matl_dtl fmd, mtl_parameters mp, mtl_system_items_vl msiv where ffmv.formula_id=fmd.formula_id and ffmv.owner_organization_id=mp.organization_id and fmd.inventory_item_id=msiv.inventory_item_id and fmd.organization_id=msiv.organization_id and ffmv.delete_mark=0 and nvl(ffmv.inactive_ind,0)=0 and ffmv.owner_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 :p_upload_mode like '%'||xxen_upload.action_update ) x where 1=1 Initial version: OPM Formula Upload (header + ingredient/product/by-product lines + Formula and Formula Line DFF) via GMD_FORMULA_PUB / GMD_FORMULA_DETAIL_PUB. U A xxen_opm_upload.upload_formula US OPM Formula Upload OPM Formula Upload ================== Create or update Oracle Process Manufacturing (OPM / GMD) Formulas via the public API GMD_FORMULA_PUB / GMD_FORMULA_DETAIL_PUB. Row model ========= One spreadsheet row per formula LINE. The header columns (Organization Code, Formula, Formula Version, Description, Class, Owner, Header Scale Type, Status, header attributes) repeat on every line of the same formula. Each line carries its Line Type (Ingredient / Product / By-Product) plus its item, quantity, UOM, scale, and line attributes. Rows of the same formula (Organization Code + Formula + Formula Version) must be contiguous. Every formula must have at least one Ingredient AND at least one Product (OPM requirement) - a header-only formula is rejected. Upload modes ============ Create - empty template for new formulas. Create, Update - downloads existing formulas in the chosen organization for review/edit and allows adding new ones. Existing formulas are matched on Organization Code + Formula + Formula Version. Notes ===== - Items must be recipe-enabled in the owner organization. Detail UOM must be convertible from the item's primary UOM. - New formulas are created in status New (100); status changes are a workflow operation and are not driven by this upload. - On update, header description/class/owner and line quantities/attributes are updated; new lines are added. The owner organization and version are the key and cannot be changed. Enginatics Upload 1=1 :p_upload_mode 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 1=1 x.organization_code=:p_organization_code LOV custom Y select mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv, org_access_view oav where mp.process_enabled_flag='Y' and mp.organization_id=haouv.organization_id and mp.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id order by 1 US Organization Code 3 30 1=1 x.formula=:p_formula Char US Formula 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 UPLOAD_ROW Number number Y 6 ORGANIZATION_CODE LOV custom varchar2 3 Y select mp.organization_code id, mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv, org_access_view oav where mp.process_enabled_flag='Y' and mp.organization_id=haouv.organization_id and mp.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id order by 1 Y 7 FORMULA Char varchar2 32 Y 8 FORMULA_VERSION Number number Y 9 FORMULA_DESCRIPTION Char varchar2 240 Y 10 FORMULA_DESCRIPTION_2 Char varchar2 240 11 FORMULA_CLASS LOV custom varchar2 8 Y select ffc.formula_class id, ffc.formula_class value, ffc.formula_class_desc description from fm_form_cls ffc where ffc.delete_mark=0 order by 1 12 OWNER LOV custom varchar2 100 Y select fu.user_id id, fu.user_name value, fu.description from fnd_user fu where sysdate between fu.start_date and nvl(fu.end_date,sysdate+1) order by 2 13 HEADER_SCALE_TYPE LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='SCALE_TYPE' and flvv.view_application_id=552 and flvv.enabled_flag='Y' and flvv.lookup_code in ('0','1') and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 Y 14 CALCULATE_PRODUCT_QUANTITY LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 15 FORMULA_STATUS LOV custom varchar2 80 Y select gsv.status_code id, gsv.meaning value, gsv.description from gmd_status_vl gsv where to_number(gsv.status_code)<1000 order by 1 16 LINE_TYPE LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='GMD_FORMULA_ITEM_TYPE' and flvv.view_application_id=552 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 Y 17 LINE_NO Number number 18 ITEM LOV custom varchar2 40 Y select msiv.concatenated_segments id, msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and msiv.recipe_enabled_flag='Y' and msiv.serial_number_control_code in (1,6) order by 1 Y 19 ITEM_DESCRIPTION Char varchar2 240 select msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.concatenated_segments=:$column$.item and msiv.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code Y 20 REVISION LOV custom varchar2 3 Y select mir.revision id, mir.revision value, mir.description from mtl_item_revisions mir, mtl_system_items_vl msiv, mtl_parameters mp where mir.inventory_item_id=msiv.inventory_item_id and mir.organization_id=msiv.organization_id and msiv.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and msiv.concatenated_segments=:$column$.item order by 1 21 QUANTITY Number number Y 22 DETAIL_UOM LOV custom varchar2 3 Y select muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure description from mtl_units_of_measure_vl muomv where muomv.disable_date is null order by 1 select msiv.primary_uom_code from mtl_system_items_vl msiv, mtl_parameters mp where msiv.concatenated_segments=:$column$.item and msiv.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code Y 23 LINE_SCALE_TYPE LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='SCALE_TYPE' and flvv.view_application_id=552 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 Y 24 RELEASE_TYPE LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='GMD_MATERIAL_RELEASE_TYPE' and flvv.view_application_id=552 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 25 SCRAP_FACTOR Number number 26 PHANTOM_TYPE LOV custom varchar2 17 Y select 0 id, 'Not Phantom' value, null description from dual union all select 1 id, 'Automatic Phantom' value, null description from dual union all select 2 id, 'Manual Phantom' value, null description from dual 27 REWORK_TYPE LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='GMD_REWORK_TYPE' and flvv.view_application_id=552 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 28 CONTRIBUTE_TO_YIELD LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 29 CONTRIBUTE_TO_STEP_QUANTITY LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 30 COST_ALLOCATION Number number 31 PRODUCT_PERCENT Number number 32 BY_PRODUCT_TYPE LOV custom varchar2 Y select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='GMD_BY_PRODUCT_TYPE' and flvv.view_application_id=552 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 33 SCALE_MULTIPLE Number number 34 SCALE_ROUNDING_VARIANCE Number number 35 ROUNDING_DIRECTION LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='GMD_ROUNDING_DIRECTION' and flvv.view_application_id=552 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 36 INGREDIENT_END_DATE Date date 37 DELETE_LINE LOV custom varchar2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.formula_line_id is not null 38 FA_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=552 and fdfcv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by 2 39 FA_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE1' 40 FA_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE2' 41 FA_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE3' 42 FA_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE4' 43 FA_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE5' 44 FA_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE6' 45 FA_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE7' 46 FA_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE8' 47 FA_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE9' 48 FA_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE10' 49 FA_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE11' 50 FA_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE12' 51 FA_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE13' 52 FA_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE14' 53 FA_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE15' 54 FA_ATTRIBUTE16 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE16' 55 FA_ATTRIBUTE17 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE17' 56 FA_ATTRIBUTE18 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE18' 57 FA_ATTRIBUTE19 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE19' 58 FA_ATTRIBUTE20 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE20' 59 FA_ATTRIBUTE21 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE21' 60 FA_ATTRIBUTE22 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE22' 61 FA_ATTRIBUTE23 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE23' 62 FA_ATTRIBUTE24 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE24' 63 FA_ATTRIBUTE25 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE25' 64 FA_ATTRIBUTE26 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE26' 65 FA_ATTRIBUTE27 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE27' 66 FA_ATTRIBUTE28 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE28' 67 FA_ATTRIBUTE29 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE29' 68 FA_ATTRIBUTE30 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FORMULA_FLEX', p_context_name=>:$column$.fa_attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.fa_attribute1, p_attribute2=>:$column$.fa_attribute2, p_attribute3=>:$column$.fa_attribute3, p_attribute4=>:$column$.fa_attribute4, p_attribute5=>:$column$.fa_attribute5, p_attribute6=>:$column$.fa_attribute6, p_attribute7=>:$column$.fa_attribute7, p_attribute8=>:$column$.fa_attribute8, p_attribute9=>:$column$.fa_attribute9, p_attribute10=>:$column$.fa_attribute10, p_attribute11=>:$column$.fa_attribute11, p_attribute12=>:$column$.fa_attribute12, p_attribute13=>:$column$.fa_attribute13, p_attribute14=>:$column$.fa_attribute14, p_attribute15=>:$column$.fa_attribute15, p_attribute16=>:$column$.fa_attribute16, p_attribute17=>:$column$.fa_attribute17, p_attribute18=>:$column$.fa_attribute18, p_attribute19=>:$column$.fa_attribute19, p_attribute20=>:$column$.fa_attribute20, p_attribute21=>:$column$.fa_attribute21, p_attribute22=>:$column$.fa_attribute22, p_attribute23=>:$column$.fa_attribute23, p_attribute24=>:$column$.fa_attribute24, p_attribute25=>:$column$.fa_attribute25, p_attribute26=>:$column$.fa_attribute26, p_attribute27=>:$column$.fa_attribute27, p_attribute28=>:$column$.fa_attribute28, p_attribute29=>:$column$.fa_attribute29, p_attribute30=>:$column$.fa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FORMULA_FLEX' and fdfcuv.application_column_name='ATTRIBUTE30' 69 LD_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=552 and fdfcv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by 2 70 LD_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE1' 71 LD_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE2' 72 LD_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE3' 73 LD_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE4' 74 LD_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE5' 75 LD_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE6' 76 LD_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE7' 77 LD_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE8' 78 LD_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE9' 79 LD_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE10' 80 LD_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE11' 81 LD_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE12' 82 LD_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE13' 83 LD_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE14' 84 LD_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE15' 85 LD_ATTRIBUTE16 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE16' 86 LD_ATTRIBUTE17 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE17' 87 LD_ATTRIBUTE18 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE18' 88 LD_ATTRIBUTE19 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE19' 89 LD_ATTRIBUTE20 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE20' 90 LD_ATTRIBUTE21 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE21' 91 LD_ATTRIBUTE22 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE22' 92 LD_ATTRIBUTE23 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE23' 93 LD_ATTRIBUTE24 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE24' 94 LD_ATTRIBUTE25 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE25' 95 LD_ATTRIBUTE26 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE26' 96 LD_ATTRIBUTE27 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE27' 97 LD_ATTRIBUTE28 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE28' 98 LD_ATTRIBUTE29 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE29' 99 LD_ATTRIBUTE30 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_DETAIL_FLEX', p_context_name=>:$column$.ld_attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.ld_attribute1, p_attribute2=>:$column$.ld_attribute2, p_attribute3=>:$column$.ld_attribute3, p_attribute4=>:$column$.ld_attribute4, p_attribute5=>:$column$.ld_attribute5, p_attribute6=>:$column$.ld_attribute6, p_attribute7=>:$column$.ld_attribute7, p_attribute8=>:$column$.ld_attribute8, p_attribute9=>:$column$.ld_attribute9, p_attribute10=>:$column$.ld_attribute10, p_attribute11=>:$column$.ld_attribute11, p_attribute12=>:$column$.ld_attribute12, p_attribute13=>:$column$.ld_attribute13, p_attribute14=>:$column$.ld_attribute14, p_attribute15=>:$column$.ld_attribute15, p_attribute16=>:$column$.ld_attribute16, p_attribute17=>:$column$.ld_attribute17, p_attribute18=>:$column$.ld_attribute18, p_attribute19=>:$column$.ld_attribute19, p_attribute20=>:$column$.ld_attribute20, p_attribute21=>:$column$.ld_attribute21, p_attribute22=>:$column$.ld_attribute22, p_attribute23=>:$column$.ld_attribute23, p_attribute24=>:$column$.ld_attribute24, p_attribute25=>:$column$.ld_attribute25, p_attribute26=>:$column$.ld_attribute26, p_attribute27=>:$column$.ld_attribute27, p_attribute28=>:$column$.ld_attribute28, p_attribute29=>:$column$.ld_attribute29, p_attribute30=>:$column$.ld_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_DETAIL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE30' 100 FORMULA_ID Number number Y 101 FORMULA_LINE_ID Number number Y Error SQL Order By upload_row Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, nvl(xu.mp_organization_code, xu.organization_code) organization_code, nvl(xu.ffmv_formula_no, xu.formula) formula, nvl(xu.ffmv_formula_vers, xu.formula_version) formula_version, nvl(xu.ffmv_formula_desc1, xu.formula_description) formula_description, nvl(xu.ffmv_formula_desc2, xu.formula_description_2) formula_description_2, nvl(xu.ffmv_formula_class, xu.formula_class) formula_class, nvl((select fu.user_name from fnd_user fu where fu.user_id=xu.ffmv_owner_id), xu.owner) owner, nvl(xxen_util.meaning(to_char(xu.ffmv_scale_type),'SCALE_TYPE',552), xu.header_scale_type) header_scale_type, nvl(xxen_util.meaning(xu.ffmv_auto_product_calc,'YES_NO',552), xu.calculate_product_quantity) calculate_product_quantity, nvl((select gsv.meaning from gmd_status_vl gsv where gsv.status_code=xu.ffmv_formula_status), xu.formula_status) formula_status, nvl(xxen_util.meaning(to_char(fmd.line_type),'GMD_FORMULA_ITEM_TYPE',552), xu.line_type) line_type, nvl(fmd.line_no, xu.line_no) line_no, nvl(xu.msiv_concatenated_segments, xu.item) item, nvl(xu.msiv_description, xu.item_description) item_description, nvl(fmd.revision, xu.revision) revision, nvl(fmd.qty, xu.quantity) quantity, nvl(fmd.detail_uom, xu.detail_uom) detail_uom, nvl(xxen_util.meaning(to_char(fmd.scale_type),'SCALE_TYPE',552), xu.line_scale_type) line_scale_type, nvl(xxen_util.meaning(to_char(fmd.release_type),'GMD_MATERIAL_RELEASE_TYPE',552), xu.release_type) release_type, nvl(fmd.scrap_factor, xu.scrap_factor) scrap_factor, nvl(decode(fmd.phantom_type,0,'Not Phantom',1,'Automatic Phantom',2,'Manual Phantom'), xu.phantom_type) phantom_type, nvl(xxen_util.meaning(to_char(fmd.rework_type),'GMD_REWORK_TYPE',552), xu.rework_type) rework_type, nvl(xxen_util.meaning(fmd.contribute_yield_ind,'YES_NO',552), xu.contribute_to_yield) contribute_to_yield, nvl(xxen_util.meaning(fmd.contribute_step_qty_ind,'YES_NO',552), xu.contribute_to_step_quantity) contribute_to_step_quantity, nvl(fmd.cost_alloc, xu.cost_allocation) cost_allocation, nvl(fmd.prod_percent, xu.product_percent) product_percent, nvl(xxen_util.meaning(fmd.by_product_type,'GMD_BY_PRODUCT_TYPE',552), xu.by_product_type) by_product_type, nvl(fmd.scale_multiple, xu.scale_multiple) scale_multiple, nvl(fmd.scale_rounding_variance, xu.scale_rounding_variance) scale_rounding_variance, nvl(xxen_util.meaning(to_char(fmd.rounding_direction),'GMD_ROUNDING_DIRECTION',552), xu.rounding_direction) rounding_direction, nvl(fmd.ingredient_end_date, xu.ingredient_end_date) ingredient_end_date, nvl(to_char(null), xu.delete_line) delete_line, nvl(xxen_util.display_flexfield_context(552,'FORMULA_FLEX',xu.ffmv_attribute_category), xu.fa_attribute_category) fa_attribute_category, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE1',xu.ffmv_rowid,xu.ffmv_attribute1), xu.fa_attribute1) fa_attribute1, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE2',xu.ffmv_rowid,xu.ffmv_attribute2), xu.fa_attribute2) fa_attribute2, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE3',xu.ffmv_rowid,xu.ffmv_attribute3), xu.fa_attribute3) fa_attribute3, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE4',xu.ffmv_rowid,xu.ffmv_attribute4), xu.fa_attribute4) fa_attribute4, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE5',xu.ffmv_rowid,xu.ffmv_attribute5), xu.fa_attribute5) fa_attribute5, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE6',xu.ffmv_rowid,xu.ffmv_attribute6), xu.fa_attribute6) fa_attribute6, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE7',xu.ffmv_rowid,xu.ffmv_attribute7), xu.fa_attribute7) fa_attribute7, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE8',xu.ffmv_rowid,xu.ffmv_attribute8), xu.fa_attribute8) fa_attribute8, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE9',xu.ffmv_rowid,xu.ffmv_attribute9), xu.fa_attribute9) fa_attribute9, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE10',xu.ffmv_rowid,xu.ffmv_attribute10), xu.fa_attribute10) fa_attribute10, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE11',xu.ffmv_rowid,xu.ffmv_attribute11), xu.fa_attribute11) fa_attribute11, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE12',xu.ffmv_rowid,xu.ffmv_attribute12), xu.fa_attribute12) fa_attribute12, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE13',xu.ffmv_rowid,xu.ffmv_attribute13), xu.fa_attribute13) fa_attribute13, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE14',xu.ffmv_rowid,xu.ffmv_attribute14), xu.fa_attribute14) fa_attribute14, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE15',xu.ffmv_rowid,xu.ffmv_attribute15), xu.fa_attribute15) fa_attribute15, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE16',xu.ffmv_rowid,xu.ffmv_attribute16), xu.fa_attribute16) fa_attribute16, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE17',xu.ffmv_rowid,xu.ffmv_attribute17), xu.fa_attribute17) fa_attribute17, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE18',xu.ffmv_rowid,xu.ffmv_attribute18), xu.fa_attribute18) fa_attribute18, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE19',xu.ffmv_rowid,xu.ffmv_attribute19), xu.fa_attribute19) fa_attribute19, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE20',xu.ffmv_rowid,xu.ffmv_attribute20), xu.fa_attribute20) fa_attribute20, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE21',xu.ffmv_rowid,xu.ffmv_attribute21), xu.fa_attribute21) fa_attribute21, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE22',xu.ffmv_rowid,xu.ffmv_attribute22), xu.fa_attribute22) fa_attribute22, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE23',xu.ffmv_rowid,xu.ffmv_attribute23), xu.fa_attribute23) fa_attribute23, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE24',xu.ffmv_rowid,xu.ffmv_attribute24), xu.fa_attribute24) fa_attribute24, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE25',xu.ffmv_rowid,xu.ffmv_attribute25), xu.fa_attribute25) fa_attribute25, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE26',xu.ffmv_rowid,xu.ffmv_attribute26), xu.fa_attribute26) fa_attribute26, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE27',xu.ffmv_rowid,xu.ffmv_attribute27), xu.fa_attribute27) fa_attribute27, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE28',xu.ffmv_rowid,xu.ffmv_attribute28), xu.fa_attribute28) fa_attribute28, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE29',xu.ffmv_rowid,xu.ffmv_attribute29), xu.fa_attribute29) fa_attribute29, nvl(xxen_util.display_flexfield_value(552,'FORMULA_FLEX',xu.ffmv_attribute_category,'ATTRIBUTE30',xu.ffmv_rowid,xu.ffmv_attribute30), xu.fa_attribute30) fa_attribute30, nvl(xxen_util.display_flexfield_context(552,'FM_DETAIL_FLEX',fmd.attribute_category), xu.ld_attribute_category) ld_attribute_category, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE1',fmd.rowid,fmd.attribute1), xu.ld_attribute1) ld_attribute1, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE2',fmd.rowid,fmd.attribute2), xu.ld_attribute2) ld_attribute2, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE3',fmd.rowid,fmd.attribute3), xu.ld_attribute3) ld_attribute3, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE4',fmd.rowid,fmd.attribute4), xu.ld_attribute4) ld_attribute4, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE5',fmd.rowid,fmd.attribute5), xu.ld_attribute5) ld_attribute5, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE6',fmd.rowid,fmd.attribute6), xu.ld_attribute6) ld_attribute6, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE7',fmd.rowid,fmd.attribute7), xu.ld_attribute7) ld_attribute7, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE8',fmd.rowid,fmd.attribute8), xu.ld_attribute8) ld_attribute8, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE9',fmd.rowid,fmd.attribute9), xu.ld_attribute9) ld_attribute9, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE10',fmd.rowid,fmd.attribute10), xu.ld_attribute10) ld_attribute10, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE11',fmd.rowid,fmd.attribute11), xu.ld_attribute11) ld_attribute11, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE12',fmd.rowid,fmd.attribute12), xu.ld_attribute12) ld_attribute12, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE13',fmd.rowid,fmd.attribute13), xu.ld_attribute13) ld_attribute13, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE14',fmd.rowid,fmd.attribute14), xu.ld_attribute14) ld_attribute14, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE15',fmd.rowid,fmd.attribute15), xu.ld_attribute15) ld_attribute15, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE16',fmd.rowid,fmd.attribute16), xu.ld_attribute16) ld_attribute16, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE17',fmd.rowid,fmd.attribute17), xu.ld_attribute17) ld_attribute17, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE18',fmd.rowid,fmd.attribute18), xu.ld_attribute18) ld_attribute18, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE19',fmd.rowid,fmd.attribute19), xu.ld_attribute19) ld_attribute19, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE20',fmd.rowid,fmd.attribute20), xu.ld_attribute20) ld_attribute20, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE21',fmd.rowid,fmd.attribute21), xu.ld_attribute21) ld_attribute21, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE22',fmd.rowid,fmd.attribute22), xu.ld_attribute22) ld_attribute22, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE23',fmd.rowid,fmd.attribute23), xu.ld_attribute23) ld_attribute23, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE24',fmd.rowid,fmd.attribute24), xu.ld_attribute24) ld_attribute24, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE25',fmd.rowid,fmd.attribute25), xu.ld_attribute25) ld_attribute25, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE26',fmd.rowid,fmd.attribute26), xu.ld_attribute26) ld_attribute26, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE27',fmd.rowid,fmd.attribute27), xu.ld_attribute27) ld_attribute27, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE28',fmd.rowid,fmd.attribute28), xu.ld_attribute28) ld_attribute28, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE29',fmd.rowid,fmd.attribute29), xu.ld_attribute29) ld_attribute29, nvl(xxen_util.display_flexfield_value(552,'FM_DETAIL_FLEX',fmd.attribute_category,'ATTRIBUTE30',fmd.rowid,fmd.attribute30), xu.ld_attribute30) ld_attribute30, nvl(xu.ffmv_formula_id, xu.formula_id) formula_id, nvl(fmd.formulaline_id, xu.formula_line_id) formula_line_id from ( select ffmv.attribute1 ffmv_attribute1, ffmv.attribute10 ffmv_attribute10, ffmv.attribute11 ffmv_attribute11, ffmv.attribute12 ffmv_attribute12, ffmv.attribute13 ffmv_attribute13, ffmv.attribute14 ffmv_attribute14, ffmv.attribute15 ffmv_attribute15, ffmv.attribute16 ffmv_attribute16, ffmv.attribute17 ffmv_attribute17, ffmv.attribute18 ffmv_attribute18, ffmv.attribute19 ffmv_attribute19, ffmv.attribute2 ffmv_attribute2, ffmv.attribute20 ffmv_attribute20, ffmv.attribute21 ffmv_attribute21, ffmv.attribute22 ffmv_attribute22, ffmv.attribute23 ffmv_attribute23, ffmv.attribute24 ffmv_attribute24, ffmv.attribute25 ffmv_attribute25, ffmv.attribute26 ffmv_attribute26, ffmv.attribute27 ffmv_attribute27, ffmv.attribute28 ffmv_attribute28, ffmv.attribute29 ffmv_attribute29, ffmv.attribute3 ffmv_attribute3, ffmv.attribute30 ffmv_attribute30, ffmv.attribute4 ffmv_attribute4, ffmv.attribute5 ffmv_attribute5, ffmv.attribute6 ffmv_attribute6, ffmv.attribute7 ffmv_attribute7, ffmv.attribute8 ffmv_attribute8, ffmv.attribute9 ffmv_attribute9, ffmv.attribute_category ffmv_attribute_category, ffmv.auto_product_calc ffmv_auto_product_calc, ffmv.formula_class ffmv_formula_class, ffmv.formula_desc1 ffmv_formula_desc1, ffmv.formula_desc2 ffmv_formula_desc2, ffmv.formula_id ffmv_formula_id, ffmv.formula_no ffmv_formula_no, ffmv.formula_status ffmv_formula_status, ffmv.formula_vers ffmv_formula_vers, ffmv.owner_id ffmv_owner_id, ffmv.rowid ffmv_rowid, ffmv.scale_type ffmv_scale_type, msiv.concatenated_segments msiv_concatenated_segments, msiv.description msiv_description, msiv.inventory_item_id msiv_inventory_item_id, msiv.organization_id msiv_organization_id, xu.action_, xu.by_product_type, xu.calculate_product_quantity, xu.contribute_to_step_quantity, xu.contribute_to_yield, xu.cost_allocation, xu.delete_line, xu.detail_uom, xu.fa_attribute1, xu.fa_attribute10, xu.fa_attribute11, xu.fa_attribute12, xu.fa_attribute13, xu.fa_attribute14, xu.fa_attribute15, xu.fa_attribute16, xu.fa_attribute17, xu.fa_attribute18, xu.fa_attribute19, xu.fa_attribute2, xu.fa_attribute20, xu.fa_attribute21, xu.fa_attribute22, xu.fa_attribute23, xu.fa_attribute24, xu.fa_attribute25, xu.fa_attribute26, xu.fa_attribute27, xu.fa_attribute28, xu.fa_attribute29, xu.fa_attribute3, xu.fa_attribute30, xu.fa_attribute4, xu.fa_attribute5, xu.fa_attribute6, xu.fa_attribute7, xu.fa_attribute8, xu.fa_attribute9, xu.fa_attribute_category, xu.formula, xu.formula_class, xu.formula_description, xu.formula_description_2, xu.formula_id, xu.formula_line_id, xu.formula_status, xu.formula_version, xu.header_scale_type, xu.ingredient_end_date, xu.item, xu.item_description, xu.ld_attribute1, xu.ld_attribute10, xu.ld_attribute11, xu.ld_attribute12, xu.ld_attribute13, xu.ld_attribute14, xu.ld_attribute15, xu.ld_attribute16, xu.ld_attribute17, xu.ld_attribute18, xu.ld_attribute19, xu.ld_attribute2, xu.ld_attribute20, xu.ld_attribute21, xu.ld_attribute22, xu.ld_attribute23, xu.ld_attribute24, xu.ld_attribute25, xu.ld_attribute26, xu.ld_attribute27, xu.ld_attribute28, xu.ld_attribute29, xu.ld_attribute3, xu.ld_attribute30, xu.ld_attribute4, xu.ld_attribute5, xu.ld_attribute6, xu.ld_attribute7, xu.ld_attribute8, xu.ld_attribute9, xu.ld_attribute_category, xu.line_no, xu.line_scale_type, xu.line_type, xu.message_, xu.modified_columns_, xu.mp_organization_code, xu.organization_code, xu.owner, xu.phantom_type, xu.product_percent, xu.quantity, xu.release_type, xu.revision, xu.rework_type, xu.rounding_direction, xu.scale_multiple, xu.scale_rounding_variance, xu.scrap_factor, xu.status_, xu.upload_row from ( select mp.organization_code mp_organization_code, mp.organization_id mp_organization_id, xu.action_, xu.by_product_type, xu.calculate_product_quantity, xu.contribute_to_step_quantity, xu.contribute_to_yield, xu.cost_allocation, xu.delete_line, xu.detail_uom, xu.fa_attribute1, xu.fa_attribute10, xu.fa_attribute11, xu.fa_attribute12, xu.fa_attribute13, xu.fa_attribute14, xu.fa_attribute15, xu.fa_attribute16, xu.fa_attribute17, xu.fa_attribute18, xu.fa_attribute19, xu.fa_attribute2, xu.fa_attribute20, xu.fa_attribute21, xu.fa_attribute22, xu.fa_attribute23, xu.fa_attribute24, xu.fa_attribute25, xu.fa_attribute26, xu.fa_attribute27, xu.fa_attribute28, xu.fa_attribute29, xu.fa_attribute3, xu.fa_attribute30, xu.fa_attribute4, xu.fa_attribute5, xu.fa_attribute6, xu.fa_attribute7, xu.fa_attribute8, xu.fa_attribute9, xu.fa_attribute_category, xu.formula, xu.formula_class, xu.formula_description, xu.formula_description_2, xu.formula_id, xu.formula_line_id, xu.formula_status, xu.formula_version, xu.header_scale_type, xu.ingredient_end_date, xu.item, xu.item_description, xu.ld_attribute1, xu.ld_attribute10, xu.ld_attribute11, xu.ld_attribute12, xu.ld_attribute13, xu.ld_attribute14, xu.ld_attribute15, xu.ld_attribute16, xu.ld_attribute17, xu.ld_attribute18, xu.ld_attribute19, xu.ld_attribute2, xu.ld_attribute20, xu.ld_attribute21, xu.ld_attribute22, xu.ld_attribute23, xu.ld_attribute24, xu.ld_attribute25, xu.ld_attribute26, xu.ld_attribute27, xu.ld_attribute28, xu.ld_attribute29, xu.ld_attribute3, xu.ld_attribute30, xu.ld_attribute4, xu.ld_attribute5, xu.ld_attribute6, xu.ld_attribute7, xu.ld_attribute8, xu.ld_attribute9, xu.ld_attribute_category, xu.line_no, xu.line_scale_type, xu.line_type, xu.message_, xu.modified_columns_, xu.organization_code, xu.owner, xu.phantom_type, xu.product_percent, xu.quantity, xu.release_type, xu.revision, xu.rework_type, xu.rounding_direction, xu.scale_multiple, xu.scale_rounding_variance, xu.scrap_factor, xu.status_, xu.upload_row from xxen_opm_formula_upload_5639_u xu, mtl_parameters mp where mp.organization_code(+)=xu.organization_code and xu.status_code_=xxen_upload.status_success ) xu, --before 12c an outer joined table may reference at most one other table, so the driving tables are wrapped fm_form_mst_vl ffmv, mtl_system_items_vl msiv where ffmv.formula_no(+)=upper(xu.formula) and ffmv.formula_vers(+)=xu.formula_version and ffmv.owner_organization_id(+)=xu.mp_organization_id and msiv.concatenated_segments(+)=xu.item and msiv.organization_id(+)=xu.mp_organization_id ) xu, --before 12c an outer joined table may reference at most one other table, so the driving tables are wrapped fm_matl_dtl fmd where fmd.formula_id(+)=xu.ffmv_formula_id and fmd.line_type(+)=to_number(xxen_util.lookup_code(xu.line_type,'GMD_FORMULA_ITEM_TYPE',552)) and fmd.inventory_item_id(+)=xu.msiv_inventory_item_id and fmd.organization_id(+)=xu.msiv_organization_id