ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B1A7F0C2D3E4F506172839AA5B6C7D02Y select null action_, null status_, null message_, null modified_columns_, row_number() over (order by x.routing, x.routing_version, x.step_no) upload_row, x.organization_code, x.routing, x.routing_version, x.routing_description, x.routing_class, x.routing_uom, x.routing_quantity, x.process_loss, x.fixed_process_loss, x.fixed_process_loss_uom, x.effective_start_date, x.effective_end_date, x.enforce_step_dependency, x.contiguous, x.routing_status, x.owner, x.step_no, x.operation, x.operation_version, x.step_quantity, x.step_release_type, x.minimum_transfer_quantity, x.operation_yield, x.depends_on_step_no, x.standard_delay, x.minimum_delay, x.maximum_delay, x.transfer_percent, x.rework_code, x.chargeable, x.delete_step, x.delete_dependency, x.ra_attribute_category, x.ra_attribute1, x.ra_attribute2, x.ra_attribute3, x.ra_attribute4, x.ra_attribute5, x.ra_attribute6, x.ra_attribute7, x.ra_attribute8, x.ra_attribute9, x.ra_attribute10, x.ra_attribute11, x.ra_attribute12, x.ra_attribute13, x.ra_attribute14, x.ra_attribute15, x.ra_attribute16, x.ra_attribute17, x.ra_attribute18, x.ra_attribute19, x.ra_attribute20, x.ra_attribute21, x.ra_attribute22, x.ra_attribute23, x.ra_attribute24, x.ra_attribute25, x.ra_attribute26, x.ra_attribute27, x.ra_attribute28, x.ra_attribute29, x.ra_attribute30, x.sa_attribute_category, x.sa_attribute1, x.sa_attribute2, x.sa_attribute3, x.sa_attribute4, x.sa_attribute5, x.sa_attribute6, x.sa_attribute7, x.sa_attribute8, x.sa_attribute9, x.sa_attribute10, x.sa_attribute11, x.sa_attribute12, x.sa_attribute13, x.sa_attribute14, x.sa_attribute15, x.sa_attribute16, x.sa_attribute17, x.sa_attribute18, x.sa_attribute19, x.sa_attribute20, x.sa_attribute21, x.sa_attribute22, x.sa_attribute23, x.sa_attribute24, x.sa_attribute25, x.sa_attribute26, x.sa_attribute27, x.sa_attribute28, x.sa_attribute29, x.sa_attribute30, x.routing_id, x.routingstep_id from ( select mp.organization_code, grv.routing_no routing, grv.routing_vers routing_version, grv.routing_desc routing_description, grv.routing_class, grv.routing_uom, grv.routing_qty routing_quantity, grv.process_loss, grv.fixed_process_loss, grv.fixed_process_loss_uom, grv.effective_start_date, grv.effective_end_date, xxen_util.meaning(decode(grv.enforce_step_dependency,1,'Y','N'),'YES_NO',0) enforce_step_dependency, xxen_util.meaning(decode(grv.contiguous_ind,1,'Y','N'),'YES_NO',0) contiguous, (select gsv.meaning from gmd_status_vl gsv where gsv.status_code=grv.routing_status) routing_status, (select fu.user_name from fnd_user fu where fu.user_id=grv.owner_id) owner, frd.routingstep_no step_no, gov.oprn_no operation, gov.oprn_vers operation_version, frd.step_qty step_quantity, xxen_util.meaning(to_char(frd.steprelease_type),'RELEASE_TYPE',553) step_release_type, frd.minimum_transfer_qty minimum_transfer_quantity, frd.oprn_yield operation_yield, to_number(null) depends_on_step_no, to_number(null) standard_delay, to_number(null) minimum_delay, to_number(null) maximum_delay, to_number(null) transfer_percent, to_char(null) rework_code, to_char(null) chargeable, to_char(null) delete_step, to_char(null) delete_dependency, xxen_util.display_flexfield_context(552,'FM_ROUT_HDR_FLEX',grv.attribute_category) ra_attribute_category, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE1',grv.rowid,grv.attribute1) ra_attribute1, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE2',grv.rowid,grv.attribute2) ra_attribute2, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE3',grv.rowid,grv.attribute3) ra_attribute3, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE4',grv.rowid,grv.attribute4) ra_attribute4, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE5',grv.rowid,grv.attribute5) ra_attribute5, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE6',grv.rowid,grv.attribute6) ra_attribute6, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE7',grv.rowid,grv.attribute7) ra_attribute7, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE8',grv.rowid,grv.attribute8) ra_attribute8, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE9',grv.rowid,grv.attribute9) ra_attribute9, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE10',grv.rowid,grv.attribute10) ra_attribute10, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE11',grv.rowid,grv.attribute11) ra_attribute11, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE12',grv.rowid,grv.attribute12) ra_attribute12, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE13',grv.rowid,grv.attribute13) ra_attribute13, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE14',grv.rowid,grv.attribute14) ra_attribute14, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE15',grv.rowid,grv.attribute15) ra_attribute15, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE16',grv.rowid,grv.attribute16) ra_attribute16, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE17',grv.rowid,grv.attribute17) ra_attribute17, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE18',grv.rowid,grv.attribute18) ra_attribute18, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE19',grv.rowid,grv.attribute19) ra_attribute19, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE20',grv.rowid,grv.attribute20) ra_attribute20, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE21',grv.rowid,grv.attribute21) ra_attribute21, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE22',grv.rowid,grv.attribute22) ra_attribute22, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE23',grv.rowid,grv.attribute23) ra_attribute23, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE24',grv.rowid,grv.attribute24) ra_attribute24, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE25',grv.rowid,grv.attribute25) ra_attribute25, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE26',grv.rowid,grv.attribute26) ra_attribute26, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE27',grv.rowid,grv.attribute27) ra_attribute27, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE28',grv.rowid,grv.attribute28) ra_attribute28, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE29',grv.rowid,grv.attribute29) ra_attribute29, xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',grv.attribute_category,'ATTRIBUTE30',grv.rowid,grv.attribute30) ra_attribute30, xxen_util.display_flexfield_context(552,'FM_ROUT_DTL_FLEX',frd.attribute_category) sa_attribute_category, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE1',frd.rowid,frd.attribute1) sa_attribute1, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE2',frd.rowid,frd.attribute2) sa_attribute2, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE3',frd.rowid,frd.attribute3) sa_attribute3, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE4',frd.rowid,frd.attribute4) sa_attribute4, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE5',frd.rowid,frd.attribute5) sa_attribute5, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE6',frd.rowid,frd.attribute6) sa_attribute6, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE7',frd.rowid,frd.attribute7) sa_attribute7, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE8',frd.rowid,frd.attribute8) sa_attribute8, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE9',frd.rowid,frd.attribute9) sa_attribute9, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE10',frd.rowid,frd.attribute10) sa_attribute10, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE11',frd.rowid,frd.attribute11) sa_attribute11, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE12',frd.rowid,frd.attribute12) sa_attribute12, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE13',frd.rowid,frd.attribute13) sa_attribute13, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE14',frd.rowid,frd.attribute14) sa_attribute14, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE15',frd.rowid,frd.attribute15) sa_attribute15, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE16',frd.rowid,frd.attribute16) sa_attribute16, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE17',frd.rowid,frd.attribute17) sa_attribute17, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE18',frd.rowid,frd.attribute18) sa_attribute18, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE19',frd.rowid,frd.attribute19) sa_attribute19, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE20',frd.rowid,frd.attribute20) sa_attribute20, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE21',frd.rowid,frd.attribute21) sa_attribute21, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE22',frd.rowid,frd.attribute22) sa_attribute22, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE23',frd.rowid,frd.attribute23) sa_attribute23, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE24',frd.rowid,frd.attribute24) sa_attribute24, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE25',frd.rowid,frd.attribute25) sa_attribute25, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE26',frd.rowid,frd.attribute26) sa_attribute26, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE27',frd.rowid,frd.attribute27) sa_attribute27, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE28',frd.rowid,frd.attribute28) sa_attribute28, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE29',frd.rowid,frd.attribute29) sa_attribute29, xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE30',frd.rowid,frd.attribute30) sa_attribute30, grv.routing_id, frd.routingstep_id from gmd_routings_vl grv, fm_rout_dtl frd, gmd_operations_vl gov, mtl_parameters mp where grv.routing_id=frd.routing_id and frd.oprn_id=gov.oprn_id and grv.owner_organization_id=mp.organization_id and grv.delete_mark=0 and grv.owner_organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and :p_upload_mode like '%'||xxen_upload.action_update ) x where 1=1 Initial version: OPM Routing Upload (header + steps + step dependencies + routing-header and routing-step DFF) via GMD_ROUTINGS_PUB / GMD_ROUTING_STEPS_PUB. U A xxen_opm_upload.upload_routing US OPM Routing Upload OPM Routing Upload ================== Create or update Oracle Process Manufacturing (OPM / GMD) Routings via the public API GMD_ROUTINGS_PUB / GMD_ROUTING_STEPS_PUB. Row model ========= One spreadsheet row per routing STEP. The header columns (Organization Code, Routing, Routing Version, Description, Class, UOM, dates, owner, header attributes) repeat on every step of the same routing. Each step carries its Step No, Operation (No + Version), Step Quantity, Release Type, and step attributes. Rows of the same routing (Organization Code + Routing + Routing Version) must be contiguous. Every routing must have at least one step. Step dependencies (optional) ============================ To make a step depend on a predecessor step, fill Depends On Step No (and optionally Standard / Minimum / Maximum Delay, Transfer Percent, Rework Code, Chargeable) on that step's row. For a step with more than one predecessor, add extra rows that repeat the Step No, leave Operation blank, and give a different Depends On Step No. Dependency Type is always Finish-to-Start. Operations must already exist ============================= Operations are referenced, not created - the Operation (No + Version) must already exist in the routing's organization, effective for the routing's dates. Upload modes ============ Create - empty template for new routings. Create, Update - downloads existing routings in the chosen organization for review/edit and allows adding new ones. Update limitations (public API) =============================== On update, the OPM public API only allows changing a routing's Status, Routing Class, Routing UOM, Fixed Process Loss UOM, Owner and Organization at the header level; Description, Quantity, Process Loss, effective dates and the step-dependency flags are set at create time only. Steps can be added and their quantity / release type / yield updated. Enginatics Upload 1=1 :p_upload_mode 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 1=1 x.organization_code=:p_organization_code LOV custom Y select mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv, org_access_view oav where mp.process_enabled_flag='Y' and mp.organization_id=haouv.organization_id and mp.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id order by 1 US Organization Code 3 30 1=1 x.routing=:p_routing Char US Routing 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 UPLOAD_ROW Number number Y 6 ORGANIZATION_CODE LOV custom varchar2 3 Y select mp.organization_code id, mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv, org_access_view oav where mp.process_enabled_flag='Y' and mp.organization_id=haouv.organization_id and mp.organization_id=oav.organization_id and oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id order by 1 Y 7 ROUTING Char varchar2 32 Y 8 ROUTING_VERSION Number number Y 9 ROUTING_DESCRIPTION Char varchar2 240 Y 10 ROUTING_CLASS LOV custom varchar2 4 Y select grcv.routing_class id, grcv.routing_class value, grcv.routing_class_desc description from gmd_routing_class_vl grcv where grcv.delete_mark=0 order by 1 11 ROUTING_UOM LOV custom varchar2 3 Y select muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure description from mtl_units_of_measure_vl muomv where muomv.disable_date is null order by 1 Y 12 ROUTING_QUANTITY Number number 13 PROCESS_LOSS Number number 14 FIXED_PROCESS_LOSS Number number 15 FIXED_PROCESS_LOSS_UOM LOV custom varchar2 3 Y select muomv.uom_code id, muomv.uom_code value, muomv.unit_of_measure description from mtl_units_of_measure_vl muomv where muomv.disable_date is null order by 1 16 EFFECTIVE_START_DATE Date date 17 EFFECTIVE_END_DATE Date date 18 ENFORCE_STEP_DEPENDENCY LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 19 CONTIGUOUS LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 20 ROUTING_STATUS LOV custom varchar2 80 Y select gsv.status_code id, gsv.meaning value, gsv.description from gmd_status_vl gsv where to_number(gsv.status_code)<1000 order by 1 21 OWNER LOV custom varchar2 100 Y select fu.user_id id, fu.user_name value, fu.description from fnd_user fu where sysdate between fu.start_date and nvl(fu.end_date,sysdate+1) order by 2 22 STEP_NO Number number 23 OPERATION LOV custom varchar2 16 Y select gov.oprn_no id, gov.oprn_no value, min(gov.oprn_desc) description from gmd_operations_vl gov, mtl_parameters mp where gov.owner_organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and gov.delete_mark=0 and to_number(gov.operation_status)<1000 group by gov.oprn_no order by 1 24 OPERATION_VERSION Number number 25 STEP_QUANTITY Number number 26 STEP_RELEASE_TYPE LOV custom varchar2 Y select to_number(flvv.lookup_code) id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='RELEASE_TYPE' and flvv.view_application_id=553 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by 1 27 MINIMUM_TRANSFER_QUANTITY Number number 28 OPERATION_YIELD Number number 29 DEPENDS_ON_STEP_NO Number number 30 STANDARD_DELAY Number number 31 MINIMUM_DELAY Number number 32 MAXIMUM_DELAY Number number 33 TRANSFER_PERCENT Number number 34 REWORK_CODE LOV custom varchar2 Y select src.reason_code id, src.reason_code value, src.reason_desc1 description from sy_reas_cds src where src.delete_mark=0 order by 1 35 CHARGEABLE LOV Oracle varchar2 Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description 36 DELETE_STEP LOV custom varchar2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.routingstep_id is not null 37 DELETE_DEPENDENCY LOV custom varchar2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.depends_on_step_no is not null 38 RA_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=552 and fdfcv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by 2 39 RA_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE1' 40 RA_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE2' 41 RA_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE3' 42 RA_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE4' 43 RA_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE5' 44 RA_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE6' 45 RA_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE7' 46 RA_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE8' 47 RA_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE9' 48 RA_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE10' 49 RA_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE11' 50 RA_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE12' 51 RA_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE13' 52 RA_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE14' 53 RA_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE15' 54 RA_ATTRIBUTE16 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE16' 55 RA_ATTRIBUTE17 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE17' 56 RA_ATTRIBUTE18 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE18' 57 RA_ATTRIBUTE19 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE19' 58 RA_ATTRIBUTE20 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE20' 59 RA_ATTRIBUTE21 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE21' 60 RA_ATTRIBUTE22 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE22' 61 RA_ATTRIBUTE23 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE23' 62 RA_ATTRIBUTE24 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE24' 63 RA_ATTRIBUTE25 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE25' 64 RA_ATTRIBUTE26 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE26' 65 RA_ATTRIBUTE27 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE27' 66 RA_ATTRIBUTE28 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE28' 67 RA_ATTRIBUTE29 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE29' 68 RA_ATTRIBUTE30 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_HDR_FLEX', p_context_name=>:$column$.ra_attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.ra_attribute1, p_attribute2=>:$column$.ra_attribute2, p_attribute3=>:$column$.ra_attribute3, p_attribute4=>:$column$.ra_attribute4, p_attribute5=>:$column$.ra_attribute5, p_attribute6=>:$column$.ra_attribute6, p_attribute7=>:$column$.ra_attribute7, p_attribute8=>:$column$.ra_attribute8, p_attribute9=>:$column$.ra_attribute9, p_attribute10=>:$column$.ra_attribute10, p_attribute11=>:$column$.ra_attribute11, p_attribute12=>:$column$.ra_attribute12, p_attribute13=>:$column$.ra_attribute13, p_attribute14=>:$column$.ra_attribute14, p_attribute15=>:$column$.ra_attribute15, p_attribute16=>:$column$.ra_attribute16, p_attribute17=>:$column$.ra_attribute17, p_attribute18=>:$column$.ra_attribute18, p_attribute19=>:$column$.ra_attribute19, p_attribute20=>:$column$.ra_attribute20, p_attribute21=>:$column$.ra_attribute21, p_attribute22=>:$column$.ra_attribute22, p_attribute23=>:$column$.ra_attribute23, p_attribute24=>:$column$.ra_attribute24, p_attribute25=>:$column$.ra_attribute25, p_attribute26=>:$column$.ra_attribute26, p_attribute27=>:$column$.ra_attribute27, p_attribute28=>:$column$.ra_attribute28, p_attribute29=>:$column$.ra_attribute29, p_attribute30=>:$column$.ra_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_HDR_FLEX' and fdfcuv.application_column_name='ATTRIBUTE30' 69 SA_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_code id, fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=552 and fdfcv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by 2 70 SA_ATTRIBUTE1 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE1' 71 SA_ATTRIBUTE2 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE2' 72 SA_ATTRIBUTE3 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE3' 73 SA_ATTRIBUTE4 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE4' 74 SA_ATTRIBUTE5 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE5' 75 SA_ATTRIBUTE6 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE6' 76 SA_ATTRIBUTE7 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE7' 77 SA_ATTRIBUTE8 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE8' 78 SA_ATTRIBUTE9 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE9' 79 SA_ATTRIBUTE10 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE10' 80 SA_ATTRIBUTE11 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE11' 81 SA_ATTRIBUTE12 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE12' 82 SA_ATTRIBUTE13 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE13' 83 SA_ATTRIBUTE14 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE14' 84 SA_ATTRIBUTE15 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE15' 85 SA_ATTRIBUTE16 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE16', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE16' 86 SA_ATTRIBUTE17 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE17', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE17' 87 SA_ATTRIBUTE18 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE18', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE18' 88 SA_ATTRIBUTE19 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE19', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE19' 89 SA_ATTRIBUTE20 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE20', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE20' 90 SA_ATTRIBUTE21 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE21', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE21' 91 SA_ATTRIBUTE22 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE22', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE22' 92 SA_ATTRIBUTE23 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE23', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE23' 93 SA_ATTRIBUTE24 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE24', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE24' 94 SA_ATTRIBUTE25 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE25', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE25' 95 SA_ATTRIBUTE26 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE26', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE26' 96 SA_ATTRIBUTE27 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE27', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE27' 97 SA_ATTRIBUTE28 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE28', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE28' 98 SA_ATTRIBUTE29 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE29', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE29' 99 SA_ATTRIBUTE30 LOV custom varchar2 Y select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>552, p_descriptive_flexfield_name=>'FM_ROUT_DTL_FLEX', p_context_name=>:$column$.sa_attribute_category, p_column_name=>'ATTRIBUTE30', p_attribute1=>:$column$.sa_attribute1, p_attribute2=>:$column$.sa_attribute2, p_attribute3=>:$column$.sa_attribute3, p_attribute4=>:$column$.sa_attribute4, p_attribute5=>:$column$.sa_attribute5, p_attribute6=>:$column$.sa_attribute6, p_attribute7=>:$column$.sa_attribute7, p_attribute8=>:$column$.sa_attribute8, p_attribute9=>:$column$.sa_attribute9, p_attribute10=>:$column$.sa_attribute10, p_attribute11=>:$column$.sa_attribute11, p_attribute12=>:$column$.sa_attribute12, p_attribute13=>:$column$.sa_attribute13, p_attribute14=>:$column$.sa_attribute14, p_attribute15=>:$column$.sa_attribute15, p_attribute16=>:$column$.sa_attribute16, p_attribute17=>:$column$.sa_attribute17, p_attribute18=>:$column$.sa_attribute18, p_attribute19=>:$column$.sa_attribute19, p_attribute20=>:$column$.sa_attribute20, p_attribute21=>:$column$.sa_attribute21, p_attribute22=>:$column$.sa_attribute22, p_attribute23=>:$column$.sa_attribute23, p_attribute24=>:$column$.sa_attribute24, p_attribute25=>:$column$.sa_attribute25, p_attribute26=>:$column$.sa_attribute26, p_attribute27=>:$column$.sa_attribute27, p_attribute28=>:$column$.sa_attribute28, p_attribute29=>:$column$.sa_attribute29, p_attribute30=>:$column$.sa_attribute30) ) lov order by value select distinct '(Context) ' || initcap(fdfcuv.application_column_name) || ': ' || listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfv.application_id=552 and fdfv.descriptive_flexfield_name='FM_ROUT_DTL_FLEX' and fdfcuv.application_column_name='ATTRIBUTE30' 100 ROUTING_ID Number number Y 101 ROUTINGSTEP_ID Number number Y Error SQL Order By upload_row Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, xu.upload_row, xu.organization_code, nvl(xu.grv_routing_no,xu.routing) routing, nvl(xu.grv_routing_vers,xu.routing_version) routing_version, nvl(xu.grv_routing_desc,xu.routing_description) routing_description, nvl(xu.grv_routing_class,xu.routing_class) routing_class, nvl(xu.grv_routing_uom,xu.routing_uom) routing_uom, nvl(xu.grv_routing_qty,xu.routing_quantity) routing_quantity, nvl(xu.grv_process_loss,xu.process_loss) process_loss, nvl(xu.grv_fixed_process_loss,xu.fixed_process_loss) fixed_process_loss, nvl(xu.grv_fixed_process_loss_uom,xu.fixed_process_loss_uom) fixed_process_loss_uom, nvl(xu.grv_effective_start_date,xu.effective_start_date) effective_start_date, nvl(xu.grv_effective_end_date,xu.effective_end_date) effective_end_date, nvl(xxen_util.meaning(decode(xu.grv_enforce_step_dependency,1,'Y','N'),'YES_NO',0),xu.enforce_step_dependency) enforce_step_dependency, nvl(xxen_util.meaning(decode(xu.grv_contiguous_ind,1,'Y','N'),'YES_NO',0),xu.contiguous) contiguous, nvl((select gsv.meaning from gmd_status_vl gsv where gsv.status_code=xu.grv_routing_status),xu.routing_status) routing_status, nvl((select fu.user_name from fnd_user fu where fu.user_id=xu.grv_owner_id),xu.owner) owner, nvl(frd.routingstep_no,xu.step_no) step_no, nvl(xu.gov_oprn_no,xu.operation) operation, nvl(xu.gov_oprn_vers,xu.operation_version) operation_version, nvl(frd.step_qty,xu.step_quantity) step_quantity, nvl(xxen_util.meaning(to_char(frd.steprelease_type),'RELEASE_TYPE',553),xu.step_release_type) step_release_type, nvl(frd.minimum_transfer_qty,xu.minimum_transfer_quantity) minimum_transfer_quantity, nvl(frd.oprn_yield,xu.operation_yield) operation_yield, xu.depends_on_step_no, xu.standard_delay, xu.minimum_delay, xu.maximum_delay, xu.transfer_percent, xu.rework_code, xu.chargeable, xu.delete_step, xu.delete_dependency, nvl(xxen_util.display_flexfield_context(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category),xu.ra_attribute_category) ra_attribute_category, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE1',xu.grv_rowid,xu.grv_attribute1),xu.ra_attribute1) ra_attribute1, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE2',xu.grv_rowid,xu.grv_attribute2),xu.ra_attribute2) ra_attribute2, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE3',xu.grv_rowid,xu.grv_attribute3),xu.ra_attribute3) ra_attribute3, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE4',xu.grv_rowid,xu.grv_attribute4),xu.ra_attribute4) ra_attribute4, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE5',xu.grv_rowid,xu.grv_attribute5),xu.ra_attribute5) ra_attribute5, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE6',xu.grv_rowid,xu.grv_attribute6),xu.ra_attribute6) ra_attribute6, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE7',xu.grv_rowid,xu.grv_attribute7),xu.ra_attribute7) ra_attribute7, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE8',xu.grv_rowid,xu.grv_attribute8),xu.ra_attribute8) ra_attribute8, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE9',xu.grv_rowid,xu.grv_attribute9),xu.ra_attribute9) ra_attribute9, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE10',xu.grv_rowid,xu.grv_attribute10),xu.ra_attribute10) ra_attribute10, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE11',xu.grv_rowid,xu.grv_attribute11),xu.ra_attribute11) ra_attribute11, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE12',xu.grv_rowid,xu.grv_attribute12),xu.ra_attribute12) ra_attribute12, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE13',xu.grv_rowid,xu.grv_attribute13),xu.ra_attribute13) ra_attribute13, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE14',xu.grv_rowid,xu.grv_attribute14),xu.ra_attribute14) ra_attribute14, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE15',xu.grv_rowid,xu.grv_attribute15),xu.ra_attribute15) ra_attribute15, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE16',xu.grv_rowid,xu.grv_attribute16),xu.ra_attribute16) ra_attribute16, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE17',xu.grv_rowid,xu.grv_attribute17),xu.ra_attribute17) ra_attribute17, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE18',xu.grv_rowid,xu.grv_attribute18),xu.ra_attribute18) ra_attribute18, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE19',xu.grv_rowid,xu.grv_attribute19),xu.ra_attribute19) ra_attribute19, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE20',xu.grv_rowid,xu.grv_attribute20),xu.ra_attribute20) ra_attribute20, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE21',xu.grv_rowid,xu.grv_attribute21),xu.ra_attribute21) ra_attribute21, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE22',xu.grv_rowid,xu.grv_attribute22),xu.ra_attribute22) ra_attribute22, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE23',xu.grv_rowid,xu.grv_attribute23),xu.ra_attribute23) ra_attribute23, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE24',xu.grv_rowid,xu.grv_attribute24),xu.ra_attribute24) ra_attribute24, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE25',xu.grv_rowid,xu.grv_attribute25),xu.ra_attribute25) ra_attribute25, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE26',xu.grv_rowid,xu.grv_attribute26),xu.ra_attribute26) ra_attribute26, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE27',xu.grv_rowid,xu.grv_attribute27),xu.ra_attribute27) ra_attribute27, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE28',xu.grv_rowid,xu.grv_attribute28),xu.ra_attribute28) ra_attribute28, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE29',xu.grv_rowid,xu.grv_attribute29),xu.ra_attribute29) ra_attribute29, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_HDR_FLEX',xu.grv_attribute_category,'ATTRIBUTE30',xu.grv_rowid,xu.grv_attribute30),xu.ra_attribute30) ra_attribute30, nvl(xxen_util.display_flexfield_context(552,'FM_ROUT_DTL_FLEX',frd.attribute_category),xu.sa_attribute_category) sa_attribute_category, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE1',frd.rowid,frd.attribute1),xu.sa_attribute1) sa_attribute1, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE2',frd.rowid,frd.attribute2),xu.sa_attribute2) sa_attribute2, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE3',frd.rowid,frd.attribute3),xu.sa_attribute3) sa_attribute3, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE4',frd.rowid,frd.attribute4),xu.sa_attribute4) sa_attribute4, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE5',frd.rowid,frd.attribute5),xu.sa_attribute5) sa_attribute5, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE6',frd.rowid,frd.attribute6),xu.sa_attribute6) sa_attribute6, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE7',frd.rowid,frd.attribute7),xu.sa_attribute7) sa_attribute7, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE8',frd.rowid,frd.attribute8),xu.sa_attribute8) sa_attribute8, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE9',frd.rowid,frd.attribute9),xu.sa_attribute9) sa_attribute9, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE10',frd.rowid,frd.attribute10),xu.sa_attribute10) sa_attribute10, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE11',frd.rowid,frd.attribute11),xu.sa_attribute11) sa_attribute11, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE12',frd.rowid,frd.attribute12),xu.sa_attribute12) sa_attribute12, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE13',frd.rowid,frd.attribute13),xu.sa_attribute13) sa_attribute13, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE14',frd.rowid,frd.attribute14),xu.sa_attribute14) sa_attribute14, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE15',frd.rowid,frd.attribute15),xu.sa_attribute15) sa_attribute15, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE16',frd.rowid,frd.attribute16),xu.sa_attribute16) sa_attribute16, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE17',frd.rowid,frd.attribute17),xu.sa_attribute17) sa_attribute17, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE18',frd.rowid,frd.attribute18),xu.sa_attribute18) sa_attribute18, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE19',frd.rowid,frd.attribute19),xu.sa_attribute19) sa_attribute19, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE20',frd.rowid,frd.attribute20),xu.sa_attribute20) sa_attribute20, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE21',frd.rowid,frd.attribute21),xu.sa_attribute21) sa_attribute21, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE22',frd.rowid,frd.attribute22),xu.sa_attribute22) sa_attribute22, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE23',frd.rowid,frd.attribute23),xu.sa_attribute23) sa_attribute23, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE24',frd.rowid,frd.attribute24),xu.sa_attribute24) sa_attribute24, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE25',frd.rowid,frd.attribute25),xu.sa_attribute25) sa_attribute25, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE26',frd.rowid,frd.attribute26),xu.sa_attribute26) sa_attribute26, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE27',frd.rowid,frd.attribute27),xu.sa_attribute27) sa_attribute27, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE28',frd.rowid,frd.attribute28),xu.sa_attribute28) sa_attribute28, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE29',frd.rowid,frd.attribute29),xu.sa_attribute29) sa_attribute29, nvl(xxen_util.display_flexfield_value(552,'FM_ROUT_DTL_FLEX',frd.attribute_category,'ATTRIBUTE30',frd.rowid,frd.attribute30),xu.sa_attribute30) sa_attribute30, nvl(xu.grv_routing_id,xu.routing_id) routing_id, nvl(frd.routingstep_id,xu.routingstep_id) routingstep_id from ( select gov.oprn_id gov_oprn_id, gov.oprn_no gov_oprn_no, gov.oprn_vers gov_oprn_vers, grv.attribute1 grv_attribute1, grv.attribute10 grv_attribute10, grv.attribute11 grv_attribute11, grv.attribute12 grv_attribute12, grv.attribute13 grv_attribute13, grv.attribute14 grv_attribute14, grv.attribute15 grv_attribute15, grv.attribute16 grv_attribute16, grv.attribute17 grv_attribute17, grv.attribute18 grv_attribute18, grv.attribute19 grv_attribute19, grv.attribute2 grv_attribute2, grv.attribute20 grv_attribute20, grv.attribute21 grv_attribute21, grv.attribute22 grv_attribute22, grv.attribute23 grv_attribute23, grv.attribute24 grv_attribute24, grv.attribute25 grv_attribute25, grv.attribute26 grv_attribute26, grv.attribute27 grv_attribute27, grv.attribute28 grv_attribute28, grv.attribute29 grv_attribute29, grv.attribute3 grv_attribute3, grv.attribute30 grv_attribute30, grv.attribute4 grv_attribute4, grv.attribute5 grv_attribute5, grv.attribute6 grv_attribute6, grv.attribute7 grv_attribute7, grv.attribute8 grv_attribute8, grv.attribute9 grv_attribute9, grv.attribute_category grv_attribute_category, grv.contiguous_ind grv_contiguous_ind, grv.effective_end_date grv_effective_end_date, grv.effective_start_date grv_effective_start_date, grv.enforce_step_dependency grv_enforce_step_dependency, grv.fixed_process_loss grv_fixed_process_loss, grv.fixed_process_loss_uom grv_fixed_process_loss_uom, grv.owner_id grv_owner_id, grv.process_loss grv_process_loss, grv.routing_class grv_routing_class, grv.routing_desc grv_routing_desc, grv.routing_id grv_routing_id, grv.routing_no grv_routing_no, grv.routing_qty grv_routing_qty, grv.routing_status grv_routing_status, grv.routing_uom grv_routing_uom, grv.routing_vers grv_routing_vers, grv.rowid grv_rowid, xu.action_, xu.chargeable, xu.contiguous, xu.delete_dependency, xu.delete_step, xu.depends_on_step_no, xu.effective_end_date, xu.effective_start_date, xu.enforce_step_dependency, xu.fixed_process_loss, xu.fixed_process_loss_uom, xu.maximum_delay, xu.message_, xu.minimum_delay, xu.minimum_transfer_quantity, xu.modified_columns_, xu.operation, xu.operation_version, xu.operation_yield, xu.organization_code, xu.owner, xu.process_loss, xu.ra_attribute1, xu.ra_attribute10, xu.ra_attribute11, xu.ra_attribute12, xu.ra_attribute13, xu.ra_attribute14, xu.ra_attribute15, xu.ra_attribute16, xu.ra_attribute17, xu.ra_attribute18, xu.ra_attribute19, xu.ra_attribute2, xu.ra_attribute20, xu.ra_attribute21, xu.ra_attribute22, xu.ra_attribute23, xu.ra_attribute24, xu.ra_attribute25, xu.ra_attribute26, xu.ra_attribute27, xu.ra_attribute28, xu.ra_attribute29, xu.ra_attribute3, xu.ra_attribute30, xu.ra_attribute4, xu.ra_attribute5, xu.ra_attribute6, xu.ra_attribute7, xu.ra_attribute8, xu.ra_attribute9, xu.ra_attribute_category, xu.rework_code, xu.routing, xu.routing_class, xu.routing_description, xu.routing_id, xu.routing_quantity, xu.routing_status, xu.routing_uom, xu.routing_version, xu.routingstep_id, xu.sa_attribute1, xu.sa_attribute10, xu.sa_attribute11, xu.sa_attribute12, xu.sa_attribute13, xu.sa_attribute14, xu.sa_attribute15, xu.sa_attribute16, xu.sa_attribute17, xu.sa_attribute18, xu.sa_attribute19, xu.sa_attribute2, xu.sa_attribute20, xu.sa_attribute21, xu.sa_attribute22, xu.sa_attribute23, xu.sa_attribute24, xu.sa_attribute25, xu.sa_attribute26, xu.sa_attribute27, xu.sa_attribute28, xu.sa_attribute29, xu.sa_attribute3, xu.sa_attribute30, xu.sa_attribute4, xu.sa_attribute5, xu.sa_attribute6, xu.sa_attribute7, xu.sa_attribute8, xu.sa_attribute9, xu.sa_attribute_category, xu.standard_delay, xu.status_, xu.step_no, xu.step_quantity, xu.step_release_type, xu.transfer_percent, xu.upload_row from ( select mp.organization_id mp_organization_id, xu.action_, xu.chargeable, xu.contiguous, xu.delete_dependency, xu.delete_step, xu.depends_on_step_no, xu.effective_end_date, xu.effective_start_date, xu.enforce_step_dependency, xu.fixed_process_loss, xu.fixed_process_loss_uom, xu.maximum_delay, xu.message_, xu.minimum_delay, xu.minimum_transfer_quantity, xu.modified_columns_, xu.operation, xu.operation_version, xu.operation_yield, xu.organization_code, xu.owner, xu.process_loss, xu.ra_attribute1, xu.ra_attribute10, xu.ra_attribute11, xu.ra_attribute12, xu.ra_attribute13, xu.ra_attribute14, xu.ra_attribute15, xu.ra_attribute16, xu.ra_attribute17, xu.ra_attribute18, xu.ra_attribute19, xu.ra_attribute2, xu.ra_attribute20, xu.ra_attribute21, xu.ra_attribute22, xu.ra_attribute23, xu.ra_attribute24, xu.ra_attribute25, xu.ra_attribute26, xu.ra_attribute27, xu.ra_attribute28, xu.ra_attribute29, xu.ra_attribute3, xu.ra_attribute30, xu.ra_attribute4, xu.ra_attribute5, xu.ra_attribute6, xu.ra_attribute7, xu.ra_attribute8, xu.ra_attribute9, xu.ra_attribute_category, xu.rework_code, xu.routing, xu.routing_class, xu.routing_description, xu.routing_id, xu.routing_quantity, xu.routing_status, xu.routing_uom, xu.routing_version, xu.routingstep_id, xu.sa_attribute1, xu.sa_attribute10, xu.sa_attribute11, xu.sa_attribute12, xu.sa_attribute13, xu.sa_attribute14, xu.sa_attribute15, xu.sa_attribute16, xu.sa_attribute17, xu.sa_attribute18, xu.sa_attribute19, xu.sa_attribute2, xu.sa_attribute20, xu.sa_attribute21, xu.sa_attribute22, xu.sa_attribute23, xu.sa_attribute24, xu.sa_attribute25, xu.sa_attribute26, xu.sa_attribute27, xu.sa_attribute28, xu.sa_attribute29, xu.sa_attribute3, xu.sa_attribute30, xu.sa_attribute4, xu.sa_attribute5, xu.sa_attribute6, xu.sa_attribute7, xu.sa_attribute8, xu.sa_attribute9, xu.sa_attribute_category, xu.standard_delay, xu.status_, xu.step_no, xu.step_quantity, xu.step_release_type, xu.transfer_percent, xu.upload_row from xxen_opm_routing_upload_5527_u xu, mtl_parameters mp where xu.status_code_=xxen_upload.status_success and mp.organization_code(+)=xu.organization_code ) xu, --before 12c an outer joined table may reference at most one other table, so the driving tables are wrapped gmd_routings_vl grv, gmd_operations_vl gov where grv.routing_no(+)=upper(xu.routing) and grv.routing_vers(+)=xu.routing_version and grv.owner_organization_id(+)=xu.mp_organization_id and gov.oprn_no(+)=xu.operation and gov.oprn_vers(+)=xu.operation_version and gov.owner_organization_id(+)=xu.mp_organization_id ) xu, --before 12c an outer joined table may reference at most one other table, so the driving tables are wrapped fm_rout_dtl frd where frd.routing_id(+)=xu.grv_routing_id and frd.oprn_id(+)=xu.gov_oprn_id