ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 21C99A1E597940D9A4E48EF156ACF863Y select null action_, null status_, null message_, null modified_columns_, x.*, to_number(null) upload_row from ( select cad.cost_adjust_id, mp.organization_code, msiv.concatenated_segments item, msiv.description item_description, gps.calendar_code calendar, gps.period_code period, cmm.cost_mthd_code cost_type, xxen_opm_upload.adjustment_type(cad.adjustment_ind) adjustment_type, ccmv.cost_cmpntcls_code component_class, cad.cost_analysis_code analysis_code, cad.adjust_qty quantity, cad.adjust_qty_uom uom, cad.adjust_cost cost, cad.reason_code, xxen_util.yes(decode(cad.subledger_ind,1,'Y')) subledger_entry, cad.adjustment_date gl_date, xxen_opm_upload.adjustment_status(cad.adjust_status) adjustment_status, null delete_adjustment, xxen_util.display_flexfield_context(555,'ADJ_DTL_FLEX',cad.attribute_category) adj_attribute_category, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE1',cad.rowid,cad.attribute1) adj_attribute1, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE2',cad.rowid,cad.attribute2) adj_attribute2, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE3',cad.rowid,cad.attribute3) adj_attribute3, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE4',cad.rowid,cad.attribute4) adj_attribute4, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE5',cad.rowid,cad.attribute5) adj_attribute5, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE6',cad.rowid,cad.attribute6) adj_attribute6, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE7',cad.rowid,cad.attribute7) adj_attribute7, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE8',cad.rowid,cad.attribute8) adj_attribute8, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE9',cad.rowid,cad.attribute9) adj_attribute9, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE10',cad.rowid,cad.attribute10) adj_attribute10, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE11',cad.rowid,cad.attribute11) adj_attribute11, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE12',cad.rowid,cad.attribute12) adj_attribute12, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE13',cad.rowid,cad.attribute13) adj_attribute13, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE14',cad.rowid,cad.attribute14) adj_attribute14, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE15',cad.rowid,cad.attribute15) adj_attribute15, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE16',cad.rowid,cad.attribute16) adj_attribute16, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE17',cad.rowid,cad.attribute17) adj_attribute17, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE18',cad.rowid,cad.attribute18) adj_attribute18, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE19',cad.rowid,cad.attribute19) adj_attribute19, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE20',cad.rowid,cad.attribute20) adj_attribute20, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE21',cad.rowid,cad.attribute21) adj_attribute21, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE22',cad.rowid,cad.attribute22) adj_attribute22, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE23',cad.rowid,cad.attribute23) adj_attribute23, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE24',cad.rowid,cad.attribute24) adj_attribute24, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE25',cad.rowid,cad.attribute25) adj_attribute25, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE26',cad.rowid,cad.attribute26) adj_attribute26, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE27',cad.rowid,cad.attribute27) adj_attribute27, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE28',cad.rowid,cad.attribute28) adj_attribute28, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE29',cad.rowid,cad.attribute29) adj_attribute29, xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE30',cad.rowid,cad.attribute30) adj_attribute30 from mtl_parameters mp, cm_adjs_dtl cad, mtl_system_items_vl msiv, gmf_period_statuses gps, cm_mthd_mst cmm, cm_cmpt_mst_vl ccmv where mp.process_enabled_flag='Y' and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=cad.organization_id and cad.delete_mark=0 and cad.inventory_item_id=msiv.inventory_item_id and cad.organization_id=msiv.organization_id and cad.period_id=gps.period_id and cad.cost_type_id=cmm.cost_type_id and cad.cost_cmpntcls_id=ccmv.cost_cmpntcls_id ) x where 1=1 Initial version U A xxen_opm_upload.upload_actual_cost_adj xxen_opm_upload.validate_actual_cost_adj(p_organization_code=>:$column$.organization_code,p_calendar=>:$column$.calendar,p_period=>:$column$.period,p_cost_type=>:$column$.cost_type,p_adjustment_type=>:$column$.adjustment_type,p_quantity=>:$column$.quantity) US OPM Actual Cost Adjustment Upload Upload to create, update and delete OPM actual cost adjustments per organization, item, calendar period, cost type, component class, analysis code and adjustment type, as in the Actual Cost Adjustments form. The adjustments are applied by the next actual cost process. Quantity applies to average cost adjustments only and is stored as zero for value and unit cost adjustments. A subledger entry is dated within the period, by default on its first day. Delete marks an adjustment for purge, as the form does. Adjustments posted to GL, and those of frozen or closed periods, cannot be changed. Changing an applied adjustment sets its status to Modified. Enginatics R12 only Upload 1=1 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode 2 20 1=1 x.organization_code=:organization_code LOV OPM Process Organization Code ACF3E7BB598148D981F7A541C18B0D60 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 US Organization Code 3 30 1=1 x.calendar=:calendar LOV custom select cchv.calendar_code value, cchv.calendar_desc description from cm_cldr_hdr_vl cchv where cchv.delete_mark=0 order by cchv.calendar_code US Calendar 4 40 1=1 x.period=:period LOV custom select ccd.period_code value, ccd.period_desc description from cm_cldr_dtl ccd where ccd.calendar_code=:$flex$.calendar and ccd.delete_mark=0 order by ccd.start_date US Period 5 50 1=1 x.cost_type=:cost_type LOV custom select cmm.cost_mthd_code value, cmm.cost_mthd_desc description from cm_mthd_mst cmm where cmm.cost_type=1 and cmm.delete_mark=0 order by cmm.cost_mthd_code US Cost Type 6 60 1=1 x.item=:item LOV custom select distinct msiv.concatenated_segments value, msiv.description from mtl_parameters mp, cm_adjs_dtl cad, mtl_system_items_vl msiv where (:$flex$.organization_code is null or mp.organization_code=:$flex$.organization_code) and mp.process_enabled_flag='Y' and mp.organization_id=cad.organization_id and cad.inventory_item_id=msiv.inventory_item_id and cad.organization_id=msiv.organization_id order by msiv.concatenated_segments US Item D6539DCB02854379ACD257F386B74BC4 Create Empty sheet to enter new actual cost adjustments. ENGINATICS 7 ADJUSTMENT_TYPE Y 9 ANALYSIS_CODE 4 CALENDAR 8 COMPONENT_CLASS 12 COST 6 COST_TYPE 15 GL_DATE 2 ITEM 3 ITEM_DESCRIPTION 1 ORGANIZATION_CODE 5 PERIOD 10 QUANTITY 13 REASON_CODE 14 SUBLEDGER_ENTRY 11 UOM Upload Mode C Y S Site Calendar Cost Type Item Organization Code Period 41242CB5DC664C099A8E539802A08578 Default Creates, updates and deletes actual cost adjustments with the fields of the Actual Cost Adjustments form, without the flexfield. ENGINATICS 16 ADJUSTMENT_STATUS 7 ADJUSTMENT_TYPE Y 9 ANALYSIS_CODE 4 CALENDAR 8 COMPONENT_CLASS 12 COST 6 COST_TYPE 17 DELETE_ADJUSTMENT 15 GL_DATE 2 ITEM 3 ITEM_DESCRIPTION 1 ORGANIZATION_CODE 5 PERIOD 10 QUANTITY 13 REASON_CODE 14 SUBLEDGER_ENTRY 11 UOM Upload Mode C,U S Site 2060A05D25A74B71ABE76AC19EA17ECF Flexfield Maintains the descriptive flexfield of existing actual cost adjustments. ENGINATICS 6 ADJUSTMENT_TYPE Y 10 ADJ_ATTRIBUTE1 19 ADJ_ATTRIBUTE10 20 ADJ_ATTRIBUTE11 21 ADJ_ATTRIBUTE12 22 ADJ_ATTRIBUTE13 23 ADJ_ATTRIBUTE14 24 ADJ_ATTRIBUTE15 25 ADJ_ATTRIBUTE16 26 ADJ_ATTRIBUTE17 27 ADJ_ATTRIBUTE18 28 ADJ_ATTRIBUTE19 11 ADJ_ATTRIBUTE2 29 ADJ_ATTRIBUTE20 30 ADJ_ATTRIBUTE21 31 ADJ_ATTRIBUTE22 32 ADJ_ATTRIBUTE23 33 ADJ_ATTRIBUTE24 34 ADJ_ATTRIBUTE25 35 ADJ_ATTRIBUTE26 36 ADJ_ATTRIBUTE27 37 ADJ_ATTRIBUTE28 38 ADJ_ATTRIBUTE29 12 ADJ_ATTRIBUTE3 39 ADJ_ATTRIBUTE30 13 ADJ_ATTRIBUTE4 14 ADJ_ATTRIBUTE5 15 ADJ_ATTRIBUTE6 16 ADJ_ATTRIBUTE7 17 ADJ_ATTRIBUTE8 18 ADJ_ATTRIBUTE9 9 ADJ_ATTRIBUTE_CATEGORY 8 ANALYSIS_CODE 3 CALENDAR 7 COMPONENT_CLASS 5 COST_TYPE 2 ITEM 1 ORGANIZATION_CODE 4 PERIOD Upload Mode C,U S Site 41242CB5DC664C099A8E539802A08578 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 COST_ADJUST_ID Number number Y 6 ORGANIZATION_CODE LOV varchar2 3 OPM Process Organization Code ACF3E7BB598148D981F7A541C18B0D60 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 ITEM LOV custom varchar2 40 select msiv.inventory_item_id id, msiv.concatenated_segments value, msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.inventory_asset_flag='Y' order by msiv.concatenated_segments Y 8 ITEM_DESCRIPTION Char varchar2 240 select msiv.description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item Y 9 CALENDAR LOV custom varchar2 10 select cchv.calendar_code value, cchv.calendar_desc description from cm_cldr_hdr_vl cchv where cchv.delete_mark=0 and cchv.calendar_code in ( select gps.calendar_code from mtl_parameters mp, hr_organization_information hoi, gmf_period_statuses gps where mp.organization_code=:$column$.organization_code and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and to_number(hoi.org_information2)=gps.legal_entity_id and gps.delete_mark=0 ) order by cchv.calendar_code Y 10 PERIOD LOV custom varchar2 10 select ccd.period_code value, ccd.period_desc description from cm_cldr_dtl ccd where ccd.calendar_code=:$column$.calendar and ccd.delete_mark=0 order by ccd.start_date Y 11 COST_TYPE LOV custom varchar2 10 select cmm.cost_type_id id, cmm.cost_mthd_code value, cmm.cost_mthd_desc description from cm_mthd_mst cmm where cmm.cost_type=1 and cmm.delete_mark=0 and cmm.cost_type_id in ( select gps.cost_type_id from mtl_parameters mp, hr_organization_information hoi, gmf_period_statuses gps where mp.organization_code=:$column$.organization_code and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and to_number(hoi.org_information2)=gps.legal_entity_id and gps.calendar_code=:$column$.calendar and gps.period_code=:$column$.period and gps.delete_mark=0 ) order by cmm.cost_mthd_code Y 12 ADJUSTMENT_TYPE LOV custom varchar2 select 0 id, xxen_opm_upload.adjustment_type(0) value, null description from dual union all select 1 id, xxen_opm_upload.adjustment_type(1) value, null description from dual union all select 2 id, xxen_opm_upload.adjustment_type(2) value, null description from dual xxen_opm_upload.adjustment_type(0) Y 13 COMPONENT_CLASS LOV custom varchar2 32 select ccmv.cost_cmpntcls_id id, ccmv.cost_cmpntcls_code value, ccmv.cost_cmpntcls_desc description from cm_cmpt_mst_vl ccmv where ccmv.delete_mark=0 and ccmv.usage_ind<>5 order by ccmv.cost_cmpntcls_code Y 14 ANALYSIS_CODE LOV custom varchar2 32 select cam.cost_analysis_code value, cam.cost_analysis_desc description from cm_alys_mst cam where cam.delete_mark=0 order by cam.cost_analysis_code Y 15 QUANTITY Number number 16 UOM LOV custom varchar2 3 select muomv.uom_code value, muomv.unit_of_measure description from mtl_units_of_measure_vl muomv order by muomv.uom_code select msiv.primary_uom_code from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and mp.organization_id=msiv.organization_id and msiv.concatenated_segments=:$column$.item Y 17 COST Number number Y 18 REASON_CODE LOV custom varchar2 4 select crc.reason_code value, crc.reason_desc description from cm_reas_cds crc where crc.delete_mark=0 order by crc.reason_code Y 19 SUBLEDGER_ENTRY LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual select xxen_util.meaning('Y','YES_NO',0) from cm_reas_cds crc where crc.reason_code=:$column$.reason_code and crc.subledger_ind=1 20 GL_DATE Date date select gps.start_date from mtl_parameters mp, hr_organization_information hoi, gmf_period_statuses gps, cm_mthd_mst cmm where :$column$.subledger_entry=xxen_util.meaning('Y','YES_NO',0) and mp.organization_code=:$column$.organization_code and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and to_number(hoi.org_information2)=gps.legal_entity_id and gps.calendar_code=:$column$.calendar and gps.period_code=:$column$.period and gps.cost_type_id=cmm.cost_type_id and cmm.cost_mthd_code=:$column$.cost_type and gps.delete_mark=0 21 ADJUSTMENT_STATUS Char varchar2 xxen_opm_upload.adjustment_status(0) Y 22 DELETE_ADJUSTMENT LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.cost_adjust_id is not null 23 ADJ_ATTRIBUTE_CATEGORY LOV custom varchar2 30 select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=555 and fdfcv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 24 ADJ_ATTRIBUTE1 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE1' 25 ADJ_ATTRIBUTE2 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE2' 26 ADJ_ATTRIBUTE3 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE3' 27 ADJ_ATTRIBUTE4 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE4' 28 ADJ_ATTRIBUTE5 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE5' 29 ADJ_ATTRIBUTE6 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE6' 30 ADJ_ATTRIBUTE7 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE7' 31 ADJ_ATTRIBUTE8 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE8' 32 ADJ_ATTRIBUTE9 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE9' 33 ADJ_ATTRIBUTE10 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE10' 34 ADJ_ATTRIBUTE11 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE11' 35 ADJ_ATTRIBUTE12 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE12' 36 ADJ_ATTRIBUTE13 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE13' 37 ADJ_ATTRIBUTE14 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE14' 38 ADJ_ATTRIBUTE15 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE15' 39 ADJ_ATTRIBUTE16 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE16' 40 ADJ_ATTRIBUTE17 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE17' 41 ADJ_ATTRIBUTE18 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE18' 42 ADJ_ATTRIBUTE19 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE19' 43 ADJ_ATTRIBUTE20 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE20' 44 ADJ_ATTRIBUTE21 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE21' 45 ADJ_ATTRIBUTE22 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE22' 46 ADJ_ATTRIBUTE23 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE23' 47 ADJ_ATTRIBUTE24 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE24' 48 ADJ_ATTRIBUTE25 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE25' 49 ADJ_ATTRIBUTE26 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE26' 50 ADJ_ATTRIBUTE27 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE27' 51 ADJ_ATTRIBUTE28 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE28' 52 ADJ_ATTRIBUTE29 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE29' 53 ADJ_ATTRIBUTE30 LOV custom varchar2 150 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=>555, p_descriptive_flexfield_name=>'ADJ_DTL_FLEX', p_context_name=>:$column$.adj_attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.adj_attribute1, p_attribute2=>:$column$.adj_attribute2, p_attribute3=>:$column$.adj_attribute3, p_attribute4=>:$column$.adj_attribute4, p_attribute5=>:$column$.adj_attribute5, p_attribute6=>:$column$.adj_attribute6, p_attribute7=>:$column$.adj_attribute7, p_attribute8=>:$column$.adj_attribute8, p_attribute9=>:$column$.adj_attribute9, p_attribute10=>:$column$.adj_attribute10, p_attribute11=>:$column$.adj_attribute11, p_attribute12=>:$column$.adj_attribute12, p_attribute13=>:$column$.adj_attribute13, p_attribute14=>:$column$.adj_attribute14, p_attribute15=>:$column$.adj_attribute15, p_attribute16=>:$column$.adj_attribute16, p_attribute17=>:$column$.adj_attribute17, p_attribute18=>:$column$.adj_attribute18, p_attribute19=>:$column$.adj_attribute19, p_attribute20=>:$column$.adj_attribute20, p_attribute21=>:$column$.adj_attribute21, p_attribute22=>:$column$.adj_attribute22, p_attribute23=>:$column$.adj_attribute23, p_attribute24=>:$column$.adj_attribute24, p_attribute25=>:$column$.adj_attribute25, p_attribute26=>:$column$.adj_attribute26, p_attribute27=>:$column$.adj_attribute27, p_attribute28=>:$column$.adj_attribute28, p_attribute29=>:$column$.adj_attribute29, p_attribute30=>:$column$.adj_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=555 and fdfv.descriptive_flexfield_name='ADJ_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE30' 54 UPLOAD_ROW Number number Y U 1 p_cost_adjust_id in Number Y COST_ADJUST_ID U 2 p_organization_code in Char Y ORGANIZATION_CODE U 3 p_inventory_item_id in Number Y ITEM U 4 p_calendar in Char Y CALENDAR U 5 p_period in Char Y PERIOD U 6 p_cost_type_id in Number Y COST_TYPE U 7 p_adjustment_ind in Number Y ADJUSTMENT_TYPE U 8 p_cost_cmpntcls_id in Number Y COMPONENT_CLASS U 9 p_analysis_code in Char Y ANALYSIS_CODE U 10 p_quantity in Number Y QUANTITY U 11 p_uom in Char Y UOM U 12 p_cost in Number Y COST U 13 p_reason_code in Char Y REASON_CODE U 14 p_subledger_entry in Char Y SUBLEDGER_ENTRY U 15 p_gl_date in Date Y GL_DATE U 16 p_delete_adjustment in Char Y DELETE_ADJUSTMENT U 17 p_attribute_category in Char Y ADJ_ATTRIBUTE_CATEGORY U 18 p_attribute1 in Char Y ADJ_ATTRIBUTE1 U 19 p_attribute2 in Char Y ADJ_ATTRIBUTE2 U 20 p_attribute3 in Char Y ADJ_ATTRIBUTE3 U 21 p_attribute4 in Char Y ADJ_ATTRIBUTE4 U 22 p_attribute5 in Char Y ADJ_ATTRIBUTE5 U 23 p_attribute6 in Char Y ADJ_ATTRIBUTE6 U 24 p_attribute7 in Char Y ADJ_ATTRIBUTE7 U 25 p_attribute8 in Char Y ADJ_ATTRIBUTE8 U 26 p_attribute9 in Char Y ADJ_ATTRIBUTE9 U 27 p_attribute10 in Char Y ADJ_ATTRIBUTE10 U 28 p_attribute11 in Char Y ADJ_ATTRIBUTE11 U 29 p_attribute12 in Char Y ADJ_ATTRIBUTE12 U 30 p_attribute13 in Char Y ADJ_ATTRIBUTE13 U 31 p_attribute14 in Char Y ADJ_ATTRIBUTE14 U 32 p_attribute15 in Char Y ADJ_ATTRIBUTE15 U 33 p_attribute16 in Char Y ADJ_ATTRIBUTE16 U 34 p_attribute17 in Char Y ADJ_ATTRIBUTE17 U 35 p_attribute18 in Char Y ADJ_ATTRIBUTE18 U 36 p_attribute19 in Char Y ADJ_ATTRIBUTE19 U 37 p_attribute20 in Char Y ADJ_ATTRIBUTE20 U 38 p_attribute21 in Char Y ADJ_ATTRIBUTE21 U 39 p_attribute22 in Char Y ADJ_ATTRIBUTE22 U 40 p_attribute23 in Char Y ADJ_ATTRIBUTE23 U 41 p_attribute24 in Char Y ADJ_ATTRIBUTE24 U 42 p_attribute25 in Char Y ADJ_ATTRIBUTE25 U 43 p_attribute26 in Char Y ADJ_ATTRIBUTE26 U 44 p_attribute27 in Char Y ADJ_ATTRIBUTE27 U 45 p_attribute28 in Char Y ADJ_ATTRIBUTE28 U 46 p_attribute29 in Char Y ADJ_ATTRIBUTE29 U 47 p_attribute30 in Char Y ADJ_ATTRIBUTE30 U 48 p_cost_adjust_id_out out Number COST_ADJUST_ID U 49 status_ out Char STATUS_CODE_ U 50 message_ out Char MESSAGE_ Error SQL Order By upload_row, organization_code, item, calendar, period, cost_type, adjustment_type, component_class, analysis_code Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.cost_adjust_id, nvl(mp.organization_code,xu.organization_code) organization_code, nvl(msiv.concatenated_segments,xu.item) item, nvl(msiv.description,xu.item_description) item_description, nvl(gps.calendar_code,xu.calendar) calendar, nvl(gps.period_code,xu.period) period, nvl(cmm.cost_mthd_code,xu.cost_type) cost_type, nvl(xxen_opm_upload.adjustment_type(cad.adjustment_ind),xu.adjustment_type) adjustment_type, nvl(ccmv.cost_cmpntcls_code,xu.component_class) component_class, nvl(cad.cost_analysis_code,xu.analysis_code) analysis_code, nvl(cad.adjust_qty,xu.quantity) quantity, nvl(cad.adjust_qty_uom,xu.uom) uom, nvl(cad.adjust_cost,xu.cost) cost, nvl(cad.reason_code,xu.reason_code) reason_code, nvl2(cad.rowid,xxen_util.yes(decode(cad.subledger_ind,1,'Y')),xu.subledger_entry) subledger_entry, nvl2(cad.rowid,cad.adjustment_date,xu.gl_date) gl_date, nvl(xxen_opm_upload.adjustment_status(cad.adjust_status),xu.adjustment_status) adjustment_status, xu.delete_adjustment, nvl2(cad.rowid,xxen_util.display_flexfield_context(555,'ADJ_DTL_FLEX',cad.attribute_category),xu.adj_attribute_category) adj_attribute_category, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE1',cad.rowid,cad.attribute1),xu.adj_attribute1) adj_attribute1, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE2',cad.rowid,cad.attribute2),xu.adj_attribute2) adj_attribute2, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE3',cad.rowid,cad.attribute3),xu.adj_attribute3) adj_attribute3, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE4',cad.rowid,cad.attribute4),xu.adj_attribute4) adj_attribute4, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE5',cad.rowid,cad.attribute5),xu.adj_attribute5) adj_attribute5, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE6',cad.rowid,cad.attribute6),xu.adj_attribute6) adj_attribute6, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE7',cad.rowid,cad.attribute7),xu.adj_attribute7) adj_attribute7, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE8',cad.rowid,cad.attribute8),xu.adj_attribute8) adj_attribute8, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE9',cad.rowid,cad.attribute9),xu.adj_attribute9) adj_attribute9, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE10',cad.rowid,cad.attribute10),xu.adj_attribute10) adj_attribute10, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE11',cad.rowid,cad.attribute11),xu.adj_attribute11) adj_attribute11, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE12',cad.rowid,cad.attribute12),xu.adj_attribute12) adj_attribute12, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE13',cad.rowid,cad.attribute13),xu.adj_attribute13) adj_attribute13, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE14',cad.rowid,cad.attribute14),xu.adj_attribute14) adj_attribute14, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE15',cad.rowid,cad.attribute15),xu.adj_attribute15) adj_attribute15, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE16',cad.rowid,cad.attribute16),xu.adj_attribute16) adj_attribute16, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE17',cad.rowid,cad.attribute17),xu.adj_attribute17) adj_attribute17, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE18',cad.rowid,cad.attribute18),xu.adj_attribute18) adj_attribute18, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE19',cad.rowid,cad.attribute19),xu.adj_attribute19) adj_attribute19, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE20',cad.rowid,cad.attribute20),xu.adj_attribute20) adj_attribute20, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE21',cad.rowid,cad.attribute21),xu.adj_attribute21) adj_attribute21, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE22',cad.rowid,cad.attribute22),xu.adj_attribute22) adj_attribute22, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE23',cad.rowid,cad.attribute23),xu.adj_attribute23) adj_attribute23, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE24',cad.rowid,cad.attribute24),xu.adj_attribute24) adj_attribute24, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE25',cad.rowid,cad.attribute25),xu.adj_attribute25) adj_attribute25, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE26',cad.rowid,cad.attribute26),xu.adj_attribute26) adj_attribute26, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE27',cad.rowid,cad.attribute27),xu.adj_attribute27) adj_attribute27, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE28',cad.rowid,cad.attribute28),xu.adj_attribute28) adj_attribute28, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE29',cad.rowid,cad.attribute29),xu.adj_attribute29) adj_attribute29, nvl2(cad.rowid,xxen_util.display_flexfield_value(555,'ADJ_DTL_FLEX',cad.attribute_category,'ATTRIBUTE30',cad.rowid,cad.attribute30),xu.adj_attribute30) adj_attribute30, xu.upload_row from xxen_opm_actual_cost_ad_5122_u xu, cm_adjs_dtl cad, mtl_parameters mp, mtl_system_items_vl msiv, gmf_period_statuses gps, cm_mthd_mst cmm, cm_cmpt_mst_vl ccmv where xu.status_code_=xxen_upload.status_success and xu.cost_adjust_id=cad.cost_adjust_id(+) and cad.organization_id=mp.organization_id(+) and cad.inventory_item_id=msiv.inventory_item_id(+) and cad.organization_id=msiv.organization_id(+) and cad.period_id=gps.period_id(+) and cad.cost_type_id=cmm.cost_type_id(+) and cad.cost_cmpntcls_id=ccmv.cost_cmpntcls_id(+)