ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 220552FEA94541DA9F9DD35A5DCF4C15Y select null action_, null status_, null message_, null modified_columns_, xxen_util.meaning(x.origin_type,'WSH_ORIGIN_DEST_TYPE',665) origin_type, tp_o.value origin, tp_o.description origin_description, xxen_util.meaning(x.destination_type,'WSH_ORIGIN_DEST_TYPE',665) destination_type, tp_d.value destination, tp_d.description destination_description, xxen_util.meaning(x.ship_method,'SHIP_METHOD',3) ship_method, x.intransit_time, x.daily_load_weight_capacity daily_weight_capacity, x.load_weight_uom_code weight_uom, x.cost_per_unit_load_weight cost_per_unit_weight, x.currency_code currency, x.daily_volume_capacity, x.volume_uom_code volume_uom, xxen_util.yes(decode(x.default_flag,1,'Y')) default_method, null delete_transit_time, xxen_util.display_flexfield_context(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category) attribute_category, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE1',x.mism_rowid,x.attribute1) tt_attribute1, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE2',x.mism_rowid,x.attribute2) tt_attribute2, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE3',x.mism_rowid,x.attribute3) tt_attribute3, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE4',x.mism_rowid,x.attribute4) tt_attribute4, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE5',x.mism_rowid,x.attribute5) tt_attribute5, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE6',x.mism_rowid,x.attribute6) tt_attribute6, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE7',x.mism_rowid,x.attribute7) tt_attribute7, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE8',x.mism_rowid,x.attribute8) tt_attribute8, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE9',x.mism_rowid,x.attribute9) tt_attribute9, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE10',x.mism_rowid,x.attribute10) tt_attribute10, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE11',x.mism_rowid,x.attribute11) tt_attribute11, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE12',x.mism_rowid,x.attribute12) tt_attribute12, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE13',x.mism_rowid,x.attribute13) tt_attribute13, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE14',x.mism_rowid,x.attribute14) tt_attribute14, xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',x.attribute_category,'ATTRIBUTE15',x.mism_rowid,x.attribute15) tt_attribute15, rowidtochar(x.mism_rowid) row_id, to_number(null) upload_row from ( select mism.rowid mism_rowid, nvl(mism.origin_type,'L') origin_type, nvl(mism.from_location_id,mism.from_region_id) origin_id, nvl(mism.destination_type,'L') destination_type, nvl(mism.to_location_id,mism.to_region_id) destination_id, mism.ship_method, mism.intransit_time, mism.daily_load_weight_capacity, mism.load_weight_uom_code, mism.cost_per_unit_load_weight, mism.currency_code, mism.daily_volume_capacity, mism.volume_uom_code, mism.default_flag, mism.attribute_category, mism.attribute1, mism.attribute2, mism.attribute3, mism.attribute4, mism.attribute5, mism.attribute6, mism.attribute7, mism.attribute8, mism.attribute9, mism.attribute10, mism.attribute11, mism.attribute12, mism.attribute13, mism.attribute14, mism.attribute15 from mtl_interorg_ship_methods mism ) x, table(xxen_wsh_upload.transit_points(null)) tp_o, table(xxen_wsh_upload.transit_points(null)) tp_d where 1=1 and x.origin_type=tp_o.point_type and x.origin_id=tp_o.id and x.destination_type=tp_d.point_type and x.destination_id=tp_d.id Initial version. Creates, updates and deletes transit times (mtl_interorg_ship_methods), replicating the Transit Times form (WSHFILTM). U A xxen_wsh_upload.upload_transit_time xxen_wsh_upload.validate_transit_time(:$column$.intransit_time,:$column$.daily_weight_capacity,:$column$.weight_uom,:$column$.cost_per_unit_weight,:$column$.currency,:$column$.daily_volume_capacity,:$column$.volume_uom) US WSH Transit Time Upload Creates, updates and deletes transit times - the Transit Times form (Shipping > Setup > Regions and Zones > Transit Times). A row is one ship method of a lane, which is an origin and destination pair of locations, regions or zones, with the intransit time in days and the optional daily capacities and cost per unit. The origin and destination of a downloaded row cannot be changed. Changing its Ship Method changes the ship method of that row. To remove a ship method from a lane, enter Yes in Delete Transit Time. Setting Default Method to Yes removes the flag from the lane's other ship methods, as the form does, and the Message names them. Regions are the country, state, city and postal code regions already defined in Regions and Zones; the upload does not create regions. A location or region name that occurs more than once is followed by its description in brackets. An internal location that belongs to an organization accepts only the ship methods of the carrier services enabled for its inventory organization, as the form's list does. Lanes between inventory organizations defined in Shipping Networks are downloaded as well, when their organizations' locations are set. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%'||xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C,U Y US Upload Mode Create downloads an empty template. Create, Update also downloads the existing transit times. 2 20 1=1 x.origin_type=:origin_type LOV custom select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='WSH_ORIGIN_DEST_TYPE' and flvv.view_application_id=665 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code US Origin Type Downloads only transit times with this origin type. 3 30 1=1 tp_o.value=:origin LOV custom select x.value, x.description from table(xxen_wsh_upload.transit_points(:$flex$.origin_type)) x where x.active_flag='Y' order by x.value US Origin Downloads only transit times from this location, region or zone. 4 40 1=1 x.destination_type=:destination_type LOV custom select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='WSH_ORIGIN_DEST_TYPE' and flvv.view_application_id=665 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code US Destination Type Downloads only transit times with this destination type. 5 50 1=1 tp_d.value=:destination LOV custom select x.value, x.description from table(xxen_wsh_upload.transit_points(:$flex$.destination_type)) x where x.active_flag='Y' order by x.value US Destination Downloads only transit times to this location, region or zone. 6 60 1=1 x.ship_method=:ship_method LOV custom select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='SHIP_METHOD' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.meaning US Ship Method Downloads only transit times of this ship method. 8BBEC5282BB84330954EA2F37A6CB69D Create An empty sheet to enter new transit times. ENGINATICS 9 COST_PER_UNIT_WEIGHT 10 CURRENCY 11 DAILY_VOLUME_CAPACITY 7 DAILY_WEIGHT_CAPACITY 13 DEFAULT_METHOD 4 DESTINATION 15 DESTINATION_DESCRIPTION 3 DESTINATION_TYPE 6 INTRANSIT_TIME Y 2 ORIGIN 14 ORIGIN_DESCRIPTION 1 ORIGIN_TYPE 5 SHIP_METHOD 12 VOLUME_UOM 8 WEIGHT_UOM Upload Mode C Y S Site Destination Destination Type Origin Origin Type Ship Method E1EF3F64F0DE43FAB0567739631B311C Default All columns except the descriptive flexfield attributes. ENGINATICS 9 COST_PER_UNIT_WEIGHT 10 CURRENCY 11 DAILY_VOLUME_CAPACITY 7 DAILY_WEIGHT_CAPACITY 13 DEFAULT_METHOD 14 DELETE_TRANSIT_TIME 4 DESTINATION 16 DESTINATION_DESCRIPTION 3 DESTINATION_TYPE 6 INTRANSIT_TIME Y 2 ORIGIN 15 ORIGIN_DESCRIPTION 1 ORIGIN_TYPE 5 SHIP_METHOD 12 VOLUME_UOM 8 WEIGHT_UOM Upload Mode C,U S Site 6B2BD55CB7454CCEA0E92C11769F1922 Descriptive Flexfield The descriptive flexfield attributes of the transit times. ENGINATICS 6 ATTRIBUTE_CATEGORY Y 4 DESTINATION 3 DESTINATION_TYPE 2 ORIGIN 1 ORIGIN_TYPE 5 SHIP_METHOD 7 TT_ATTRIBUTE1 16 TT_ATTRIBUTE10 17 TT_ATTRIBUTE11 18 TT_ATTRIBUTE12 19 TT_ATTRIBUTE13 20 TT_ATTRIBUTE14 21 TT_ATTRIBUTE15 8 TT_ATTRIBUTE2 9 TT_ATTRIBUTE3 10 TT_ATTRIBUTE4 11 TT_ATTRIBUTE5 12 TT_ATTRIBUTE6 13 TT_ATTRIBUTE7 14 TT_ATTRIBUTE8 15 TT_ATTRIBUTE9 Upload Mode C,U S Site 5E6527C5DB5647BB985235BCE50B7226 Intransit Time Mass correction of intransit times and default ship methods. ENGINATICS 7 DEFAULT_METHOD 4 DESTINATION 3 DESTINATION_TYPE 6 INTRANSIT_TIME Y 2 ORIGIN 1 ORIGIN_TYPE 5 SHIP_METHOD Upload Mode C,U S Site E1EF3F64F0DE43FAB0567739631B311C 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 ORIGIN_TYPE LOV custom varchar2 select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='WSH_ORIGIN_DEST_TYPE' and flvv.view_application_id=665 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code xxen_util.meaning('L','WSH_ORIGIN_DEST_TYPE',665) Y 6 ORIGIN LOV custom varchar2 select x.id, x.value, x.description from table(xxen_wsh_upload.transit_points(xxen_util.lookup_code(:$column$.origin_type,'WSH_ORIGIN_DEST_TYPE',665))) x where x.active_flag='Y' order by x.value select x.id, x.value from table(xxen_wsh_upload.transit_points(xxen_util.lookup_code(:$column$.origin_type,'WSH_ORIGIN_DEST_TYPE',665))) x Y 7 ORIGIN_DESCRIPTION Char varchar2 select x.description from table(xxen_wsh_upload.transit_points(xxen_util.lookup_code(:$column$.origin_type,'WSH_ORIGIN_DEST_TYPE',665))) x where x.value=:$column$.origin Y 8 DESTINATION_TYPE LOV custom varchar2 select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='WSH_ORIGIN_DEST_TYPE' and flvv.view_application_id=665 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.lookup_code xxen_util.meaning('L','WSH_ORIGIN_DEST_TYPE',665) Y 9 DESTINATION LOV custom varchar2 select x.id, x.value, x.description from table(xxen_wsh_upload.transit_points(xxen_util.lookup_code(:$column$.destination_type,'WSH_ORIGIN_DEST_TYPE',665))) x where x.active_flag='Y' order by x.value select x.id, x.value from table(xxen_wsh_upload.transit_points(xxen_util.lookup_code(:$column$.destination_type,'WSH_ORIGIN_DEST_TYPE',665))) x Y 10 DESTINATION_DESCRIPTION Char varchar2 select x.description from table(xxen_wsh_upload.transit_points(xxen_util.lookup_code(:$column$.destination_type,'WSH_ORIGIN_DEST_TYPE',665))) x where x.value=:$column$.destination Y 11 SHIP_METHOD LOV custom varchar2 select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='SHIP_METHOD' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.enabled_flag='Y' and nvl(flvv.start_date_active,sysdate)<=sysdate and nvl(flvv.end_date_active,sysdate)>=sysdate order by flvv.meaning select flvv.lookup_code id, flvv.meaning value from fnd_lookup_values_vl flvv where flvv.lookup_type='SHIP_METHOD' and flvv.view_application_id=3 and flvv.security_group_id=0 Y 12 INTRANSIT_TIME Number number select wcs.max_sl_time from fnd_lookup_values_vl flvv, wsh_carrier_services wcs where flvv.lookup_type='SHIP_METHOD' and flvv.view_application_id=3 and flvv.security_group_id=0 and flvv.meaning=:$column$.ship_method and flvv.lookup_code=wcs.ship_method_code and wcs.max_sl_time is not null Y 13 DAILY_WEIGHT_CAPACITY Number number 14 WEIGHT_UOM LOV varchar2 INV UOM Code (active, translated) 8AEDD3EE31DF40488E61A436D2B0B86A 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 15 COST_PER_UNIT_WEIGHT Number number 16 CURRENCY LOV varchar2 FND Currency Codes DD3BDFF9582F51D0E0530100007FEDB0 select fct.currency_code id, fct.currency_code value, fct.description from fnd_currencies_tl fct where fct.source_lang=userenv('LANG') order by fct.currency_code 17 DAILY_VOLUME_CAPACITY Number number 18 VOLUME_UOM LOV varchar2 INV UOM Code (active, translated) 8AEDD3EE31DF40488E61A436D2B0B86A 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 19 DEFAULT_METHOD LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 20 DELETE_TRANSIT_TIME LOV custom varchar2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual where :$column$.row_id is not null 21 ATTRIBUTE_CATEGORY LOV custom varchar2 select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=401 and fdfcv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfcv.global_flag='N' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name 22 TT_ATTRIBUTE1 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE1', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE1' 23 TT_ATTRIBUTE2 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE2', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE2' 24 TT_ATTRIBUTE3 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE3', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE3' 25 TT_ATTRIBUTE4 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE4', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE4' 26 TT_ATTRIBUTE5 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE5', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE5' 27 TT_ATTRIBUTE6 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE6', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE6' 28 TT_ATTRIBUTE7 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE7', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE7' 29 TT_ATTRIBUTE8 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE8', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE8' 30 TT_ATTRIBUTE9 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE9', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE9' 31 TT_ATTRIBUTE10 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE10', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE10' 32 TT_ATTRIBUTE11 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE11', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE11' 33 TT_ATTRIBUTE12 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE12', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE12' 34 TT_ATTRIBUTE13 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE13', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE13' 35 TT_ATTRIBUTE14 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE14', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE14' 36 TT_ATTRIBUTE15 LOV custom varchar2 select substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value, substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description from table( xxen_util.dff_attribute_lov( p_application_id=>401, p_descriptive_flexfield_name=>'MTL_INTERORG_SHIP_METHODS', p_context_name=>:$column$.attribute_category, p_column_name=>'ATTRIBUTE15', p_attribute1=>:$column$.tt_attribute1, p_attribute2=>:$column$.tt_attribute2, p_attribute3=>:$column$.tt_attribute3, p_attribute4=>:$column$.tt_attribute4, p_attribute5=>:$column$.tt_attribute5, p_attribute6=>:$column$.tt_attribute6, p_attribute7=>:$column$.tt_attribute7, p_attribute8=>:$column$.tt_attribute8, p_attribute9=>:$column$.tt_attribute9, p_attribute10=>:$column$.tt_attribute10, p_attribute11=>:$column$.tt_attribute11, p_attribute12=>:$column$.tt_attribute12, p_attribute13=>:$column$.tt_attribute13, p_attribute14=>:$column$.tt_attribute14, p_attribute15=>:$column$.tt_attribute15 ) ) lov order by value select distinct '(Context) '||initcap(fdfcuv.application_column_name)||': '||listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','('||fdfc.descriptive_flex_context_code||')')||' '||fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name) from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts fdfc, fnd_descr_flex_col_usage_vl fdfcuv where fdfv.application_id=401 and fdfv.descriptive_flexfield_name='MTL_INTERORG_SHIP_METHODS' and fdfc.application_id=fdfv.application_id and fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfc.enabled_flag='Y' and fdfcuv.application_id=fdfc.application_id and fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and fdfcuv.enabled_flag='Y' and fdfcuv.application_column_name='ATTRIBUTE15' 37 ROW_ID Char varchar2 Y 38 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_origin_type in Char ORIGIN_TYPE U 5 p_origin_id in Number ORIGIN U 6 p_destination_type in Char DESTINATION_TYPE U 7 p_destination_id in Number DESTINATION U 8 p_ship_method in Char SHIP_METHOD U 9 p_intransit_time in Number INTRANSIT_TIME U 10 p_daily_weight_capacity in Number Y DAILY_WEIGHT_CAPACITY U 11 p_weight_uom in Char Y WEIGHT_UOM U 12 p_cost_per_unit_weight in Number Y COST_PER_UNIT_WEIGHT U 13 p_currency in Char Y CURRENCY U 14 p_daily_volume_capacity in Number Y DAILY_VOLUME_CAPACITY U 15 p_volume_uom in Char Y VOLUME_UOM U 16 p_default_method in Char Y DEFAULT_METHOD U 17 p_delete_transit_time in Char Y DELETE_TRANSIT_TIME U 18 p_tt_attribute_category in Char Y ATTRIBUTE_CATEGORY U 19 p_tt_attribute1 in Char Y TT_ATTRIBUTE1 U 20 p_tt_attribute2 in Char Y TT_ATTRIBUTE2 U 21 p_tt_attribute3 in Char Y TT_ATTRIBUTE3 U 22 p_tt_attribute4 in Char Y TT_ATTRIBUTE4 U 23 p_tt_attribute5 in Char Y TT_ATTRIBUTE5 U 24 p_tt_attribute6 in Char Y TT_ATTRIBUTE6 U 25 p_tt_attribute7 in Char Y TT_ATTRIBUTE7 U 26 p_tt_attribute8 in Char Y TT_ATTRIBUTE8 U 27 p_tt_attribute9 in Char Y TT_ATTRIBUTE9 U 28 p_tt_attribute10 in Char Y TT_ATTRIBUTE10 U 29 p_tt_attribute11 in Char Y TT_ATTRIBUTE11 U 30 p_tt_attribute12 in Char Y TT_ATTRIBUTE12 U 31 p_tt_attribute13 in Char Y TT_ATTRIBUTE13 U 32 p_tt_attribute14 in Char Y TT_ATTRIBUTE14 U 33 p_tt_attribute15 in Char Y TT_ATTRIBUTE15 U 34 p_row_id in Char Y ROW_ID U 35 p_row_id_out out Char ROW_ID Error SQL Order By upload_row, origin, destination, ship_method Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(xxen_util.meaning(nvl(mism.origin_type,'L'),'WSH_ORIGIN_DEST_TYPE',665),xu.origin_type) origin_type, nvl(tp_o.value,xu.origin) origin, nvl(tp_o.description,xu.origin_description) origin_description, nvl(xxen_util.meaning(nvl(mism.destination_type,'L'),'WSH_ORIGIN_DEST_TYPE',665),xu.destination_type) destination_type, nvl(tp_d.value,xu.destination) destination, nvl(tp_d.description,xu.destination_description) destination_description, nvl(xxen_util.meaning(mism.ship_method,'SHIP_METHOD',3),xu.ship_method) ship_method, nvl(mism.intransit_time,xu.intransit_time) intransit_time, case when mism.rowid is null then xu.daily_weight_capacity else mism.daily_load_weight_capacity end daily_weight_capacity, case when mism.rowid is null then xu.weight_uom else mism.load_weight_uom_code end weight_uom, case when mism.rowid is null then xu.cost_per_unit_weight else mism.cost_per_unit_load_weight end cost_per_unit_weight, case when mism.rowid is null then xu.currency else mism.currency_code end currency, case when mism.rowid is null then xu.daily_volume_capacity else mism.daily_volume_capacity end daily_volume_capacity, case when mism.rowid is null then xu.volume_uom else mism.volume_uom_code end volume_uom, case when mism.rowid is null then xu.default_method else xxen_util.yes(decode(mism.default_flag,1,'Y')) end default_method, xu.delete_transit_time, case when mism.rowid is null then xu.attribute_category else xxen_util.display_flexfield_context(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category) end attribute_category, case when mism.rowid is null then xu.tt_attribute1 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE1',mism.rowid,mism.attribute1) end tt_attribute1, case when mism.rowid is null then xu.tt_attribute2 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE2',mism.rowid,mism.attribute2) end tt_attribute2, case when mism.rowid is null then xu.tt_attribute3 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE3',mism.rowid,mism.attribute3) end tt_attribute3, case when mism.rowid is null then xu.tt_attribute4 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE4',mism.rowid,mism.attribute4) end tt_attribute4, case when mism.rowid is null then xu.tt_attribute5 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE5',mism.rowid,mism.attribute5) end tt_attribute5, case when mism.rowid is null then xu.tt_attribute6 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE6',mism.rowid,mism.attribute6) end tt_attribute6, case when mism.rowid is null then xu.tt_attribute7 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE7',mism.rowid,mism.attribute7) end tt_attribute7, case when mism.rowid is null then xu.tt_attribute8 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE8',mism.rowid,mism.attribute8) end tt_attribute8, case when mism.rowid is null then xu.tt_attribute9 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE9',mism.rowid,mism.attribute9) end tt_attribute9, case when mism.rowid is null then xu.tt_attribute10 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE10',mism.rowid,mism.attribute10) end tt_attribute10, case when mism.rowid is null then xu.tt_attribute11 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE11',mism.rowid,mism.attribute11) end tt_attribute11, case when mism.rowid is null then xu.tt_attribute12 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE12',mism.rowid,mism.attribute12) end tt_attribute12, case when mism.rowid is null then xu.tt_attribute13 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE13',mism.rowid,mism.attribute13) end tt_attribute13, case when mism.rowid is null then xu.tt_attribute14 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE14',mism.rowid,mism.attribute14) end tt_attribute14, case when mism.rowid is null then xu.tt_attribute15 else xxen_util.display_flexfield_value(401,'MTL_INTERORG_SHIP_METHODS',mism.attribute_category,'ATTRIBUTE15',mism.rowid,mism.attribute15) end tt_attribute15, xu.row_id, xu.upload_row from xxen_wsh_transit_time_u_9769_u xu, mtl_interorg_ship_methods mism, table(xxen_wsh_upload.transit_points(null)) tp_o, table(xxen_wsh_upload.transit_points(null)) tp_d where xu.status_code_=xxen_upload.status_success and chartorowid(xu.row_id)=mism.rowid(+) and nvl(mism.origin_type,'L')=tp_o.point_type(+) and nvl(mism.from_location_id,mism.from_region_id)=tp_o.id(+) and nvl(mism.destination_type,'L')=tp_d.point_type(+) and nvl(mism.to_location_id,mism.to_region_id)=tp_d.id(+)