ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 184A903C40A16B3FE0630100007F2880 Cost Type (OPM Orgs Only) Y select x.value, x.description from ( select cmm.cost_mthd_code value, cmm.cost_mthd_desc description from cm_mthd_mst cmm where exists (select 'x' from gmf_calendar_assignments gca, org_organization_definitions ood, mtl_parameters mp where gca.legal_entity_id = ood.legal_entity and gca.cost_type_id = cmm.cost_type_id and (ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') or 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 (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and mp.organization_id = ood.organization_id and nvl(ood.disable_date,sysdate) >= sysdate and mp.organization_id <> mp.master_organization_id and mp.process_enabled_flag = 'Y' ) ) x group by x.value, x.description order by value US 8E2FF36EDF3A79D2E0530100007F1FF2 GL Ledger (inv org related) Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name AR جميع دفاتر الأستاذ المتعلقة بجميع منظمات المخزون النشطة D Alle Ledger, die sich auf alle aktiven Inventarorganisationen beziehen E Todos los libros de contabilidad relacionados con todas las organizaciones de inventario activas F Tous les grands livres relatifs à tous les organismes d'inventaire actifs I Tutti i libri contabili relativi a tutte le organizzazioni di inventario attive JA すべてのアクティブな在庫組織に関連するすべての台帳 KO 모든 활성 재고 조직과 관련된 모든 원장 PTB Todos os livros contábeis relacionados a todas as organizações de inventário ativas RU Все бухгалтерские книги, относящиеся ко всем организациям, занимающимся активным инвентаризацией. S Alla huvudböcker relaterade till alla aktiva lagerorganisationer TR Tüm aktif envanter organizasyonlarıyla ilgili tüm defterler US All ledgers related to all active inventory organizations ZHS 与所有现行清单组织有关的所有分类账 8E2FF36EDECA79D2E0530100007F1FF2 INV Category Set Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name US EC5CECA520510FC8E0530100007F5EB3 INV Item Number (costing enabled only items) 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 (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' or mp.process_enabled_flag='Y') order by msiv.concatenated_segments US 9B9627743E84607DE053BB6B635805FB INV Operating Unit Y select haouv.name value, 'Operating Unit' description from hr_all_organization_units_vl haouv where haouv.organization_id in ( select to_number(hoi.org_information3) from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where mp.organization_id<>mp.master_organization_id and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.organization_id=haou.organization_id and nvl(haou.date_to,sysdate)>=sysdate ) order by 1 AR جميع وحدات التشغيل المرتبطة بمؤسسة مخزون غير رئيسية نشطة D Alle Betriebseinheiten, die mit einer aktiven Nicht-Master-Inventarisierungsorganisation verbunden sind E Todas las unidades operativas relacionadas con una organización de inventario no maestra activa F Toutes les unités opérationnelles liées à un organisme d'inventaire non maître actif I Tutte le unità operative legate a un'organizzazione di inventario non master attiva JA アクティブな非マスターインベントリ組織に関連するすべてのオペレーティング・ユニット KO 활성 비 마스터 재고 조직과 관련된 모든 운영 단위 PTB Todas as unidades operacionais relacionadas a uma organização ativa de inventário não-mestre RU Все операционные единицы, относящиеся к действующей организации, не являющейся ведущим поставщиком инвентарных запасов. S Alla operativa enheter relaterade till en aktiv organisation som inte är huvudlager TR Etkin bir ana envanter organizasyonu ile ilgili tüm işletim birimleri US All operating units related to an active non master inventory organization ZHS 与在用的非总清单组织有关的所有业务单位： 91D3167A33531204E053BB6B63585EE3 INV Organization Code (excluding master) Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where mp.organization_id=mp.master_organization_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate order by ood.organization_code AR جميع رموز تنظيم المخزون النشط باستثناء المؤسسات الرئيسية D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master JA マスター組織を除くすべてのアクティブなインベントリ組織コード KO 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre RU Все действующие инвентаризационные коды организаций, за исключением основных организаций S Alla aktiva organisationskoder för inventarier exklusive huvudorganisationer TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları US All active inventory organization codes excluding master organizations ZHS 所有现行清单组织代码，不包括主组织 19508EAA42357240E0630100007FD049 OPM Calendar Code Y select ccht.calendar_code value, ccht.calendar_desc description from cm_cldr_hdr_tl ccht where ccht.language = userenv('lang') and exists (select 'x' from gmf_calendar_assignments gca, gmf_period_statuses gps, org_organization_definitions ood, mtl_parameters mp where gca.calendar_code = gps.calendar_code and gca.legal_entity_id = gps.legal_entity_id and gca.legal_entity_id = ood.legal_entity and gca.calendar_code = ccht.calendar_code and (ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') or 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 (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and mp.organization_id = ood.organization_id and nvl(ood.disable_date,sysdate) >= sysdate and mp.organization_id <> mp.master_organization_id ) order by value desc US OPM Calendar Code for OPM Cost Reports 19508EAA42367240E0630100007FD049 OPM Period Code Y select ccd.period_code value, ccd.period_desc description from cm_cldr_dtl ccd where exists (select 1 from gmf_period_statuses gps where gps.calendar_code = :$flex$.opm_calendar_code and gps.legal_entity_id in (select ood.legal_entity from org_organization_definitions ood where (ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') or 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 gps.period_code = ccd.period_code and gps.calendar_code = ccd.calendar_code ) order by ccd.end_date desc US OPM Period Code for OPM Cost Reporting 1A5739C5DE270375E0630100007F5142 OPM Status Code Y select gsv.status_code value, gsv.description description from gmd_status_vl gsv order by to_number(gsv.status_code) US 21C67ECE56D62CC4E0630100007F31B8 with ccmv as -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ), -- For the formula lines (msiv2), get the item costs by Cost Component line_cost as (-- If the cost type is null, get the item -- costs from the month-end item costs. select gps.legal_entity_id, gic.cost_type_id, cmm.cost_mthd_code cost_type, cmm.cost_mthd_desc cost_type_desc, mp.organization_code, -- Revision for version 1.4 -- gic.organization_id, mp.organization_id, -- End revision for version 1.4 gic.inventory_item_id, -- Revision for version 1.3 msiv2.concatenated_segments, msiv2.description item_description, msiv2.item_type, msiv2.inventory_item_status_code, msiv2.planning_make_buy_code, msiv2.primary_uom_code, -- End revision for version 1.3 gps.calendar_code, gps.period_code, gps.period_id, gid.cost_cmpntcls_id cost_component_id, -- To avoid rounding errors, use decimal precision 9 round(sum(nvl(gid.cmptcost_amt,0)),9) component_cost from gl_item_cst gic, gl_item_dtl gid, cm_mthd_mst cmm, -- Cost Types gmf_period_statuses gps, gmf_fiscal_policies gfp, gmf_calendar_assignments gca, -- Revision for version 1.3 -- mtl_system_items_vl msiv, mtl_system_items_vl msiv2, -- End revision for version 1.3 -- Revision for version 1.4 -- gmf_organization_definitions mp (select mp.organization_id, mp.organization_code, to_number(hoi.org_information2) legal_entity_id, nvl(cwa.cost_organization_id, mp.organization_id) cost_organization_id from mtl_parameters mp, hr_organization_information hoi, -- Legal Entity Id cm_whse_asc cwa where 32=32 -- p_org_code and hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and mp.organization_id = cwa.organization_id (+) ) mp -- End revision for version 1.4 where gic.cost_type_id = gfp.cost_type_id and cmm.cost_type_id = gic.cost_type_id -- Revision for version 1.4 -- and gic.organization_id = msiv2.organization_id -- and mp.organization_id = gic.organization_id and mp.organization_id = msiv2.organization_id and mp.cost_organization_id = gic.organization_id -- End revision for version 1.4 -- Revision for version 1.3 and gic.inventory_item_id = msiv2.inventory_item_id -- End revision for version 1.3 and gic.period_id = gps.period_id and gic.delete_mark = 0 -- Active and gid.itemcost_id = gic.itemcost_id -- Revision for version 1.3 and msiv2.inventory_asset_flag = 'Y' and gps.legal_entity_id = gfp.legal_entity_id and gps.cost_type_id = gfp.cost_type_id and gps.cost_type_id = gca.cost_type_id and gps.legal_entity_id = gca.legal_entity_id and gps.calendar_code = gca.calendar_code -- After running the Cost Update in Final Mode the gic.calendar_code -- is set to a null value. -- and gps.calendar_code = gic.calendar_code and mp.legal_entity_id = gps.legal_entity_id and :p_cost_type is null -- p_cost_type -- The Inventory Accounting Period Name may be different from the OPM Period Code and 32=32 -- p_org_code and 34=34 -- p_item_number and 35=35 -- p_calendar_code and 36=36 -- p_period_code group by gps.legal_entity_id, gic.cost_type_id, cmm.cost_mthd_code, -- cost_type cmm.cost_mthd_desc, -- cost_type_description mp.organization_code, -- Revision for version 1.4 -- gic.organization_id, mp.organization_id, -- End revision for version 1.4 gic.inventory_item_id, -- Revision for version 1.3 msiv2.concatenated_segments, msiv2.description, msiv2.item_type, msiv2.inventory_item_status_code, msiv2.planning_make_buy_code, msiv2.primary_uom_code, -- End revision for version 1.3 gps.calendar_code, gps.period_code, gps.period_id, gid.cost_cmpntcls_id -- cost_component_id union all -- If the cost type is not null, get the item -- costs from entered cost type. select gps.legal_entity_id, cmm.cost_type_id, cmm.cost_mthd_code cost_type, cmm.cost_mthd_desc cost_type_description, mp.organization_code, -- Revision for version 1.4 -- ccd.organization_id, mp.organization_id, -- End revision for version 1.4 ccd.inventory_item_id, -- Revision for version 1.3 msiv2.concatenated_segments, msiv2.description item_description, msiv2.item_type, msiv2.inventory_item_status_code, msiv2.planning_make_buy_code, msiv2.primary_uom_code, -- End revision for version 1.3 gps.calendar_code, gps.period_code, gps.period_id, ccm.cost_cmpntcls_id cost_component_id, -- To avoid rounding errors, use decimal precision 9 round(sum(nvl(ccd.cmpnt_cost,0)),9) item_cost from cm_cmpt_dtl ccd, cm_cmpt_mst_b ccm, cm_mthd_mst cmm, -- Cost Types gmf_period_statuses gps, gmf_calendar_assignments gca, -- Revision for version 1.3 mtl_system_items_vl msiv2, -- Revision for version 1.4 -- gmf_organization_definitions mp (select mp.organization_id, mp.organization_code, to_number(hoi.org_information2) legal_entity_id, nvl(cwa.cost_organization_id, mp.organization_id) cost_organization_id from mtl_parameters mp, hr_organization_information hoi, -- Legal Entity Id cm_whse_asc cwa where 32=32 -- p_org_code and hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and mp.organization_id = cwa.organization_id (+) ) mp -- End revision for version 1.4 where ccd.cost_cmpntcls_id = ccm.cost_cmpntcls_id and ccm.product_cost_ind = 1 -- Yes and ccd.cost_type_id = cmm.cost_type_id -- Use Period Id, not Calendar Code with ccd and ccd.period_id = gps.period_id -- Revision for version 1.4 -- and ccd.organization_id = mp.organization_id -- and ccd.organization_id = msiv2.organization_id and ccd.organization_id = mp.cost_organization_id and mp.organization_id = msiv2.organization_id -- End revision for version 1.4 -- Revision for version 1.3 and ccd.inventory_item_id = msiv2.inventory_item_id -- End revision for version 1.3 and ccd.delete_mark = 0 -- Active -- Revision for version 1.3 and msiv2.inventory_asset_flag = 'Y' and gps.cost_type_id = ccd.cost_type_id and gps.cost_type_id = gca.cost_type_id and gps.legal_entity_id = gca.legal_entity_id and gps.legal_entity_id = mp.legal_entity_id and gps.calendar_code = gca.calendar_code and :p_cost_type is not null -- p_cost_type and 32=32 -- p_org_code and 33=33 -- p_cost_type and 34=34 -- p_item_number and 35=35 -- p_calendar_code and 36=36 -- p_period_code group by gps.legal_entity_id, cmm.cost_type_id, cmm.cost_mthd_code, -- cost_type cmm.cost_mthd_desc, -- cost_type_description mp.organization_code, -- Revision for version 1.4 -- ccd.organization_id, mp.organization_id, -- End revision for version 1.4 ccd.inventory_item_id, -- Revision for version 1.3 msiv2.concatenated_segments, msiv2.description, msiv2.item_type, msiv2.inventory_item_status_code, msiv2.planning_make_buy_code, msiv2.primary_uom_code, -- End revision for version 1.3 gps.calendar_code, gps.period_code, gps.period_id, ccm.cost_cmpntcls_id -- cost_component_id ), -- Revision for version 1.10 last_formula as (select distinct ffmv2.formula_id, ffmv2.owner_organization_id organization_id, max(ffmv2.formula_vers) keep (dense_rank last order by ffmv2.formula_vers) over (partition by ffmv2.owner_organization_id, ffmv2.formula_no) version from fm_form_mst_vl ffmv2, mtl_parameters mp, gmd_status_vl gsv -- Formula Status where ffmv2.owner_organization_id = mp.organization_id and ffmv2.delete_mark = 0 -- Active and gsv.status_code = ffmv2.formula_status and 32=32 -- p_org_code and 37=37 -- p_status_to_include ) ----------------main query starts here-------------- select nvl(gl.short_name, gl.name) Ledger, haou2.name Operating_Unit, mp.organization_code Org_Code, gps.calendar_code Calendar_Code, gps.period_code Period_Code, &category_segments1 ffmv.formula_no Formula_Number, ffmv.formula_vers Formula_Version, gsv.status_code Status_Code, gsv.meaning Status_Description, ffmv.formula_desc1 Formula_Description1, ffmv.formula_class Formula_Class, gfcv.formula_class_desc Formula_Class_Description, msiv.concatenated_segments Product_Item_Number, &category_segments2 &category_segments3 nvl(ffmv.attribute4, msiv.attribute4) Label_Approval, fmd.line_no Line_No, msiv2.concatenated_segments Line_Item_Number, msiv2.description Line_Item_Description, fcl.meaning Item_Type, gl1.meaning Formula_Item_Type, -- Revision for version 1.7 misv.inventory_item_status_code Item_Status, ml1.meaning Make_Buy_Code, -- End revision for version 1.7 -- Revision for version 1.8 &p_show_more_details fmd.detail_uom Detailed_UOM, -- Revision for version 1.1 and 1.4 -- fmd.item_um Primary_UOM, msiv2.primary_uom_code Primary_UOM, -- End revision for version 1.4 fmd.qty Quantity, -- Revision for version 1.1 fmd.qty * mucv.conversion_rate Primary_Quantity, nvl((select max(line_cost.cost_type) from line_cost where line_cost.inventory_item_id = msiv.inventory_item_id and line_cost.organization_id = msiv.organization_id),'') Cost_Type, nvl((select max(line_cost.cost_type_desc) from line_cost where line_cost.inventory_item_id = msiv.inventory_item_id and line_cost.organization_id = msiv.organization_id),'') Cost_Type_Description, -- Cost_Component1 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 1=1 -- p_cost_component1 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component1", -- Cost_Component2 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 2=2 -- p_cost_component2 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component2", -- Cost_Component3 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 3=3 -- p_cost_component3 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component3", -- Cost_Component4 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 4=4 -- p_cost_component4 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component4", -- Cost_Component5 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 5=5 -- p_cost_component5 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component5", -- Cost_Component6 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 6=6 -- p_cost_component6 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component6", -- Cost_Component7 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 7=7 -- p_cost_component7 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component7", -- Cost_Component8 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 8=8 -- p_cost_component8 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component8", -- Cost_Component9 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 9=9 -- p_cost_component9 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component9", -- Cost_Component10 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 10=10 -- p_cost_component10 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component10", -- Cost_Component11 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 11=11 -- p_cost_component11 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component11", -- Cost_Component12 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 12=12 -- p_cost_component12 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component12", -- Cost_Component13 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 13=13 -- p_cost_component13 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component13", -- Cost_Component14 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 14=14 -- p_cost_component14 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component14", -- Cost_Component15 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 15=15 -- p_cost_component15 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component15", -- Cost_Component16 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 16=16 -- p_cost_component16 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component16", -- Cost_Component17 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 17=17 -- p_cost_component17 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component17", -- Cost_Component18 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 18=18 -- p_cost_component18 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component18", -- Cost_Component19 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 19=19 -- p_cost_component19 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component19", -- Cost_Component20 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 20=20 -- p_cost_component20 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component20", -- Cost_Component21 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 21=21 -- p_cost_component21 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component21", -- Cost_Component22 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 22=22 -- p_cost_component22 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component22", -- Cost_Component23 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 23=23 -- p_cost_component23 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component23", -- Cost_Component24 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 24=24 -- p_cost_component24 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component24", -- Cost_Component25 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 25=25 -- p_cost_component25 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component25", -- Cost_Component26 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 26=26 -- p_cost_component26 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component26", -- Cost_Component27 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 27=27 -- p_cost_component27 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component27", -- Cost_Component28 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 28=28 -- p_cost_component28 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component28", -- Cost_Component29 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 29=29 -- p_cost_component29 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component29", -- Cost_Component30 nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and 30=30 -- p_cost_component30 and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) "&p_cost_component30", nvl((select sum(nvl(line_cost.component_cost,0)) from ccmv, line_cost where ccmv.cost_component_id = line_cost.cost_component_id and ccmv.cost_component_code not in (:p_cost_component1, :p_cost_component2, :p_cost_component3, :p_cost_component4, :p_cost_component5, :p_cost_component6, :p_cost_component7, :p_cost_component8, :p_cost_component9, :p_cost_component10, :p_cost_component11, :p_cost_component12, :p_cost_component13, :p_cost_component14, :p_cost_component15, :p_cost_component16, :p_cost_component17, :p_cost_component18, :p_cost_component19, :p_cost_component20, :p_cost_component21, :p_cost_component22, :p_cost_component23, :p_cost_component24, :p_cost_component25, :p_cost_component26, :p_cost_component27, :p_cost_component28, :p_cost_component29, :p_cost_component30 ) and line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) Other_Costs, nvl((select sum(nvl(line_cost.component_cost,0)) from line_cost where line_cost.inventory_item_id = msiv2.inventory_item_id and line_cost.organization_id = msiv2.organization_id),0) Total_Item_Cost from fm_form_mst_vl ffmv, -- Revision for version 1.10 &p_latest_formula_table fm_matl_dtl fmd, -- Revision for version 1.1 mtl_uom_conversions_view mucv, gmf_period_statuses gps, gmf_fiscal_policies gfp, gmf_calendar_assignments gca, mtl_system_items_vl msiv, -- Formula Product Information mtl_system_items_vl msiv2, -- Formula Item Number Information -- Revision for version 1.7 mtl_item_status_vl misv, gmd_status_vl gsv, -- Formula Status gmd_formula_class_vl gfcv, -- Formula Class Description -- Revision for version 1.9 &p_show_more_dtl_tables gem_lookups gl1, -- Formula Line Type fnd_common_lookups fcl, -- Item Type -- Revision for version 1.7 mfg_lookups ml1, -- Make Buy Code mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units_vl haou, -- inv_organization_id hr_all_organization_units_vl haou2, -- operating unit gl_ledgers gl where mp.organization_id = ffmv.owner_organization_id and ffmv.formula_id = fmd.formula_id and ffmv.delete_mark = 0 -- Active -- Revision for version 1.1 and mucv.uom_code = fmd.detail_uom and mucv.inventory_item_id = fmd.inventory_item_id and mucv.organization_id = fmd.organization_id -- End revision for version 1.1 -- Revision for version 1.10 &p_latest_formula_joins and gps.legal_entity_id = gfp.legal_entity_id and gps.cost_type_id = gfp.cost_type_id and gps.cost_type_id = gca.cost_type_id and gps.legal_entity_id = gca.legal_entity_id and gps.calendar_code = gca.calendar_code and msiv.organization_id = mp.organization_id and msiv.inventory_item_id in (select max(fmd.inventory_item_id) from fm_matl_dtl fmd where fmd.line_type = 1 -- Product, may be multiple formula versions and fmd.formula_id = ffmv.formula_id ) and msiv2.organization_id = fmd.organization_id and msiv2.inventory_item_id = fmd.inventory_item_id and gsv.status_code = ffmv.formula_status -- Revision for version 1.6 and gfcv.formula_class (+) = ffmv.formula_class and gl1.lookup_type (+) = 'GMD_FORMULA_ITEM_TYPE' and gl1.lookup_code (+) = fmd.line_type -- Revision for version 1.8 &p_show_more_dtl_joins and fcl.lookup_type (+) = 'ITEM_TYPE' and fcl.lookup_code (+) = msiv2.item_type -- Revision for version 1.7 and misv.inventory_item_status_code = msiv2.inventory_item_status_code and ml1.lookup_type = 'MTL_PLANNING_MAKE_BUY' and ml1.lookup_code = msiv2.planning_make_buy_code -- End revision for version 1.7 -- Avoid the item master organization and mp.organization_id <> mp.master_organization_id -- Avoid disabled inventory organizations and sysdate < nvl(haou.date_to, sysdate +1) -- Get process organizations and nvl(mp.process_enabled_flag, 'N') = 'Y' and hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and hoi.organization_id = haou.organization_id -- this gets the organization name and haou2.organization_id = to_number(hoi.org_information3) -- this gets the operating unit id and gl.ledger_id = to_number(hoi.org_information1) -- get the ledger_id -- Revision for version 1.5 and mp.organization_code in (select oav.organization_code from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and 31=31 -- p_ledger, p_operating_unit and 32=32 -- p_org_code -- Revision for version 1.3 and 34=34 -- p_item_number and 35=35 -- p_calendar_code and 36=36 -- p_period_code and 37=37 -- p_status_to_include -- Revision for version 1.9 and 38=38 -- p_effective_date group by nvl(gl.short_name, gl.name), haou2.name, mp.organization_code, gps.calendar_code, gps.period_code, -- For category_segments1 msiv.inventory_item_id, msiv.organization_id, ffmv.formula_no, ffmv.formula_vers, gsv.status_code, gsv.meaning, -- Status_Description ffmv.formula_desc1, ffmv.formula_class, gfcv.formula_class_desc, msiv.concatenated_segments, -- Product_Item_Number -- For category_segments2 and 3 msiv2.inventory_item_id, msiv2.organization_id, nvl(ffmv.attribute4, msiv.attribute4), -- Label_Approval fmd.line_no, msiv2.concatenated_segments, -- Line_Item_Number msiv2.description, fcl.meaning, -- Item_Type gl1.meaning, -- Formula_Item_Type -- Revision for version 1.7 misv.inventory_item_status_code, ml1.meaning, -- Make_Buy_Code -- Revision for version 1.8 &p_show_more_dtl_grp fmd.detail_uom, -- Detailed_UOM -- Revision for version 1.1 and 1.4 -- fmd.item_um, -- Primary_UOM, msiv2.primary_uom_code, -- Primary_UOM -- End revision for version 1.4 fmd.qty, -- Revision for version 1.1 fmd.qty * mucv.conversion_rate -- Primary_Quantity order by nvl(gl.short_name, gl.name), haou2.name, mp.organization_code, gps.calendar_code, gps.period_code, ffmv.formula_no, ffmv.formula_vers, gl1.meaning desc, -- Line_Type msiv.concatenated_segments, -- Formula_Item_Number fmd.line_no, -- Line_No msiv2.concatenated_segments, -- Line_Item_Number msiv2.description, -- Line_Item_Description fcl.meaning -- Inventory Item_Type 1.12 10 Sep 2024 Douglas Volz Add Std Lot Size UOM column. Y #,##0.00000;[Red](#,##0.00000) US CAC OPM Costed Formula eport showing OPM formulas and item costs, by OPM Cost Component Class. The report automatically displays the first thirty Cost Components, sorted by Usage Indicator (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc), then by the Cost Component Class. With the "Other Costs" column summing up any other non-displayed Cost Component Classes. For a different selection of Cost Component Classes, you may override any of the defaulted Cost Component Classes. If you have fewer than thirty Cost Components the report automatically displays "Not Available", for the succeeding Cost Component columns. And if you enter a cost type this report uses the item costs from the cost type; if you leave the cost type blank it uses the item costs from the month-end item costs. Note: The Label Approval column is from a user-defined Formula field, attribute4. Your use of these descriptive flexfields, may be different and may require you to customize this report. General Parameters: =================== Cost Type: enter a Cost Type to value the quantities using the Cost Type item costs; or, if Cost Type is not entered the report will use the stored month-end snapshot values (optional). OPM Calendar Code: choose the OPM Calendar Code which corresponds to the inventory accounting period you wish to report (mandatory). OPM Period Code: enter the OPM Period Code related to the inventory accounting period and OPM Calendar Code you wish to report (mandatory). Only Show Latest Version: enter Yes to report the latest formula and recipe version. Enter No to see all versions (mandatory). Show More Details: enter Yes to display Ingredient Scale Type, Contribute to Yield, Standard Lot Size and End Date (from the validity rule). Mandatory. Effective Date: for material line items and validity rules, enter the last ending date to report. Defaults to today's date (mandatory). Status to Include: to minimize the report size, specify the formula, recipe and validity rule statuses you wish to report (optional). Product Category Set: the Product category set you wish to report (optional). Line Category Set 1: for the formula line item numbers, the first item category set to report (optional). Line Category Set 2: for the formula line item numbers, the second item category set to report (optional) Item Number: specific Product, By-Product or Ingredient you wish to report (optional). Organization Code: any inventory organization, defaults to your session's inventory organization (optional). Operating Unit: specific operating unit (optional). Ledger: specific ledger (optional). Cost Component 1 - 30: the defaulted Cost Component Classes. You may override these defaulted values. -- | Version Modified on Modified by Description -- | ======= =========== ============== -- | 1.0 02 Jun 2024 Douglas Volz Initial Coding based on client's sample report. -- | 1.1 03 Jun 2024 Douglas Volz UOM conversions for formula line quantities -- | 1.2 08 Jun 2024 Douglas Volz Replaced Cost Component rownum sort logic. -- | 1.3 12 Jun 2024 Douglas Volz Cleaned-up naming for Cost Component parameters, fixed item number parameter. -- | 1.4 03 Aug 2024 Douglas Volz Add OPM Cost Organizations to get correct item costs. -- | 1.5 05 Aug 2024 Douglas Volz Add inventory organization access control security. -- | 1.6 07 Aug 2024 Douglas Volz Not all formulas are assigned to classes, needs outer join. -- | 1.7 08 Aug 2024 Douglas Volz Add item status and Make/Buy columns. -- | 1.8 09 Aug 2024 Douglas Volz Add parameter "Show More Details" for Scale Type, Contribute to Yield, Std Lot Size and End Date. -- | 1.9 17 Aug 2024 Douglas Volz Add parameters "Only Show Latest Version" and "Effective Date". -- | 1.10 18 Aug 2024 Douglas Volz Restructured code. -- | 1.11 07 Sep 2024 Douglas Volz Fixed Cost Component parameters, from lexicals to bind variables. -- | 1.12 10 Sep 2024 Douglas Volz Add Std Lot Size UOM column. Enginatics &category_segments1 &category_segments2 &category_segments3 &p_cost_component1 &p_cost_component10 &p_cost_component11 &p_cost_component12 &p_cost_component13 &p_cost_component14 &p_cost_component15 &p_cost_component16 &p_cost_component17 &p_cost_component18 &p_cost_component19 &p_cost_component2 &p_cost_component20 &p_cost_component21 &p_cost_component22 &p_cost_component23 &p_cost_component24 &p_cost_component25 &p_cost_component26 &p_cost_component27 &p_cost_component28 &p_cost_component29 &p_cost_component3 &p_cost_component30 &p_cost_component4 &p_cost_component5 &p_cost_component6 &p_cost_component7 &p_cost_component8 &p_cost_component9 &p_latest_formula_joins &p_latest_formula_table &p_show_more_details &p_show_more_dtl_grp &p_show_more_dtl_joins &p_show_more_dtl_tables 10=10 11=11 12=12 13=13 14=14 15=15 16=16 17=17 18=18 19=19 1=1 20=20 21=21 22=22 23=23 24=24 25=25 26=26 27=27 28=28 29=29 2=2 30=30 31=31 32=32 33=33 34=34 35=35 36=36 37=37 38=38 3=3 4=4 5=5 6=6 7=7 8=8 9=9 :p_cost_component1 :p_cost_component10 :p_cost_component11 :p_cost_component12 :p_cost_component13 :p_cost_component14 :p_cost_component15 :p_cost_component16 :p_cost_component17 :p_cost_component18 :p_cost_component19 :p_cost_component2 :p_cost_component20 :p_cost_component21 :p_cost_component22 :p_cost_component23 :p_cost_component24 :p_cost_component25 :p_cost_component26 :p_cost_component27 :p_cost_component28 :p_cost_component29 :p_cost_component3 :p_cost_component30 :p_cost_component4 :p_cost_component5 :p_cost_component6 :p_cost_component7 :p_cost_component8 :p_cost_component9 :p_cost_type 1 10 33=33 cmm.cost_mthd_code = :p_cost_type LOV Cost Type (OPM Orgs Only) 184A903C40A16B3FE0630100007F2880 Y select x.value, x.description from ( select cmm.cost_mthd_code value, cmm.cost_mthd_desc description from cm_mthd_mst cmm where exists (select 'x' from gmf_calendar_assignments gca, org_organization_definitions ood, mtl_parameters mp where gca.legal_entity_id = ood.legal_entity and gca.cost_type_id = cmm.cost_type_id and (ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') or 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 (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and mp.organization_id = ood.organization_id and nvl(ood.disable_date,sysdate) >= sysdate and mp.organization_id <> mp.master_organization_id and mp.process_enabled_flag = 'Y' ) ) x group by x.value, x.description order by value US Cost Type 2 20 35=35 gps.calendar_code = :p_calendar_code LOV OPM Calendar Code 19508EAA42357240E0630100007FD049 Y select ccht.calendar_code value, ccht.calendar_desc description from cm_cldr_hdr_tl ccht where ccht.language = userenv('lang') and exists (select 'x' from gmf_calendar_assignments gca, gmf_period_statuses gps, org_organization_definitions ood, mtl_parameters mp where gca.calendar_code = gps.calendar_code and gca.legal_entity_id = gps.legal_entity_id and gca.legal_entity_id = ood.legal_entity and gca.calendar_code = ccht.calendar_code and (ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') or 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 (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and mp.organization_id = ood.organization_id and nvl(ood.disable_date,sysdate) >= sysdate and mp.organization_id <> mp.master_organization_id ) order by value desc select ccht.calendar_code value, ccht.calendar_desc description from cm_cldr_hdr_tl ccht where ccht.language = userenv('lang') and ccht.calendar_code = (select gps.calendar_code from gmf_calendar_assignments gca, gmf_period_statuses gps, ic_cldr_dtl icd, org_acct_periods oap, org_organization_definitions ood, mtl_parameters mp where gca.calendar_code = gps.calendar_code and gca.legal_entity_id = gps.legal_entity_id and gca.legal_entity_id = ood.legal_entity and gca.calendar_code = ccht.calendar_code -- added to tie the OPM period_id with the inventory acct_period_id and icd.fiscal_year = oap.period_year and icd.period_end_date = oap.schedule_close_date and icd.period = oap.period_num and icd.period_id = gps.period_id and oap.organization_id = mp.organization_id and oap.period_name = :$flex$.period_name and (ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') or 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 (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and mp.organization_id = ood.organization_id and nvl(ood.disable_date,sysdate) >= sysdate and mp.organization_id <> mp.master_organization_id group by gps.calendar_code ) order by value desc Y US OPM Calendar Code 3 30 36=36 gps.period_code = :p_period_code LOV OPM Period Code 19508EAA42367240E0630100007FD049 Y select ccd.period_code value, ccd.period_desc description from cm_cldr_dtl ccd where exists (select 1 from gmf_period_statuses gps where gps.calendar_code = :$flex$.opm_calendar_code and gps.legal_entity_id in (select ood.legal_entity from org_organization_definitions ood where (ood.organization_id = fnd_profile.value('MFG_ORGANIZATION_ID') or 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 gps.period_code = ccd.period_code and gps.calendar_code = ccd.calendar_code ) order by ccd.end_date desc Y US OPM Period Code 4 40 &p_latest_formula_table last_formula, 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 N Y US Only Show Latest Version 5 &p_latest_formula_joins and ffmv.formula_id = last_formula.formula_id and ffmv.formula_vers = last_formula.version and fmd.formula_id = last_formula.formula_id -- End revision for version 1.10 Y US Only Show Latest Version 6 50 &p_show_more_details gl2.meaning Scale_Type, fl1.meaning Contribute_to_Yield, -- Revision for version 1.12 last_grvr.detail_uom Lot_Size_UOM, -- Revision for version 1.10 last_grvr.std_qty Standard_Lot_Size, -- Revision for version 1.9 fmd.ingredient_end_date, -- End revision for version 1.8 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 N Y US Show More Details 7 &p_show_more_dtl_grp gl2.meaning, -- Scale_Type fl1.meaning, -- Contribute_to_Yield -- Revision for version 1.12 last_grvr.detail_uom, -- Lot_Size_UOM -- Revision for version 1.10 last_grvr.std_qty, -- Standard_Lot_Size -- Revision for version 1.9 fmd.ingredient_end_date, -- End revision for version 1.8 Y US Show More Details 8 &p_show_more_dtl_joins and gl2.lookup_type (+) = 'SCALE_TYPE' and gl2.lookup_code (+) = fmd.scale_type and fl1.lookup_type (+) = 'YES_NO' and fl1.lookup_code (+) = fmd.contribute_yield_ind -- End revision for version 1.8 -- Revision for version 1.12 and last_grvr.formula_id (+) = fmd.formula_id and last_grvr.inventory_item_id (+) = fmd.inventory_item_id -- End revision for version 1.12 Y US Show More Details 9 &p_show_more_dtl_tables fnd_lookups fl1, -- contribute to yield, YES_NO gem_lookups gl2, -- Scale Type -- End revision for version 1.9 (select distinct grvr.recipe_id, last_recipe.owner_organization_id, last_recipe.formula_id, max(grvr.recipe_validity_rule_id) keep (dense_rank last order by last_recipe.recipe_id) over (partition by last_recipe.owner_organization_id, last_recipe.recipe_id) recipe_validity_rule_id, grvr.inventory_item_id, detail_uom, grvr.std_qty from gmd_recipe_validity_rules grvr, (select distinct grv.recipe_no, grv.formula_id, grv.owner_organization_id, max(grv.recipe_id) keep (dense_rank last order by grv.recipe_version) over (partition by grv.owner_organization_id, grv.formula_id) recipe_id, max(grv.recipe_version) keep (dense_rank last order by grv.recipe_version) over (partition by grv.owner_organization_id, grv.formula_id) recipe_version from gmd_recipes_vl grv, mtl_parameters mp, gmd_status_vl gsv -- Recipe Status where grv.owner_organization_id = mp.organization_id and gsv.status_code = grv.recipe_status and 32=32 -- p_org_code and 37=37 -- p_status_to_include ) last_recipe, gmd_status_vl gsv -- Formula Status where grvr.recipe_id (+) = last_recipe.recipe_id and grvr.start_date <= :p_effective_date and (grvr.end_date is null or grvr.end_date >= :p_effective_date ) and gsv.status_code = grvr.validity_rule_status and 37=37 -- p_status_to_include ) last_grvr, Y US Show More Details 10 60 38=38 (fmd.ingredient_end_date is null or fmd.ingredient_end_date >= :p_effective_date) Date sysdate Y US Effective Date 11 70 37=37 gsv.status_code = :p_formula_status LOV OPM Status Code 1A5739C5DE270375E0630100007F5142 Y select gsv.status_code value, gsv.description description from gmd_status_vl gsv order by to_number(gsv.status_code) select gsv.status_code value, gsv.description description from gmd_status_vl gsv where gsv.status_code = 700 order by gsv.status_code US Status to Include 12 80 &category_segments1 select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>') sql_text from dual LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name select mcsv.category_set_name from mtl_default_category_sets mdcs, mtl_category_sets_v mcsv where mdcs.functional_area_id=19 and mdcs.category_set_id=mcsv.category_set_id US Product Category Set 13 90 &category_segments2 select x.* from ( select '(select min(mcb.'||lower(fifsv.application_column_name)||') keep (dense_rank first order by mic.category_id) from mtl_item_categories mic, mtl_categories_b mcb where mic.category_set_id='||mcsv.category_set_id||' and msiv2.organization_id=mic.organization_id and msiv2.inventory_item_id=mic.inventory_item_id and mic.category_id=mcb.category_id) "'||substr(fifsv.form_left_prompt,1,30)||'",' sql_text from mtl_category_sets_vl mcsv, fnd_id_flex_segments_vl fifsv where mcsv.category_set_name=:category_set_name2 and mcsv.structure_id=fifsv.id_flex_num and fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and fifsv.enabled_flag='Y' order by fifsv.id_flex_num, fifsv.segment_num ) x union all select '(select min(mct.description) keep (dense_rank first order by mic.category_id) from mtl_item_categories mic, mtl_categories_tl mct where mic.category_set_id='||mcsv.category_set_id||' and msiv2.organization_id=mic.organization_id and msiv2.inventory_item_id=mic.inventory_item_id and mic.category_id=mct.category_id and mct.language=userenv(''lang'')) "'||substr(mcsv.category_set_name||' Description',1,30)||'",' sql_text from mtl_category_sets_vl mcsv where mcsv.category_set_name=:category_set_name2 LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name select mcsv.category_set_name from mtl_default_category_sets mdcs, mtl_category_sets_v mcsv where mdcs.functional_area_id=14 and mdcs.category_set_id=mcsv.category_set_id US Line Category Set 1 14 100 &category_segments3 select x.* from ( select '(select min(mcb.'||lower(fifsv.application_column_name)||') keep (dense_rank first order by mic.category_id) from mtl_item_categories mic, mtl_categories_b mcb where mic.category_set_id='||mcsv.category_set_id||' and msiv2.organization_id=mic.organization_id and msiv2.inventory_item_id=mic.inventory_item_id and mic.category_id=mcb.category_id) "'||substr(fifsv.form_left_prompt,1,30)||'",' sql_text from mtl_category_sets_vl mcsv, fnd_id_flex_segments_vl fifsv where mcsv.category_set_name=:category_set_name3 and mcsv.structure_id=fifsv.id_flex_num and fifsv.application_id=401 and fifsv.id_flex_code='MCAT' and fifsv.enabled_flag='Y' order by fifsv.id_flex_num, fifsv.segment_num ) x union all select '(select min(mct.description) keep (dense_rank first order by mic.category_id) from mtl_item_categories mic, mtl_categories_tl mct where mic.category_set_id='||mcsv.category_set_id||' and msiv2.organization_id=mic.organization_id and msiv2.inventory_item_id=mic.inventory_item_id and mic.category_id=mct.category_id and mct.language=userenv(''lang'')) "'||substr(mcsv.category_set_name||' Description',1,30)||'",' sql_text from mtl_category_sets_vl mcsv where mcsv.category_set_name=:category_set_name3 LOV INV Category Set 8E2FF36EDECA79D2E0530100007F1FF2 Y select distinct mcsv.category_set_name value, mcsv.description from mtl_category_sets_vl mcsv where :$flex$.organization_code is null or mcsv.category_set_id in (select mic.category_set_id from mtl_parameters mp, mtl_item_categories mic where xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' and mp.organization_id=mic.organization_id) order by mcsv.category_set_name coalesce(xxen_util.previous_parameter_value(:parameter_id),(select mdsv.category_set_name from mtl_default_sets_view mdsv where mdsv.functional_area_id=5)) US Line Category Set 2 15 110 34=34 msiv2.concatenated_segments = :p_item_number LOV INV Item Number (costing enabled only items) EC5CECA520510FC8E0530100007F5EB3 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 (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' or mp.process_enabled_flag='Y') order by msiv.concatenated_segments US Item Number 16 120 32=32 mp.organization_code = :p_org_code LOV INV Organization Code (excluding master) 91D3167A33531204E053BB6B63585EE3 Y select ood.organization_code value, ood.organization_name description from org_organization_definitions ood where ood.organization_id not in (select mp.organization_id from mtl_parameters mp where mp.organization_id=mp.master_organization_id) and (:$flex$.operating_unit is null or ood.operating_unit in (select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and (:$flex$.ledger is null or ood.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and nvl(ood.disable_date,sysdate)>=sysdate 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 17 130 31=31 haou2.name = :p_operating_unit LOV INV Operating Unit 9B9627743E84607DE053BB6B635805FB Y select haouv.name value, 'Operating Unit' description from hr_all_organization_units_vl haouv where haouv.organization_id in ( select to_number(hoi.org_information3) from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where mp.organization_id<>mp.master_organization_id and mp.organization_id=hoi.organization_id and hoi.org_information_context='Accounting Information' and hoi.organization_id=haou.organization_id and nvl(haou.date_to,sysdate)>=sysdate ) order by 1 US Operating Unit 18 140 31=31 gl.name = :p_ledger LOV GL Ledger (inv org related) 8E2FF36EDF3A79D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where gl.ledger_id in (select ood.set_of_books_id from org_organization_definitions ood where nvl(ood.disable_date,sysdate)>=sysdate) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.chart_of_accounts_id=fifsv.id_flex_num and fifsv.id_flex_code='GL#' and fifsv.application_id=101 order by fifsv.id_flex_structure_name, gl.name US Ledger 19 150 1=1 ccmv.cost_component_code = :p_cost_component1 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 1 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 1 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 1 ) US Cost Component 1 20 &p_cost_component1 <parameter_value> US Cost Component 1 21 160 2=2 ccmv.cost_component_code = :p_cost_component2 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 2 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 2 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 2 ) US Cost Component 2 22 &p_cost_component2 <parameter_value> US Cost Component 2 23 170 3=3 ccmv.cost_component_code = :p_cost_component3 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 3 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 3 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 3 ) US Cost Component 3 24 &p_cost_component3 <parameter_value> US Cost Component 3 25 180 4=4 ccmv.cost_component_code = :p_cost_component4 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 4 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 4 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 4 ) US Cost Component 4 26 &p_cost_component4 <parameter_value> US Cost Component 4 27 190 5=5 ccmv.cost_component_code = :p_cost_component5 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 5 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 5 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 5 ) US Cost Component 5 28 &p_cost_component5 <parameter_value> US Cost Component 5 29 200 6=6 ccmv.cost_component_code = :p_cost_component6 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 6 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 6 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 6 ) US Cost Component 6 30 &p_cost_component6 <parameter_value> US Cost Component 6 31 210 7=7 ccmv.cost_component_code = :p_cost_component7 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 7 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 7 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 7 ) US Cost Component 7 32 &p_cost_component7 <parameter_value> US Cost Component 7 33 220 8=8 ccmv.cost_component_code = :p_cost_component8 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 8 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 8 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 8 ) US Cost Component 8 34 &p_cost_component8 <parameter_value> US Cost Component 8 35 230 9=9 ccmv.cost_component_code = :p_cost_component9 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 9 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 9 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 9 ) US Cost Component 9 36 &p_cost_component9 <parameter_value> US Cost Component 9 37 240 10=10 ccmv.cost_component_code = :p_cost_component10 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 10 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 10 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 10 ) US Cost Component 10 38 &p_cost_component10 <parameter_value> US Cost Component 10 39 250 11=11 ccmv.cost_component_code = :p_cost_component11 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 11 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 11 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 11 ) US Cost Component 11 40 &p_cost_component11 <parameter_value> US Cost Component 11 41 260 12=12 ccmv.cost_component_code = :p_cost_component12 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 12 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 12 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 12 ) US Cost Component 12 42 &p_cost_component12 <parameter_value> US Cost Component 12 43 270 13=13 ccmv.cost_component_code = :p_cost_component13 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 13 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 13 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 13 ) US Cost Component 13 44 &p_cost_component13 <parameter_value> US Cost Component 13 45 280 14=14 ccmv.cost_component_code = :p_cost_component14 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 14 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 14 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 14 ) US Cost Component 14 46 &p_cost_component14 <parameter_value> US Cost Component 14 47 290 15=15 ccmv.cost_component_code = :p_cost_component15 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 15 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 15 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 15 ) US Cost Component 15 48 &p_cost_component15 <parameter_value> US Cost Component 15 49 300 16=16 ccmv.cost_component_code = :p_cost_component16 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 16 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 16 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 16 ) US Cost Component 16 50 &p_cost_component16 <parameter_value> US Cost Component 16 51 310 17=17 ccmv.cost_component_code = :p_cost_component17 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 17 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 17 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 17 ) US Cost Component 17 52 &p_cost_component17 <parameter_value> US Cost Component 17 53 320 18=18 ccmv.cost_component_code = :p_cost_component18 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 18 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 18 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 18 ) US Cost Component 18 54 &p_cost_component18 <parameter_value> US Cost Component 18 55 330 19=19 ccmv.cost_component_code = :p_cost_component19 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 19 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 19 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 19 ) US Cost Component 19 56 &p_cost_component19 <parameter_value> US Cost Component 19 57 340 20=20 ccmv.cost_component_code = :p_cost_component20 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 20 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 20 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 20 ) US Cost Component 20 58 &p_cost_component20 <parameter_value> US Cost Component 20 59 350 21=21 ccmv.cost_component_code = :p_cost_component21 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 21 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 21 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 21 ) US Cost Component 21 60 &p_cost_component21 <parameter_value> US Cost Component 21 61 360 22=22 ccmv.cost_component_code = :p_cost_component22 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 22 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 22 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 22 ) US Cost Component 22 62 &p_cost_component22 <parameter_value> US Cost Component 22 63 370 23=23 ccmv.cost_component_code = :p_cost_component23 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 23 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 23 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 23 ) US Cost Component 23 64 &p_cost_component23 <parameter_value> US Cost Component 23 65 380 24=24 ccmv.cost_component_code = :p_cost_component24 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 24 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 24 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 24 ) US Cost Component 24 66 &p_cost_component24 <parameter_value> US Cost Component 24 67 390 25=25 ccmv.cost_component_code = :p_cost_component25 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 25 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 25 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 25 ) US Cost Component 25 68 &p_cost_component25 <parameter_value> US Cost Component 25 69 400 26=26 ccmv.cost_component_code = :p_cost_component26 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 26 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 26 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 26 ) US Cost Component 26 70 &p_cost_component26 <parameter_value> US Cost Component 26 71 410 27=27 ccmv.cost_component_code = :p_cost_component27 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 27 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 27 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 27 ) US Cost Component 27 72 &p_cost_component27 <parameter_value> US Cost Component 27 73 420 28=28 ccmv.cost_component_code = :p_cost_component28 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 28 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 28 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 28 ) US Cost Component 28 74 &p_cost_component28 <parameter_value> US Cost Component 28 75 430 29=29 ccmv.cost_component_code = :p_cost_component29 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 29 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 29 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 29 ) US Cost Component 29 76 &p_cost_component29 <parameter_value> US Cost Component 29 77 440 30=30 ccmv.cost_component_code = :p_cost_component30 LOV custom Y select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 30 ) select ccmv.cost_component_code value, ccmv.cost_cmpntcls_desc description from -- Order the Cost Components by usage_ind (1-Material, 2-Overhead, 3-Resource, 4-Expense Alloc) then by Cost Component Code (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 30 union all select fl.meaning value, fl.meaning description from fnd_lookups fl where fl.lookup_type = 'XDP_ADAPTER_STATUS' and fl.lookup_code = 'NOT_AVAILABLE' and not exists (select 'x' from (select row_number() over (order by ccmv.usage_ind, gl.meaning, ccmv.cost_cmpntcls_code) row_number, usage_ind, gl.meaning cost_component_type, ccmv.cost_cmpntcls_code cost_component_code, ccmv.cost_cmpntcls_desc, ccmv.cost_cmpntcls_id cost_component_id from cm_cmpt_mst_vl ccmv, -- Cost Component Master gem_lookups gl where gl.lookup_type = 'COST_COMPONENT_TYPE' and gl.lookup_code = ccmv.usage_ind and ccmv.delete_mark = 0 -- Active order by usage_ind, gl.meaning, ccmv.cost_cmpntcls_code ) ccmv where ccmv.row_number = 30 ) US Cost Component 30 78 &p_cost_component30 <parameter_value> US Cost Component 30 :$flex$.ledger Ledger Cost Type :$flex$.ledger Ledger OPM Calendar Code :$flex$.ledger Ledger Organization Code :$flex$.operating_unit Operating Unit Cost Type :$flex$.operating_unit Operating Unit OPM Calendar Code :$flex$.operating_unit Operating Unit Organization Code :$flex$.opm_calendar_code OPM Calendar Code OPM Period Code :$flex$.organization_code Organization Code Item Number :$flex$.organization_code Organization Code Line Category Set 1 :$flex$.organization_code Organization Code Line Category Set 2 :$flex$.organization_code Organization Code Product Category Set Pivot by Org Y MFG 31 1-BYPRODUCT 4 CALENDAR_CODE 29 COST_TYPE 30 COST_TYPE_DESCRIPTION 6 Cost Class 7 Cost Class Description 27 DETAILED_UOM 14 FORMULA_CLASS 15 FORMULA_CLASS_DESCRIPTION 12 FORMULA_DESCRIPTION1 26 FORMULA_ITEM_TYPE 8 FORMULA_NUMBER 9 FORMULA_VERSION 20 General Ledger Class 21 General Ledger Class Descripti 25 ITEM_TYPE 19 LABEL_APPROVAL 1 LEDGER 24 LINE_ITEM_DESCRIPTION 23 LINE_ITEM_NUMBER 22 LINE_NO 13 LINE_TYPE 2 OPERATING_UNIT 3 ORG_CODE 32 OTHER_COSTS 5 PERIOD_CODE 16 PRODUCT_ITEM_NUMBER 28 QUANTITY 10 STATUS_CODE 11 STATUS_DESCRIPTION 17 Sequence Dependency Class 18 Sequence Dependency Class Desc 33 TOTAL_ITEM_COST S Site MFG Pivot by Org