ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 92C63F4C20A21E85E053BB6B63585CC8 CST Cost Type Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate)>=sysdate and (cct.organization_id is null or cct.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) ) order by cct.cost_type US EF4BB9F32810B1A4E0530100007F390C CST Item Cost Upload - Basis Type LOV Y select ml.lookup_code id, ml.meaning value, nvl(ml.description,ml.meaning) || decode(ml.lookup_code,br.default_basis_type,' (Default)','') description from mtl_parameters mp, cst_cost_elements cce, bom_resources br, mfg_lookups ml where mp.organization_code = :$column$.organization_code and cce.cost_element = :$column$.cost_element and br.organization_id = mp.organization_id and br.cost_element_id = cce.cost_element_id and br.resource_code = :$column$.sub_element and ml.lookup_type = 'CST_BASIS_SHORT' and ( (cce.cost_element_id in (1,3,4,5,6) and ml.lookup_code in (1,2)) or (cce.cost_element_id = 2 and ml.lookup_code between 1 and 6) ) order by ml.meaning US 089F6C142DA509B9E0630100007FC56C CST Make or Buy Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='MTL_PLANNING_MAKE_BUY' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning US 8E2FF36EDF2E79D2E0530100007F1FF2 INV Category (restricted) Y select mck.concatenated_segments value, mct.description from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_categories_tl mct where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mck.structure_id and (mcsv.category_set_id, mck.category_id) in (select mic.category_set_id, mic.category_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) and mck.category_id=mct.category_id and mct.language=userenv('lang') order by mck.concatenated_segments Temporarily reverted due to other reports dependencies AR فئة عنصر المخزون ، مقيدة بمجموعة الفئة المحددة السابقة والفئات التي تحتوي على عنصر واحد على الأقل معين في MFG_ORGANIZATION_ID الحالي D Kategorie des Inventarartikels, eingeschränkt auf den zuvor ausgewählten Kategoriensatz und auf Kategorien, denen mindestens ein Artikel in der aktuellen MFG_ORGANIZATION_ID zugeordnet ist E Categoría de artículo de inventario, restringida al conjunto de categorías seleccionadas anteriormente y a las categorías que tienen al menos un artículo asignado en el MFG_ORGANIZATION_ID actual F Catégorie d'article d'inventaire, limitée à l'ensemble des catégories sélectionnées précédemment et aux catégories auxquelles au moins un article est attribué dans l'ID_ORGANISATION_FMG actuelle I Categoria di articolo dell'inventario, limitata al precedente set di categorie selezionato e alle categorie che hanno almeno un articolo assegnato nel MFG_ORGANIZATION_ID corrente JA インベントリ項目カテゴリ、前に選択されたカテゴリセットに制限され、現在のMFG_ORGANIZATION_IDに少なくとも1つの項目が割り当てられているカテゴリに制限されています。 KO 재고 품목 범주, 이전에 선택한 범주 세트 및 현재 MFG_ORGANIZATION_ID에 할당 된 품목이 하나 이상있는 범주로 제한됨 PTB Categoria de item de inventário, restrita ao conjunto de categorias selecionadas anteriormente e às categorias que têm pelo menos um item atribuído no MFG_ORGANIZATION_ID atual RU Категория инвентаризационных элементов, ограниченная ранее выбранной категорией и категориями, которым в текущем идентификаторе MFG_ORGANIZATION_ID присвоен хотя бы один элемент. S Lagerkategori, begränsad till tidigare vald kategorisats och till kategorier som har åtminstone ett objekt tilldelat i den aktuella MFG_ORGANIZATION_ID TR Envanter öğesi kategorisi, önceki seçilen kategori grubuyla ve geçerli MFG_ORGANIZATION_ID'de atanmış en az bir öğeye sahip kategorilerle sınırlıdır US Inventory item category, restricted to previous selected category set and to categories which have at least one item assigned in the current MFG_ORGANIZATION_ID ZHS 库存项目类别，仅限于以前选定的类别集和在当前MFG_ORGANIZATION_ID中至少有一个项目的类别。 8E2FF36EDF2D79D2E0530100007F1FF2 INV Category Set (restricted) Y select mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where mcsv.category_set_id in (select mic.category_set_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) order by mcsv.category_set_name US Category sets having at least one assigned inv items 8E2FF36EDE9C79D2E0530100007F1FF2 INV Item Status Y select misv.inventory_item_status_code_tl value, misv.description from mtl_item_status_vl misv order by misv.inventory_item_status_code_tl US 8E2FF36EDE8579D2E0530100007F1FF2 INV Item Type Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US F30AA5A78BFB75AEE0530100007F31BFY select case when nvl2(:p_autopopulate_upload_status,'Y','N')='Y' then xxen_upload.action_meaning(xxen_upload.action_update) else null end action_, case when nvl2(:p_autopopulate_upload_status,'Y','N')='Y' then xxen_upload.status_meaning(xxen_upload.status_new) else null end status_, case when nvl2(:p_autopopulate_upload_status,'Y','N')='Y' then xxen_util.description('U_EXCEL_MSG_VALIDATION_PENDING','XXEN_REPORT_TRANSLATIONS',0) else null end message_, to_number(null) request_id_, null modified_columns_, null row_id, -- Item cct_t.cost_type target_cost_type, mp.organization_code, msiv.concatenated_segments item, msiv.description item_description, (select misv.inventory_item_status_code_tl from mtl_item_status_vl misv where misv.inventory_item_status_code=msiv.inventory_item_status_code) item_status, xxen_util.meaning(msiv.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_or_buy, xxen_util.meaning(cic.inventory_asset_flag,'SYS_YES_NO',700) inventory_asset, xxen_util.meaning(cic.based_on_rollup_flag,'CST_BONROLLUP_VAL',700) based_on_rollup, coalesce(cic.lot_size,msiv.std_lot_size,1) lot_size, coalesce(cic.shrinkage_rate,msiv.shrinkage_rate,0) shrinkage_rate, -- Item Cost Element Details xxen_util.meaning(cicd.rollup_source_type,'CST_SOURCE_TYPE',700) cost_source_type, (select cce.cost_element from cst_cost_elements cce where cce.cost_element_id=nvl(cicd.cost_element_id,decode(cic.inventory_asset_flag,1,1))) cost_element, nvl(br.resource_code, (select br2.resource_code from bom_resources br2 where br2.resource_id=mp.default_material_cost_id and br2.organization_id=mp.organization_id and br2.cost_element_id=1 and nvl(br2.allow_costs_flag,1)=1 and nvl(br2.disable_date,sysdate)>=sysdate and cic.inventory_asset_flag = 1 )) sub_element, nvl(cicd.usage_rate_or_amount,decode(cic.inventory_asset_flag,1,0)) usage_rate_or_amount, xxen_util.meaning(cicd.basis_type,'CST_BASIS_SHORT',700) basis, ca.activity, cicd.activity_units, cicd.item_units, -- other enterable fields xxen_util.display_flexfield_context(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category) attribute_category, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE1',cicd.rowid,cicd.attribute1) item_cost_attribute1, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE2',cicd.rowid,cicd.attribute2) item_cost_attribute2, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE3',cicd.rowid,cicd.attribute3) item_cost_attribute3, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE4',cicd.rowid,cicd.attribute4) item_cost_attribute4, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE5',cicd.rowid,cicd.attribute5) item_cost_attribute5, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE6',cicd.rowid,cicd.attribute6) item_cost_attribute6, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE7',cicd.rowid,cicd.attribute7) item_cost_attribute7, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE8',cicd.rowid,cicd.attribute8) item_cost_attribute8, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE9',cicd.rowid,cicd.attribute9) item_cost_attribute9, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE10',cicd.rowid,cicd.attribute10) item_cost_attribute10, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE11',cicd.rowid,cicd.attribute11) item_cost_attribute11, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE12',cicd.rowid,cicd.attribute12) item_cost_attribute12, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE13',cicd.rowid,cicd.attribute13) item_cost_attribute13, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE14',cicd.rowid,cicd.attribute14) item_cost_attribute14, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE15',cicd.rowid,cicd.attribute15) item_cost_attribute15, -- display only - calculated by Item Cost Import cicd.basis_factor, cicd.net_yield_or_shrinkage_factor, cicd.resource_rate, cicd.item_cost element_unit_cost, -- Item Cost Summary Amounts cic.material_cost item_material_cost, cic.material_overhead_cost item_material_overhead_cost, cic.resource_cost item_resource_cost, cic.outside_processing_cost item_outside_processing_cost, cic.overhead_cost item_overhead_cost, cic.item_cost, cic.unburdened_cost item_unburdened_cost, cic.burden_cost item_burden_cost, 1 level_type, 1 rollup_source_type, 1 process_flag, :p_upload_mode upload_mode, :p_do_cost_rollup rollup_costs, :p_rollup_range rollup_type, :p_rollup_option rollup_option, :p_rollup_inc_unimp_ecn_flag rollup_unimpl_ecos, null upload_row -- from cst_cost_types cct_s, cst_cost_types cct_t, cst_item_costs cic, cst_item_cost_details cicd, cst_activities ca, bom_resources br, mtl_system_items_vl msiv, mtl_parameters mp where 1=1 and :p_upload_mode=:p_upload_mode and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and -- cct_s.cost_type=:p_source_cost_type and cct_t.cost_type=:p_target_cost_type and -- cct_s.cost_type_id=cic.cost_type_id and cic.cost_type_id=cicd.cost_type_id(+) and cic.organization_id=cicd.organization_id(+) and cic.inventory_item_id=cicd.inventory_item_id(+) and ca.activity_id(+)=cicd.activity_id and br.organization_id(+)=cicd.organization_id and br.resource_id(+)=cicd.resource_id and cic.organization_id=mp.organization_id and cic.organization_id=msiv.organization_id and cic.inventory_item_id=msiv.inventory_item_id and (cicd.rollup_source_type=1 or cicd.rowid is null) U :Rollup_Costs is null or :Rollup_Type is not null and :Rollup_Option is not null A xxen_cst_upload.insert_cost_interface xxen_cst_upload.submit_cost_import US CST Item Standard Cost Upload CST Item Standard Cost Upload ============================= This upload can be used to - Upload New Item Costs - Download the current Item Costs, Update, and Upload the amended item costs for a specified Cost Type - Download the current item Costs from one Source cost type, update, and upload the amended item costs to a different Target Cost Type NOTE: You can only upload costs to cost types that are not flagged as frozen and are flagged as updateable. This upload is used for updating cost types using the standard costing method. Optionally, the upload can perform a Cost Rollup after the Item Costs have been imported. The Cost Rollup can be performed for - Specific Items - a cost rollup will be done for only those items for which costs have been uploaded - All Items - in this mode the upload will submit the 'Supply Chain Cost Rollup - Print Report' concurrent request to roll up all items within each organization costs are uploaded to NOTE: The Item Cost Interface only supports importing 'This Level' costs. As such, this upload does not support the direct upload of rolled up costs Parameters ========== Target Cost Type (Required) - The Cost Type to which the Item Costs are to be uploaded to. Mode (Required, Default: Remove and replace cost information) - The Item Cost Update Mode - Remove and replace cost information - Insert new Cost Information Only Auto Populate Upload Columns (Default: Yes) - Applies to downloaded Item Cost Entries only. If set to Yes, the downloaded records are flagged ready for upload even if no changes have been made. If left blank, records are only flagged for upload when the user amends them. Where an Item Cost has multiple cost elements, all cost element records of that item must then be flagged for upload by amending them, as only flagged records are uploaded. Source Cost Type Optionally specify the source Cost Type from which to download the current Item Costs. For the scenarios where you want to amend the current items costs for a Cost Type or want to copy the current item costs for a Cost Type to a different Target Cost Type. Rollup Costs - set to Yes to do a cost rollup after the costs are uploaded Rollup Type - Rollup specific Items or All Items Rollup Option - Single level rollup or Full cost rollup NOTE: In All Items mode the Supply Chain Cost Rollup requests are submitted asynchronously, and the upload does not wait for them, so the item summary costs in the upload result may not yet reflect the completed rollup. Organization Code - Optionally select the Organization(s) for which you want to download the Item Costs for Additional Parameters - optionally restrict the items to be downloaded. Inventory Asset? (Default: Yes) Costs can only be uploaded against items flagged as an inventory asset in the cost type, so others are excluded by default. Select No or clear it to download them, so the flag can be set to Yes and costs entered. On Release 12.1 and earlier the item must also be set as an inventory asset in the selected organization, or the import rejects it. Based on Rollup? and Zero Cost Items? further restrict the download. Zero cost items include those with no cost details yet, which download with Cost Element, Sub-Element and Usage Rate or Amount defaulted. Notes on the Upload =================== Mode Remove and replace rebuilds the whole item: the import deletes every cost detail the item holds in the cost type and re-creates it from the uploaded rows. All cost element rows of an item must therefore be uploaded together, which Auto Populate Upload Columns Yes ensures; clear it and amend one element only and the rest are deleted. Deleting a row removes that cost element. Items whose costs default from the Default Cost Type have no cost details of their own, so they are not downloaded. Uploading costs against such an item gives it its own costs and it stops defaulting. Rollup Type and Rollup Option must be specified in order to Rollup Costs Enginatics R12 only Upload 1=1 :p_autopopulate_upload_status :p_do_cost_rollup :p_rollup_inc_unimp_ecn_flag :p_rollup_option :p_rollup_range :p_source_cost_type :p_target_cost_type :p_upload_mode 1 -10 :p_rollup_inc_unimp_ecn_flag LOV custom Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' and :$flex$.Rollup_Costs = 'Y' order by value 2 US Rollup Unimplemented ECOs 2 10 :p_target_cost_type LOV custom Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate+1)>sysdate and cct.costing_method_type = 1 and cct.allow_updates_flag=1 and cct.frozen_standard_flag!=1 and (cct.organization_id is null or cct.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) ) order by cost_type Y US Target Cost Type 3 20 :p_upload_mode LOV Oracle CST_SRS_RUN_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_RUN_OPTION' order by value,description 2 Y US Mode 4 30 :p_autopopulate_upload_status LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Auto Populate Upload Columns 5 40 :p_source_cost_type LOV CST Cost Type 92C63F4C20A21E85E053BB6B63585CC8 Y select cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate)>=sysdate and (cct.organization_id is null or cct.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) ) order by cct.cost_type US Source Cost Type 6 50 :p_do_cost_rollup LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Rollup Costs? When set to Yes, a cost rollup will be performed after the item costs are imported. 7 60 :p_rollup_range LOV custom Y select lookup_code id, meaning value, case lookup_code when 1 then 'All Items' when 2 then 'Updated Items Only' end description from mfg_lookups where lookup_type='CST_ITEM_RANGE' and lookup_code in (1,2) and :$flex$.Rollup_Costs = 'Y' order by value 2 US Rollup Type All Items: a Cost Rollup concurrent request will be submitted for all items in the organization. Specific Item: a Cost Rollup will be performed only for those items for which items costs are uploaded. 8 70 :p_rollup_option LOV custom Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='CST_ROLLUP_TYPE' and :$flex$.Rollup_Costs = 'Y' order by value,description 2 US Rollup Option 9 80 1=1 mp.organization_code=:p_organization_code LOV custom Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and mp.cost_organization_id=mp.organization_id and nvl(mp.process_enabled_flag,'N')<>'Y' and ood.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 nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) and exists (select null from cst_cost_types cct where cct.cost_type = :$flex$.target_cost_type and nvl(cct.organization_id,ood.organization_id) = ood.organization_id) order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code 10 90 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select mic.organization_id, mic.inventory_item_id from mtl_category_sets_v mcsv, mtl_item_categories mic where mcsv.category_set_name=:p_category_set_name and mcsv.category_set_id=mic.category_set_id ) LOV INV Category Set (restricted) 8E2FF36EDF2D79D2E0530100007F1FF2 Y select mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where mcsv.category_set_id in (select mic.category_set_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) order by mcsv.category_set_name select category_set_name from mtl_default_sets_view where functional_area_id = 5 US Category Set 11 100 1=1 (msiv.organization_id, msiv.inventory_item_id) in ( select mic.organization_id, mic.inventory_item_id from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_item_categories mic where mck.concatenated_segments=:p_category and mcsv.category_set_name=:p_category_set_name and mcsv.category_set_id=mic.category_set_id and mcsv.structure_id=mck.structure_id and mck.category_id=mic.category_id ) LOV INV Category (restricted) 8E2FF36EDF2E79D2E0530100007F1FF2 Y select mck.concatenated_segments value, mct.description from mtl_category_sets_v mcsv, mtl_categories_kfv mck, mtl_categories_tl mct where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mck.structure_id and (mcsv.category_set_id, mck.category_id) in (select mic.category_set_id, mic.category_id from mtl_item_categories mic where mic.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID')) and mck.category_id=mct.category_id and mct.language=userenv('lang') order by mck.concatenated_segments US Category 12 110 1=1 msiv.concatenated_segments=:p_item_number LOV custom Y Y select distinct msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.cost_organization_id=mp.organization_id and nvl(mp.process_enabled_flag,'N')<>'Y' and (xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or (:$flex$.organization_code is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) ) and msiv.costing_enabled_flag='Y' order by msiv.concatenated_segments US Item 13 120 1=1 upper(msiv.concatenated_segments) like upper(:p_item_like) Char US Item Like 14 130 1=1 upper(msiv.description) like upper(:p_item_desc_like) LOV custom Y select distinct msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.cost_organization_id=mp.organization_id and nvl(mp.process_enabled_flag,'N')<>'Y' and (xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' or (:$flex$.organization_code is null and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) ) ) and msiv.costing_enabled_flag='Y' order by msiv.concatenated_segments US Item Description 15 140 1=1 msiv.item_type=xxen_util.lookup_code(:p_item_type,'ITEM_TYPE',3) LOV INV Item Type 8E2FF36EDE8579D2E0530100007F1FF2 Y select flvv.meaning value, flvv.lookup_code description from fnd_lookup_values_vl flvv where flvv.enabled_flag='Y' and flvv.lookup_type='ITEM_TYPE' and flvv.view_application_id=3 and flvv.security_group_id=0 order by flvv.lookup_code US Item Type 16 150 1=1 msiv.inventory_item_status_code not in (select misv2.inventory_item_status_code from mtl_item_status_vl misv2 where misv2.inventory_item_status_code_tl = :p_item_status_to_exclude ) LOV INV Item Status 8E2FF36EDE9C79D2E0530100007F1FF2 Y select misv.inventory_item_status_code_tl value, misv.description from mtl_item_status_vl misv order by misv.inventory_item_status_code_tl select misv.inventory_item_status_code_tl from mtl_parameters mp, bom_parameters bp, mtl_item_status_vl misv where mp.organization_id = bp.organization_id and bp.bom_delete_status_code = misv.inventory_item_status_code and ((:$flex$.organization_code is null and mp.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID')) or xxen_util.contains(:$flex$.organization_code,mp.organization_code) = 'Y' ) and :$flex$.Item is null US Excluded Item Statuses 17 160 1=1 msiv.planning_make_buy_code=xxen_util.lookup_code(:p_make_or_buy,'MTL_PLANNING_MAKE_BUY',700) LOV CST Make or Buy 089F6C142DA509B9E0630100007FC56C Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='MTL_PLANNING_MAKE_BUY' and flvv.view_application_id=700 and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning US Make or Buy 18 170 1=1 msiv.buyer_id=:p_buyer_id LOV custom Y select x.* from ( select ppx.person_id id, ppx.full_name value, ppx.employee_number description from per_people_x ppx where ppx.current_employee_flag='Y' and ppx.person_id in (select pa.agent_id from po_agents pa where sysdate between nvl(pa.start_date_active,sysdate) and nvl(pa.end_date_active,sysdate)) order by ppx.full_name ) x union all select null id, '<null>' value, null description from dual US Buyer 19 180 1=1 msiv.planner_code=:p_planner_code LOV custom Y select distinct mp.planner_code value, mp.description from mtl_planners mp where nvl(mp.disable_date,sysdate+1)>=sysdate and (:$flex$.organization_code is null or mp.organization_id in (select mp.organization_id from mtl_parameters mp where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y')) order by mp.planner_code US Planner 20 190 1=1 cic.inventory_asset_flag=1 LOV Oracle 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 Y Y US Inventory Asset? 21 1=1 cic.inventory_asset_flag=2 N US Inventory Asset? 22 200 1=1 cic.based_on_rollup_flag=1 LOV Oracle 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 Y US Based on Rollup? 23 1=1 cic.based_on_rollup_flag=2 N US Based on Rollup? 24 210 1=1 nvl(cic.item_cost,0)=0 LOV Oracle 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 Y US Zero Cost Items? 25 1=1 nvl(cic.item_cost,0)<>0 N US Zero Cost Items? 58314B71E1E4423CE0630100007FE7C5 Default ERIC.CLEGG 15 ACTIVITY 16 ACTIVITY_UNITS 7 BASED_ON_ROLLUP 14 BASIS 18 BASIS_FACTOR 11 COST_ELEMENT 10 COST_SOURCE_TYPE 21 ELEMENT_UNIT_COST 6 INVENTORY_ASSET 2 ITEM 29 ITEM_BURDEN_COST 27 ITEM_COST 3 ITEM_DESCRIPTION 22 ITEM_MATERIAL_COST 23 ITEM_MATERIAL_OVERHEAD_COST 25 ITEM_OUTSIDE_PROCESSING_COST 26 ITEM_OVERHEAD_COST 24 ITEM_RESOURCE_COST 4 ITEM_STATUS 28 ITEM_UNBURDENED_COST 17 ITEM_UNITS 8 LOT_SIZE 5 MAKE_OR_BUY 19 NET_YIELD_OR_SHRINKAGE_FACTOR 1 ORGANIZATION_CODE 20 RESOURCE_RATE 9 SHRINKAGE_RATE 12 SUB_ELEMENT 13 USAGE_RATE_OR_AMOUNT S Site ASHISH.SAKLANI 58314B71E1E4423CE0630100007FE7C5 ERIC.CLEGG 58314B71E1E4423CE0630100007FE7C5 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Number number Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 ROW_ID Char varchar2 Y 7 TARGET_COST_TYPE LOV custom varchar2 10 Y select cct.cost_type_id id, cct.cost_type value, cct.description from cst_cost_types cct where nvl(cct.disable_date,sysdate+1)>sysdate and cct.costing_method_type=1 and cct.allow_updates_flag=1 and cct.frozen_standard_flag<>1 and (cct.organization_id is null or cct.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) ) order by cct.cost_type :$flex$.target_cost_type Y Y 8 ORGANIZATION_CODE LOV custom varchar2 3 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and mp.cost_organization_id=mp.organization_id and nvl(mp.process_enabled_flag,'N')<>'Y' and ood.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 nvl(ood.disable_date,sysdate)>=sysdate and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) and exists (select null from cst_cost_types cct where cct.cost_type=:$flex$.target_cost_type and nvl(cct.organization_id,ood.organization_id)=ood.organization_id) order by ood.organization_code Y Y 9 ITEM LOV custom varchar2 40 Y Y select msiv.concatenated_segments value, msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and msiv.costing_enabled_flag='Y' order by msiv.concatenated_segments Y Y 10 ITEM_DESCRIPTION LOV custom varchar2 240 Y select msiv.description value, msiv.concatenated_segments description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item and msiv.costing_enabled_flag='Y' order by msiv.description, msiv.concatenated_segments select msiv.description from mtl_system_items_vl msiv, mtl_parameters mp where msiv.organization_id=mp.organization_id and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item and msiv.costing_enabled_flag='Y' Display only. Shown for reference; a value entered here is ignored by the upload. Y 11 ITEM_STATUS LOV custom varchar2 240 Y select misv.inventory_item_status_code_tl value, null description from mtl_system_items_vl msiv, mtl_parameters mp, mtl_item_status_vl misv where msiv.organization_id=mp.organization_id and msiv.inventory_item_status_code = misv.inventory_item_status_code and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item and msiv.costing_enabled_flag='Y' order by msiv.description, msiv.concatenated_segments select misv.inventory_item_status_code_tl from mtl_system_items_vl msiv, mtl_parameters mp, mtl_item_status_vl misv where msiv.organization_id=mp.organization_id and msiv.inventory_item_status_code = misv.inventory_item_status_code and mp.organization_code = :$column$.organization_code and msiv.concatenated_segments = :$column$.item and msiv.costing_enabled_flag='Y' Display only. Shown for reference; a value entered here is ignored by the upload. Y 12 MAKE_OR_BUY LOV custom varchar2 Y select xxen_util.meaning(msiv.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) value, null description from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and msiv.organization_id=mp.organization_id and msiv.concatenated_segments=:$column$.item select xxen_util.meaning(msiv.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code=:$column$.organization_code and msiv.organization_id=mp.organization_id and msiv.concatenated_segments=:$column$.item Display only. Shown for reference; a value entered here is ignored by the upload. Y 13 INVENTORY_ASSET LOV custom varchar2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type = 'SYS_YES_NO' order by value select coalesce( ( select xxen_util.meaning(cic.inventory_asset_flag,'SYS_YES_NO',700) from mtl_parameters mp, mtl_system_items_vl msiv, cst_cost_types cct, cst_item_costs cic where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item and cct.cost_type = :$flex$.source_cost_type and cic.organization_id = msiv.organization_id and cic.inventory_item_id = msiv.inventory_item_id and cic.cost_type_id = cct.cost_type_id ), ( select xxen_util.meaning(cic.inventory_asset_flag,'SYS_YES_NO',700) from mtl_parameters mp, mtl_system_items_vl msiv, cst_cost_types cct, cst_item_costs cic where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item and cct.cost_type = :$flex$.target_cost_type and cic.organization_id = msiv.organization_id and cic.inventory_item_id = msiv.inventory_item_id and cic.cost_type_id = cct.default_cost_type_id ), ( select xxen_util.meaning(decode(msiv.inventory_asset_flag,'Y',1,2),'SYS_YES_NO',700) from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item ) ) inventory_asset_flag from dual Y 14 BASED_ON_ROLLUP LOV custom varchar2 Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type = 'CST_BONROLLUP_VAL' and lookup_code != 3 order by value select coalesce( ( select xxen_util.meaning(nvl(cic.based_on_rollup_flag,2),'CST_BONROLLUP_VAL',700) from mtl_parameters mp, mtl_system_items_vl msiv, cst_cost_types cct, cst_item_costs cic where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item and cct.cost_type = :$flex$.source_cost_type and cic.organization_id = msiv.organization_id and cic.inventory_item_id = msiv.inventory_item_id and cic.cost_type_id = cct.cost_type_id ), ( select xxen_util.meaning(nvl(cic.based_on_rollup_flag,2),'CST_BONROLLUP_VAL',700) from mtl_parameters mp, mtl_system_items_vl msiv, cst_cost_types cct, cst_item_costs cic where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item and cct.cost_type = :$flex$.target_cost_type and cic.organization_id = msiv.organization_id and cic.inventory_item_id = msiv.inventory_item_id and cic.cost_type_id = cct.default_cost_type_id ), ( select xxen_util.meaning(decode(nvl(msiv.shrinkage_rate,0),0,2,1),'CST_BONROLLUP_VAL',700) from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item ) ) inventory_asset_flag from dual 15 LOT_SIZE Number number select coalesce( ( select nvl(cic.lot_size,1) from mtl_parameters mp, mtl_system_items_vl msiv, cst_cost_types cct, cst_item_costs cic where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item and cct.cost_type = :$flex$.source_cost_type and cic.organization_id = msiv.organization_id and cic.inventory_item_id = msiv.inventory_item_id and cic.cost_type_id = cct.cost_type_id ), ( select nvl(cic.lot_size,1) from mtl_parameters mp, mtl_system_items_vl msiv, cst_cost_types cct, cst_item_costs cic where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item and cct.cost_type = :$flex$.target_cost_type and cic.organization_id = msiv.organization_id and cic.inventory_item_id = msiv.inventory_item_id and cic.cost_type_id = cct.default_cost_type_id ), ( select nvl(msiv.std_lot_size,1) from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item ) ) inventory_asset_flag from dual 16 SHRINKAGE_RATE Number number select coalesce( ( select nvl(cic.shrinkage_rate,0) from mtl_parameters mp, mtl_system_items_vl msiv, cst_cost_types cct, cst_item_costs cic where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item and cct.cost_type = :$flex$.source_cost_type and cic.organization_id = msiv.organization_id and cic.inventory_item_id = msiv.inventory_item_id and cic.cost_type_id = cct.cost_type_id ), ( select nvl(cic.shrinkage_rate,0) from mtl_parameters mp, mtl_system_items_vl msiv, cst_cost_types cct, cst_item_costs cic where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item and cct.cost_type = :$flex$.target_cost_type and cic.organization_id = msiv.organization_id and cic.inventory_item_id = msiv.inventory_item_id and cic.cost_type_id = cct.default_cost_type_id ), ( select nvl(msiv.shrinkage_rate,0) from mtl_parameters mp, mtl_system_items_vl msiv where mp.organization_code = :$flex$.organization_code and msiv.organization_id = mp.organization_id and msiv.concatenated_segments = :$column$.item ) ) inventory_asset_flag from dual 17 COST_SOURCE_TYPE Char varchar2 Display only. Shown for reference; a value entered here is ignored by the upload. Y 18 COST_ELEMENT LOV custom varchar2 50 select cce.cost_element value, cce.description from cst_cost_elements cce order by cce.cost_element Y 19 SUB_ELEMENT LOV custom varchar2 10 Y select distinct br.resource_code value, br.description from mtl_parameters mp, cst_cost_elements cce, bom_resources br where mp.organization_code = :$column$.organization_code and cce.cost_element = :$column$.cost_element and br.organization_id = mp.organization_id and br.cost_element_id = cce.cost_element_id and nvl(allow_costs_flag,1) = 1 and (br.cost_element_id not in (3,4) or br.functional_currency_flag = 1) and nvl(br.disable_date,sysdate)>=sysdate order by br.resource_code 20 USAGE_RATE_OR_AMOUNT Number number Y 21 BASIS LOV varchar2 CST Item Cost Upload - Basis Type LOV EF4BB9F32810B1A4E0530100007F390C Y select ml.lookup_code id, ml.meaning value, nvl(ml.description,ml.meaning) || decode(ml.lookup_code,br.default_basis_type,' (Default)','') description from mtl_parameters mp, cst_cost_elements cce, bom_resources br, mfg_lookups ml where mp.organization_code = :$column$.organization_code and cce.cost_element = :$column$.cost_element and br.organization_id = mp.organization_id and br.cost_element_id = cce.cost_element_id and br.resource_code = :$column$.sub_element and ml.lookup_type = 'CST_BASIS_SHORT' and ( (cce.cost_element_id in (1,3,4,5,6) and ml.lookup_code in (1,2)) or (cce.cost_element_id = 2 and ml.lookup_code between 1 and 6) ) order by ml.meaning 22 ACTIVITY LOV custom varchar2 10 Y select distinct ca.activity value, ca.description from mtl_parameters mp, cst_activities ca where mp.organization_code = :$column$.organization_code and nvl(ca.organization_id,mp.organization_id) = mp.organization_id and nvl(ca.disable_date,sysdate)>=sysdate order by ca.activity 23 ACTIVITY_UNITS Number number 24 ITEM_UNITS Number number 25 ATTRIBUTE_CATEGORY LOV custom varchar2 Y select distinct fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descriptive_flexs_vl fdfv, fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=fdfv.application_id and fdfcv.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and fdfcv.enabled_flag='Y' and fdfv.application_id=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' order by fdfcv.descriptive_flex_context_name 26 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE1', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE1' 27 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE2', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE2' 28 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE3', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE3' 29 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE4', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE4' 30 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE5', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE5' 31 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE6', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE6' 32 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE7', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE7' 33 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE8', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE8' 34 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE9', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE9' 35 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE10', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE10' 36 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE11', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE11' 37 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE12', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE12' 38 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE13', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE13' 39 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE14', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE14' 40 ITEM_COST_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 => 702, p_descriptive_flexfield_name => 'CST_ITEM_COST_DETAILS', p_context_name => :$column$.attribute_category, p_column_name => 'ATTRIBUTE15', p_attribute1 => :$column$.item_cost_attribute1, p_attribute2 => :$column$.item_cost_attribute2, p_attribute3 => :$column$.item_cost_attribute3, p_attribute4 => :$column$.item_cost_attribute4, p_attribute5 => :$column$.item_cost_attribute5, p_attribute6 => :$column$.item_cost_attribute6, p_attribute7 => :$column$.item_cost_attribute7, p_attribute8 => :$column$.item_cost_attribute8, p_attribute9 => :$column$.item_cost_attribute9, p_attribute10 => :$column$.item_cost_attribute10, p_attribute11 => :$column$.item_cost_attribute11, p_attribute12 => :$column$.item_cost_attribute12, p_attribute13 => :$column$.item_cost_attribute13, p_attribute14 => :$column$.item_cost_attribute14, p_attribute15 => :$column$.item_cost_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 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=702 and fdfv.descriptive_flexfield_name='CST_ITEM_COST_DETAILS' and fdfcuv.application_column_name='ATTRIBUTE15' 41 BASIS_FACTOR Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 42 NET_YIELD_OR_SHRINKAGE_FACTOR Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 43 RESOURCE_RATE Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 44 ELEMENT_UNIT_COST Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 45 ITEM_MATERIAL_COST Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 46 ITEM_MATERIAL_OVERHEAD_COST Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 47 ITEM_RESOURCE_COST Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 48 ITEM_OUTSIDE_PROCESSING_COST Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 49 ITEM_OVERHEAD_COST Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 50 ITEM_COST Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 51 ITEM_UNBURDENED_COST Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 52 ITEM_BURDEN_COST Number number Display only. Calculated by the Item Cost Import and refreshed in the result; a value entered here is ignored by the upload. Y 53 LEVEL_TYPE Number number 1 Y 54 ROLLUP_SOURCE_TYPE Number number 1 Y 55 PROCESS_FLAG Number number 1 Y 56 UPLOAD_MODE Char varchar2 2000 :$flex$.mode Y Y 57 ROLLUP_COSTS Char varchar2 2000 :$flex$.rollup_costs Y Y 58 ROLLUP_TYPE Char varchar2 2000 :$flex$.rollup_type Y Y 59 ROLLUP_OPTION Char varchar2 2000 :$flex$.rollup_option Y Y 60 ROLLUP_UNIMPL_ECOS Char varchar2 2000 Y 61 UPLOAD_ROW Char varchar2 Y U 1 p_inventory_item_id in Number U 2 p_cost_type_id in Number TARGET_COST_TYPE U 3 p_last_update_date in Date U 4 p_last_updated_by in Number U 5 p_creation_date in Date U 6 p_created_by in Number U 7 p_last_update_login in Number U 9 p_organization_id in Number U 10 p_operation_sequence_id in Number U 11 p_operation_seq_num in Number U 12 p_department_id in Number U 13 p_level_type in Number LEVEL_TYPE U 14 p_activity_id in Number U 15 p_resource_seq_num in Number U 16 p_resource_id in Number U 17 p_resource_rate in Number U 18 p_item_units in Number ITEM_UNITS U 19 p_activity_units in Number ACTIVITY_UNITS U 20 p_usage_rate_or_amount in Number USAGE_RATE_OR_AMOUNT U 21 p_basis_type in Number BASIS U 22 p_basis_resource_id in Number U 23 p_basis_factor in Number U 24 p_net_yield_or_shrinkage_fact in Number U 25 p_item_cost in Number U 26 p_cost_element_id in Number U 27 p_rollup_source_type in Number ROLLUP_SOURCE_TYPE U 28 p_activity_context in Char U 29 p_request_id in Number U 30 p_organization_code in Char ORGANIZATION_CODE U 31 p_cost_type in Char TARGET_COST_TYPE value U 32 p_inventory_item in Char ITEM U 33 p_department in Char U 34 p_activity in Char ACTIVITY U 35 p_resource_code in Char SUB_ELEMENT U 36 p_basis_resource_code in Char U 37 p_cost_element in Char COST_ELEMENT U 38 p_error_type in Number U 39 p_program_application_id in Number U 40 p_program_id in Number U 41 p_program_update_date in Date U 42 p_attribute_category in Char ATTRIBUTE_CATEGORY U 43 p_attribute1 in Char ITEM_COST_ATTRIBUTE1 U 44 p_attribute2 in Char ITEM_COST_ATTRIBUTE2 U 45 p_attribute3 in Char ITEM_COST_ATTRIBUTE3 U 46 p_attribute4 in Char ITEM_COST_ATTRIBUTE4 U 47 p_attribute5 in Char ITEM_COST_ATTRIBUTE5 U 48 p_attribute6 in Char ITEM_COST_ATTRIBUTE6 U 49 p_attribute7 in Char ITEM_COST_ATTRIBUTE7 U 50 p_attribute8 in Char ITEM_COST_ATTRIBUTE8 U 51 p_attribute9 in Char ITEM_COST_ATTRIBUTE9 U 52 p_attribute10 in Char ITEM_COST_ATTRIBUTE10 U 53 p_attribute11 in Char ITEM_COST_ATTRIBUTE11 U 54 p_attribute12 in Char ITEM_COST_ATTRIBUTE12 U 55 p_attribute13 in Char ITEM_COST_ATTRIBUTE13 U 56 p_attribute14 in Char ITEM_COST_ATTRIBUTE14 U 57 p_attribute15 in Char ITEM_COST_ATTRIBUTE15 U 58 p_transaction_id in Number U 59 p_process_flag in Number PROCESS_FLAG U 60 p_item_number in Char U 61 p_transaction_type in Char U 62 p_yielded_cost in Number U 63 p_error_code in Char U 64 p_error_explanation in Char U 65 p_lot_size in Number LOT_SIZE value U 66 p_based_on_rollup_flag in Number BASED_ON_ROLLUP U 67 p_shrinkage_rate in Number SHRINKAGE_RATE value U 68 p_inventory_asset_flag in Number INVENTORY_ASSET U 69 p_error_flag in Char U 70 p_group_description in Char U 72 p_row_id in/out Char ROW_ID U 73 request_id_ out Number REQUEST_ID_ U 74 status_ out Char STATUS_CODE_ U 75 message_ out Char MESSAGE_ P 1 p_cost_type in Char TARGET_COST_TYPE value P 2 p_upload_mode in Number UPLOAD_MODE P 4 p_do_cost_rollup in Char Y ROLLUP_COSTS P 5 p_rollup_range in Number Y ROLLUP_TYPE P 6 p_rollup_option in Number Y ROLLUP_OPTION P 7 p_rollup_inc_unimp_ecn_flag in Number Y ROLLUP_UNIMPL_ECOS P 8 request_id_ out Number REQUEST_ID_ P 9 status_ out Char STATUS_CODE_ P 10 message_ out Char MESSAGE_ Error SQL select xu.action_, xxen_upload.status_meaning(xxen_upload.status_error) status_, case when cicdi.error_flag='E' then cicdi.error_explanation else nvl(xu.message_,'Post-Processing Error') end message_, xu.request_id_, xu.modified_columns_, xu.row_id, xu.target_cost_type, xu.organization_code, xu.item, xu.item_description, xu.item_status, xu.make_or_buy, nvl(xxen_util.meaning(cicdi.inventory_asset_flag,'SYS_YES_NO',700),xu.inventory_asset) inventory_asset, nvl(xxen_util.meaning(cicdi.based_on_rollup_flag,'CST_BONROLLUP_VAL',700),xu.based_on_rollup) based_on_rollup, nvl(cicdi.lot_size,xu.lot_size) lot_size, nvl(cicdi.shrinkage_rate,xu.shrinkage_rate) shrinkage_rate, nvl(xxen_util.meaning(cicdi.rollup_source_type,'CST_SOURCE_TYPE',700),xu.cost_source_type) cost_source_type, nvl(cicdi.cost_element,xu.cost_element) cost_element, nvl(cicdi.resource_code,xu.sub_element) sub_element, nvl(cicdi.usage_rate_or_amount,xu.usage_rate_or_amount) usage_rate_or_amount, nvl(xxen_util.meaning(cicdi.basis_type,'CST_BASIS_SHORT',700),xu.basis) basis, nvl(cicdi.activity,xu.activity) activity, nvl(cicdi.activity_units,xu.activity_units) activity_units, nvl(cicdi.item_units,xu.item_units) item_units, xu.attribute_category, xu.item_cost_attribute1, xu.item_cost_attribute2, xu.item_cost_attribute3, xu.item_cost_attribute4, xu.item_cost_attribute5, xu.item_cost_attribute6, xu.item_cost_attribute7, xu.item_cost_attribute8, xu.item_cost_attribute9, xu.item_cost_attribute10, xu.item_cost_attribute11, xu.item_cost_attribute12, xu.item_cost_attribute13, xu.item_cost_attribute14, xu.item_cost_attribute15, nvl(cicdi.basis_factor,xu.basis_factor) basis_factor, nvl(cicdi.net_yield_or_shrinkage_factor,xu.net_yield_or_shrinkage_factor) net_yield_or_shrinkage_factor, nvl(cicdi.resource_rate,xu.resource_rate) resource_rate, nvl(cicdi.item_cost,xu.element_unit_cost) element_unit_cost, to_number(null) item_material_cost, to_number(null) item_material_overhead_cost, to_number(null) item_resource_cost, to_number(null) item_outside_processing_cost, to_number(null) item_overhead_cost, to_number(null) item_cost, to_number(null) item_unburdened_cost, to_number(null) item_burden_cost, xu.level_type, xu.rollup_source_type, xu.process_flag, xu.upload_mode, xu.rollup_costs, xu.rollup_type, xu.rollup_option, xu.rollup_unimpl_ecos, xu.upload_row from xxen_cst_item_standard_3838_u xu, cst_item_cst_dtls_interface cicdi where chartorowid(xu.row_id)=cicdi.rowid(+) and cicdi.error_flag(+)='E' and (xu.status_code_=xxen_upload.status_error or cicdi.error_flag='E') Order By x.upload_row, x.target_cost_type, x.organization_code, x.item, xxen_util.lookup_code(x.cost_source_type,'CST_SOURCE_TYPE',700), x.cost_element, x.sub_element Success SQL select xxen_upload.action_meaning(xxen_upload.action_update) action_, xxen_upload.status_meaning(xxen_upload.status_success) status_, xu.message_, cic.request_id request_id_, null modified_columns_, null row_id, cct_t.cost_type target_cost_type, mp.organization_code, msiv.concatenated_segments item, msiv.description item_description, (select misv.inventory_item_status_code_tl from mtl_item_status_vl misv where misv.inventory_item_status_code=msiv.inventory_item_status_code) item_status, xxen_util.meaning(msiv.planning_make_buy_code,'MTL_PLANNING_MAKE_BUY',700) make_or_buy, xxen_util.meaning(cic.inventory_asset_flag,'SYS_YES_NO',700) inventory_asset, xxen_util.meaning(cic.based_on_rollup_flag,'CST_BONROLLUP_VAL',700) based_on_rollup, cic.lot_size, cic.shrinkage_rate, xxen_util.meaning(cicd.rollup_source_type,'CST_SOURCE_TYPE',700) cost_source_type, (select cce.cost_element from cst_cost_elements cce where cce.cost_element_id=cicd.cost_element_id) cost_element, br.resource_code sub_element, cicd.usage_rate_or_amount, xxen_util.meaning(cicd.basis_type,'CST_BASIS_SHORT',700) basis, ca.activity, cicd.activity_units, cicd.item_units, xxen_util.display_flexfield_context(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category) attribute_category, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE1',cicd.rowid,cicd.attribute1) item_cost_attribute1, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE2',cicd.rowid,cicd.attribute2) item_cost_attribute2, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE3',cicd.rowid,cicd.attribute3) item_cost_attribute3, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE4',cicd.rowid,cicd.attribute4) item_cost_attribute4, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE5',cicd.rowid,cicd.attribute5) item_cost_attribute5, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE6',cicd.rowid,cicd.attribute6) item_cost_attribute6, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE7',cicd.rowid,cicd.attribute7) item_cost_attribute7, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE8',cicd.rowid,cicd.attribute8) item_cost_attribute8, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE9',cicd.rowid,cicd.attribute9) item_cost_attribute9, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE10',cicd.rowid,cicd.attribute10) item_cost_attribute10, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE11',cicd.rowid,cicd.attribute11) item_cost_attribute11, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE12',cicd.rowid,cicd.attribute12) item_cost_attribute12, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE13',cicd.rowid,cicd.attribute13) item_cost_attribute13, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE14',cicd.rowid,cicd.attribute14) item_cost_attribute14, xxen_util.display_flexfield_value(702,'CST_ITEM_COST_DETAILS',cicd.attribute_category,'ATTRIBUTE15',cicd.rowid,cicd.attribute15) item_cost_attribute15, cicd.basis_factor, cicd.net_yield_or_shrinkage_factor, cicd.resource_rate, cicd.item_cost element_unit_cost, cic.material_cost item_material_cost, cic.material_overhead_cost item_material_overhead_cost, cic.resource_cost item_resource_cost, cic.outside_processing_cost item_outside_processing_cost, cic.overhead_cost item_overhead_cost, cic.item_cost, cic.unburdened_cost item_unburdened_cost, cic.burden_cost item_burden_cost, 1 level_type, 1 rollup_source_type, 1 process_flag, :p_upload_mode upload_mode, :p_do_cost_rollup rollup_costs, :p_rollup_range rollup_type, :p_rollup_option rollup_option, :p_rollup_inc_unimp_ecn_flag rollup_unimpl_ecos, to_number(null) upload_row from (select distinct xu.request_id_, xu.message_ from xxen_cst_item_standard_3838_u xu where xu.status_code_=xxen_upload.status_success and xu.request_id_ is not null ) xu, cst_cost_types cct_t, cst_item_costs cic, cst_item_cost_details cicd, cst_activities ca, bom_resources br, mtl_system_items_vl msiv, mtl_parameters mp where cct_t.cost_type=:p_target_cost_type and cct_t.cost_type_id=cic.cost_type_id and cic.cost_type_id=cicd.cost_type_id and cic.organization_id=cicd.organization_id and cic.inventory_item_id=cicd.inventory_item_id and cicd.rollup_source_type=1 and ca.activity_id(+)=cicd.activity_id and br.organization_id(+)=cicd.organization_id and br.resource_id(+)=cicd.resource_id and cic.organization_id=mp.organization_id and cic.organization_id=msiv.organization_id and cic.inventory_item_id=msiv.inventory_item_id and exists (select null from fnd_concurrent_requests fcr where fcr.request_id=cic.request_id and (xu.request_id_=fcr.request_id or -- for specific item cost rollup xu.request_id_=fcr.parent_request_id -- for cost import and/or all items cost rollup ) )