ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEB979D2E0530100007F1FF2 HR Operating Unit Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name Fixed where clause duplication AR وحدة التشغيل مقيدة بالتحكم في الوصول متعدد المنظمات (MOAC) D Bedieneinheit eingeschränkt durch Multi Org Access Control (MOAC) E Unidad operativa restringida por el control de acceso multiorgánico (MOAC) F Unité opérationnelle restreinte par un contrôle d'accès multi-organismes (MOAC) I Unità operativa limitata dal controllo di accesso multiorgano (MOAC) JA 多機関アクセス制御(MOAC)で制限された操作ユニット KO 다중 조직 액세스 제어 (MOAC)에 의해 제한되는 운영 단위 PTB Unidade operacional restrita por controle de acesso multi org (MOAC) RU Операционное устройство, ограниченное мультиорганизованным контролем доступа (MOAC) S Styrenhet begränsad av multi-org access control (MOAC) TR Çoklu kuruluş erişim kontrolü (MOAC) tarafından kısıtlanan işletim birimi US Operating unit restricted by multi org access control (MOAC) ZHS 受多机构访问控制（MOAC）限制的操作单元。 8E2FF36EDECB79D2E0530100007F1FF2 INV Category Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs US 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 8E2FF36EDEF179D2E0530100007F1FF2 INV Item Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.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) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments US Inventory items, restricted to the accessible inventory organizations 8E2FF36EDEB279D2E0530100007F1FF2 INV Organization Code Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( 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) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) 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 and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code AR جميع أكواد تنظيم المخزون النشط باستثناء المؤسسات الرئيسية ، مقيدة بعرض الوصول إلى مؤسسة المستخدم الحالي D Alle aktiven Inventar-Organisationscodes mit Ausnahme von Master-Organisationen, beschränkt auf die Org-Zugriffsansicht des aktuellen Benutzers E Todos los códigos de organización de inventario activos, excluyendo las organizaciones maestras, restringidos a la vista de acceso a la organización del usuario actual F Tous les codes d'organisation de l'inventaire actif, à l'exclusion des organisations maîtresses, limités à la vue d'accès à l'organisation de l'utilisateur actuel I Tutti i codici di organizzazione dell'inventario attivi, escluse le organizzazioni master, limitati alla vista di accesso all'org dell'utente corrente JA すべてのアクティブなインベントリの組織コードは、マスター組織を除いて、現在のユーザーの組織のアクセスビューに制限されます。 KO 현재 사용자의 조직 액세스보기로 제한되는 마스터 조직을 제외한 모든 활성 재고 조직 코드 PTB Todos os códigos ativos de organização de inventário, excluindo organizações mestre, restritos à visão de acesso org do usuário atual RU Все активные инвентаризационные организационные коды, исключая основные организации, ограниченные текущим представлением доступа пользователя к оргструктуре. S Alla aktiva lagerorganisationskoder exklusive huvudorganisationer, begränsade till den aktuella användarens organisationsåtkomstvy TR Ana organizasyonlar hariç tüm aktif envanter organizasyon kodları, mevcut kullanıcının organizasyon erişim görünümü ile sınırlıdır US All active inventory organization codes excluding master organizations, restricted to the current user's org access view ZHS 所有活动的清单组织代码，不包括主组织，仅限于当前用户的组织访问视图。 C55152E972F565EDE0530100007FF6C3Y with xxen_qp_preq_data as (select xml_req.*, xml_res.* from xmltable ( 'REPORT/PRICING_DATA/REQUEST' passing xmltype(xxen_qp_preq.get_report_xml_clob) columns line_number number path 'LNUM', customer_or_site varchar2(10) path 'CSFL', cust_account_id integer path 'CAID', ship_to_site_use_id integer path 'STID', bill_to_site_use_id integer path 'BTID', item_id integer path 'ITMID', -- optional order qualifiers order_type_id integer path 'OTID', ship_from_org_id integer path 'SFOID', payment_term_id integer path 'PTID', -- Pricing Request price_list_id integer path 'PLID', price_list_line_id number path 'PLLID', pricing_qty number path 'QTY', pricing_qty_uom_code varchar2(3) path 'UOM', results_xml xmltype path 'RESULTS' ) xml_req, xmltable ( '/RESULTS/ROW' passing xml_req.results_xml columns line_detail_seq number path 'LDSEQ', applied_price_list_id number path 'APLID', secondary_price_list_flag varchar2(1) path 'SPLFL', promotional_goods_flag varchar2(1) path 'PRGFL', promotional_goods_item_id number path 'PRGID', record_type varchar2(30) path 'RT', created_from_list_header_id number path 'LSTID', created_from_list_line_id number path 'LLNID', line_qty_or_amt number path 'LQTY', priced_qty number path 'PQTY', priced_uom varchar2(3) path 'PUOM', unit_price number path 'PUP', adjustment_amount number path 'PADJ', adjusted_unit_price number path 'PAUP', extended_amount number path 'PEAMT', charges_amount number path 'PCAMT', accrual_amount number path 'PAAMT', cogs_amount number path 'PCOGS', benefit varchar2(80) path 'BENFT', benefit_method varchar2(4000) path 'BENMT', benefit_value varchar2(4000) path 'BENVL', benefit_item varchar2(360) path 'BENIT', benefit_qty number path 'BENQT', operand varchar2(80) path 'OPR', operand_value number path 'OPRV', price_formula varchar2(250) path 'PFRM', currency varchar2(3) path 'CUR', base_currency varchar2(3) path 'BCUR', multi_currency_flag varchar2(1) path 'MCFL', exchange_rate_type varchar2(30) path 'XRTT', exchange_rate number path 'XRT', product_precedence number path 'PPREC', automatic_flag varchar2(1) path 'ATMFL', override_flag varchar2(1) path 'OVRFL', accrual_flag varchar2(1) path 'ACCFL', attribute_level varchar2(10) path 'ALVL', attribute_grouping_num number path 'AGPN', attribute_context varchar2(80) path 'ACTX', attribute varchar2(80) path 'ANME', attribute_operator varchar2(30) path 'AOPR', attribute_value_from varchar2(240) path 'AVLFR', attribute_value_to varchar2(240) path 'AVTO', attribute_precedence number path 'APREC' ) xml_res ) -- -- Main Query Starts Here -- select x.* from ( select -- customer xxqpd.customer_or_site, hp.party_name customer_name, hca.account_number account_number, hp.party_name || ' - ' || hca.account_number customer_name_and_account, nvl(xxen_util.meaning(hp.category_code,'CUSTOMER_CATEGORY',222),hp.category_code) customer_category, nvl(xxen_util.meaning(hca.customer_class_code,'CUSTOMER CLASS',222),hca.customer_class_code) customer_class, nvl(xxen_util.meaning(hca.sales_channel_code,'SALES_CHANNEL',660),hca.sales_channel_code) sales_channel, hcpc.name customer_profile, nvl(hcp.discount_terms,'N') customer_allow_discount, (select rtv.name from ra_terms_vl rtv where rtv.term_id = nvl(hca.payment_term_id,hcp.standard_terms) ) customer_payment_term, (select qslhv.name from qp_secu_list_headers_vl qslhv where qslhv.list_header_id = hca.price_list_id ) customer_price_list, -- ship_to/bill to OU nvl(haouv1.name,haouv2.name) operating_unit, -- ship_to site hcsua1.location ship_to_location_code, hcsua1.location || ' ' || hl1.address1 || ' ' || hl1.address2 || ' ' || hl1.address3 ship_to_location, hcsua1.primary_flag ship_to_primary_flag, hcpc1.name ship_to_profile, (select mp.organization_code from mtl_parameters mp where mp.organization_id = hcsua1.warehouse_id ) ship_to_ship_from_warehouse, (select ottt.name from oe_transaction_types_tl ottt where ottt.transaction_type_id = hcsua1.order_type_id and ottt.language = userenv('lang') ) ship_to_order_type, (select rtv.name from ra_terms_vl rtv where rtv.term_id = hcsua1.payment_term_id ) ship_to_payment_term, (select qslhv.name from qp_secu_list_headers_vl qslhv where qslhv.list_header_id = hcsua1.price_list_id ) ship_to_price_list, -- bill_to site hcsua2.location bill_to_location_code, hcsua2.location || ' ' || hl2.address1 || ' ' || hl2.address2 || ' ' || hl2.address3 bill_to_location, hcsua2.primary_flag bill_to_primary_flag, hcpc2.name bill_to_profile, (select mp.organization_code from mtl_parameters mp where mp.organization_id = hcsua2.warehouse_id ) bill_to_ship_from_warehouse, (select ottt.name from oe_transaction_types_tl ottt where ottt.transaction_type_id = hcsua2.order_type_id and ottt.language = userenv('lang') ) bill_to_order_type, (select rtv.name from ra_terms_vl rtv where rtv.term_id = hcsua2.payment_term_id ) bill_to_payment_term, (select qslhv.name from qp_secu_list_headers_vl qslhv where qslhv.list_header_id = hcsua2.price_list_id ) bill_to_price_list, -- hp.party_name || ' - ' || hca.account_number || nvl2(nvl(hcsua1.location,hcsua2.location), ' - ' || nvl(hcsua1.location || ' ' || hl1.address1 || ' ' || hl1.address2 || ' ' || hl1.address3, hcsua2.location || ' ' || hl2.address1 || ' ' || hl2.address2 || ' ' || hl2.address3) || ' - ' || '(' || nvl(haouv1.name,haouv2.name) || ')', '' ) customer_and_site_org_desc, -- Price List qslhv1.name price_list, qslhv1.description price_list_description, xxen_util.meaning(qslhv1.list_type_code,'LIST_TYPE_CODE',661) price_list_type, qslhv1.currency_code price_list_currency, nvl(qslhv1.global_flag,'N') price_list_global_flag, haouv3.name price_list_operating_unit, (select rtv.name from ra_terms_vl rtv where rtv.term_id = qslhv1.terms_id ) price_list_payment_term, -- pricing request -- item msik.concatenated_segments pricing_item_code, msik.description pricing_item_description, msik.concatenated_segments || ' - ' || msik.description pricing_item_code_and_descr, xxen_qp_preq.get_pricing_date pricing_date, xxqpd.pricing_qty, xxqpd.pricing_qty_uom_code, decode(qll1.list_line_type_code,'PBH','Y') price_break_flag, xxen_qp_preq.get_pricing_currency pricing_currency_code, -- order qualifiers xxen_qp_preq.get_agreement pricing_agreement_name, xxen_qp_preq.get_order_source pricing_order_source, (select ottt.name from oe_transaction_types_tl ottt where ottt.transaction_type_id = xxqpd.order_type_id and ottt.language = userenv('lang') ) pricing_order_type, (select mp.organization_code from mtl_parameters mp where mp.organization_id = xxqpd.ship_from_org_id ) pricing_warehouse, (select rtv.name from ra_terms_vl rtv where rtv.term_id = xxqpd.payment_term_id ) pricing_payment_term, -- -- Pricing Engine Results -- qslhv2.name applied_price_list, xxqpd.secondary_price_list_flag, xxqpd.promotional_goods_flag, msik2.concatenated_segments priced_item, msik2.description priced_item_descscription, nvl2(xxqpd.promotional_goods_flag,msik.concatenated_segments || ' (P) ','') || msik2.concatenated_segments || ' - ' || msik2.description priced_item_code_and_descr, msik2.primary_uom_code priced_item_primary_uom_code, xxen_util.meaning(msik.bom_item_type,'BOM_ITEM_TYPE',700) bom_item_type, xxen_qp_preq.get_category_set_name category_set, &category_set_columns cst_cost_api.get_item_cost(1,msik2.inventory_item_id,xxen_qp_preq.get_cost_organization_id,null,xxen_qp_preq.get_cost_type_id) priced_item_cost, xxen_qp_preq.get_cost_organization_code item_cost_organization, case xxqpd.record_type when 'S' then 'Summary' when 'D' then 'Detail' when 'QA' then 'Qualifier Attribute' when 'PA' then 'Pricing Attribute' else xxqpd.record_type end record_type, qslhv3.name list_name, nvl(qll3.list_line_no,xxqpd.created_from_list_line_id) list_line_num, xxen_util.meaning(qslhv3.list_type_code,'LIST_TYPE_CODE',661) list_type, xxen_util.meaning(qll3.list_line_type_code,'LIST_LINE_TYPE_CODE',661) line_type, xxqpd.line_qty_or_amt, xxqpd.priced_qty, xxqpd.priced_uom, xxqpd.unit_price, xxqpd.adjustment_amount, xxqpd.adjusted_unit_price, xxqpd.extended_amount, xxqpd.charges_amount, xxqpd.accrual_amount, xxqpd.cogs_amount, case when nvl(xxqpd.cogs_amount,0) = 0 then to_number(null) else (xxqpd.extended_amount - xxqpd.cogs_amount) end margin_pre_accrual, case when nvl(xxqpd.cogs_amount,0) = 0 then to_number(null) else round((xxqpd.extended_amount - xxqpd.cogs_amount) / xxqpd.cogs_amount * 100,2) end margin_pre_accrual_pct, case when nvl(xxqpd.cogs_amount,0) = 0 then to_number(null) else (xxqpd.extended_amount + nvl(xxqpd.accrual_amount,0) - xxqpd.cogs_amount) end margin_post_accrual, case when nvl(xxqpd.cogs_amount,0) = 0 then to_number(null) else round((xxqpd.extended_amount + nvl(xxqpd.accrual_amount,0) - xxqpd.cogs_amount) / xxqpd.cogs_amount * 100,2) end margin_post_accrual_pct, xxen_util.meaning(qpbv3.price_break_type_code,'PRICE_BREAK_TYPE_CODE',661) pb_type, qp_qp_form_pricing_attr.get_attribute('QP_ATTR_DEFNS_PRICING', qpbv3.pricing_attribute_context, qpbv3.pricing_attribute) pb_attribute, xxen_util.meaning(qpbv3.comparison_operator_code,'COMPARISON_OPERATOR',661) pb_operator, qpbv3.pricing_attr_value_from pb_from, qpbv3.pricing_attr_value_to pb_to, xxqpd.benefit, xxqpd.benefit_method, xxqpd.benefit_value, xxqpd.benefit_item, xxqpd.benefit_qty, xxqpd.operand, xxqpd.operand_value, xxqpd.price_formula, xxqpd.currency, xxqpd.base_currency, xxqpd.multi_currency_flag, xxqpd.exchange_rate_type, xxqpd.exchange_rate, xxqpd.product_precedence, xxqpd.automatic_flag, xxqpd.override_flag, xxqpd.accrual_flag, xxqpd.attribute_level, xxqpd.attribute_grouping_num, xxqpd.attribute_context, xxqpd.attribute, xxqpd.attribute_operator, xxqpd.attribute_value_from, xxqpd.attribute_value_to, xxqpd.attribute_precedence, -- record sequencing columns xxqpd.line_number, xxqpd.line_detail_seq from xxen_qp_preq_data xxqpd, -- customer hz_cust_accounts hca, hz_parties hp, hz_customer_profiles hcp, hz_cust_profile_classes hcpc, -- ship to site hz_cust_site_uses_all hcsua1, hz_cust_acct_sites_all hcasa1, hz_party_sites hps1, hz_locations hl1, hr_all_organization_units_vl haouv1, hz_customer_profiles hcp1, hz_cust_profile_classes hcpc1, -- bill to site hz_cust_site_uses_all hcsua2, hz_cust_acct_sites_all hcasa2, hz_party_sites hps2, hz_locations hl2, hr_all_organization_units_vl haouv2, hz_customer_profiles hcp2, hz_cust_profile_classes hcpc2, -- items mtl_system_items_b_kfv msik, mtl_system_items_b_kfv msik2, -- requested price list qp_secu_list_headers_vl qslhv1, hr_all_organization_units_vl haouv3, qp_list_lines qll1, -- applied Price List qp_secu_list_headers_vl qslhv2, -- PE PLL/Modifier List headers/list lines qp_secu_list_headers_vl qslhv3, qp_list_lines qll3, qp_price_breaks_v qpbv3 where -- customer hca.cust_account_id = xxqpd.cust_account_id and hp.party_id = hca.party_id and hcp.cust_account_id (+) = hca.cust_account_id and nvl(hcp.site_use_id,-1) = -1 and hcpc.profile_class_id (+) = hcp.profile_class_id -- ship to site and hcsua1.site_use_id (+) = xxqpd.ship_to_site_use_id and hcasa1.cust_acct_site_id (+) = hcsua1.cust_acct_site_id and hps1.party_site_id (+) = hcasa1.party_site_id and hl1.location_id (+) = hps1.location_id and haouv1.organization_id (+) = hcsua1.org_id and hcp1.site_use_id (+) = hcsua1.site_use_id and hcpc1.profile_class_id (+) = hcp1.profile_class_id -- bill to site and hcsua2.site_use_id (+) = xxqpd.bill_to_site_use_id and hcasa2.cust_acct_site_id (+) = hcsua2.cust_acct_site_id and hps2.party_site_id (+) = hcasa2.party_site_id and hl2.location_id (+) = hps2.location_id and haouv2.organization_id (+) = hcsua2.org_id and hcp2.site_use_id (+) = hcsua2.site_use_id and hcpc2.profile_class_id (+) = hcp2.profile_class_id -- item msik = requested item, msik2 = priced item and msik.inventory_item_id = xxqpd.item_id and msik.organization_id = xxen_qp_preq.get_item_organization_id and msik2.inventory_item_id = nvl(xxqpd.promotional_goods_item_id,xxqpd.item_id) and msik2.organization_id = xxen_qp_preq.get_item_organization_id -- requested price list and qslhv1.list_header_id = xxqpd.price_list_id and haouv3.organization_id (+) = qslhv1.orig_org_id and qll1.list_line_id = xxqpd.price_list_line_id -- applied price list and qslhv2.list_header_id (+) = xxqpd.applied_price_list_id -- PE PLL/Modifier List headers/list lines and qslhv3.list_header_id (+) = xxqpd.created_from_list_header_id and qll3.list_header_id (+) = xxqpd.created_from_list_header_id and qll3.list_line_id (+) = xxqpd.created_from_list_line_id and qpbv3.list_header_id (+) = xxqpd.created_from_list_header_id and qpbv3.list_line_id (+) = xxqpd.created_from_list_line_id and ( hcsua1.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) or hcsua2.org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) or (hcsua1.org_id is null and hcsua2.org_id is null) ) ) x where 1=1 order by x.customer_name, x.account_number, x.pricing_item_code, x.price_list, x.customer_or_site, x.operating_unit, x.ship_to_location, x.bill_to_location, x.line_number, x.line_detail_seq Fixed bug in operating unit access restriction when the default operating unit is set to something else XXEN_QP_PREQ (:Customer_Name is not null or :Account_Number is not null) US QP Customer Pricing Engine Request QP Customer Pricing Engine Request ============================== This report requests Item Selling Price information by Customer across Price Lists from the Pricing Engine. The report also displays the Items Costs for the specified Organization and based on the Unit Selling Price and Item Cost, displays a Margin Analysis. The report can be run in Summary or Detail Mode. In Summary Mode, the report will display a summary of Applied Price Lists, List Price, Adjustment Amount, Final Unit Selling Price, Accrual Amount, Charge Amount, Item Cost, and Margin per Customer, requested Price List and Item. Summary Records can be identified in the report with Record Type=Summary In Detail Mode, in additional to the summary information, the report will include the following record types: - Detail Record Type which provides a breakdown of the Price List and Modifier Lines the pricing engine has applied in the calculation of the final unit selling price - Pricing Attribute Record Type provides details of the Pricing Attributes considered by the Pricing Engine in selecting a specified Price List or Modifier - Qualifier Attribute Record Type provides details of any Qualifier Attributes considered by the Pricing Engine in selecting a specific Price List or Modifier Detail Record Types follow the Summary Record Type they apply to Pricing Attribute and Qualifier Attribute Record Types follow the Detail Record Type they apply to. Additionally, the report supports the following options: - Use Secondary Price Lists (Yes/No) When No, the report will restrict to displaying Prices on the requested Price Lists only When Yes, then the report will check for the price on any secondary price lists defined for the requested Price List - Expand Price Breaks (Yes/No) When No, the report will display the pricing based on the requested Pricing Only When Yes, the report will display one line per Price Break to provide an indication of the unit selling price will vary across the Price Breaks and the impact that may have on margins - Display Promotional Goods (Buy One Get One free type Promotions)) When No, the report will not display any Promotional Goods the Customer maybe eligible to receive When Yes, the report will display any Promotional Goods the Customer maybe eligible to receive - Display Site Pricing Differences When No, the report will only check the Pricing Based on the specified Customer Accounts When Yes, the report will also check the Pricing based on the specified Ship To/Bill To Locations. If the pricing at the Customer Site is the same as at the Customer Level, only the Customer Level pricing is displayed in the report. If the pricing at the Customer Site differs to the pricing at the Customer Level, then both the Customer Pricing and Site Pricing is included in the report. If a Ship To or Bill To location is not specified, and the Display Site Pricing Differences is set to Yes, the report will check all active ship to sites for the Customer within the specified Operating Units. It is also possible to specify some additional Order Qualifiers to be considered by the Pricing Engine. These are: - Organization - this is used as the Shipping Warehouse, It also determines from which Items can be selected and also determines the Organization from which the Item Costs are derived. - Sales Agreement - Order Source - Order Type Lastly the user can specify - Pricing Request Date - Pricing Request Quantity - Currency Code Unit Selling Price, Item Costs, and extended amounts are all displayed in the specified currency. The user can only select a currency that is supported by the selected Price Lists. Please specify values for Customer Name or Account Number Enginatics R12 only &category_set_columns 1=1 :p_account_number :p_agreement :p_bill_to_location :p_category :p_category_set_name :p_classification_code :p_conc_request_id :p_cost_type :p_currency_code :p_customer_name :p_customer_order_enabled :p_item :p_item_bulk_fetch_limit :p_log_level :p_operating_unit :p_order_source :p_order_type :p_organization_code :p_price_by_customer_site :p_price_list :p_pricing_qty :p_pricing_request_date :p_qp_api_batch_size :p_report_level :p_request_type_code :p_sales_channel_code :p_ship_to_location :p_show_price_breaks :p_show_promotional_goods :p_uom_code :p_use_secondary_price_lists 1 -40 :p_log_level LOV custom Y select lookup_code id, meaning value, null description from fnd_lookups where lookup_type = 'AFLOG_LEVELS' order by lookup_code desc 3 US Logging Level 2 -30 :p_request_type_code Char ONT Y F Code du type de demande US Request Type Code 3 -20 :p_item_bulk_fetch_limit Number 5000 F Limite d'extraction en masse des éléments US Item Bulk Fetch Limit 4 -10 :p_qp_api_batch_size Number 500 F Taille du lot du moteur de tarification US Pricing Engine Batch Size 5 10 :p_report_level LOV custom Y select x.value value, x.description description from (select 'Summary' value, 'Summary Report with one line per Customer/Customer Site, Price List, and Item showing the summarized Pricing amounts' description from dual union select 'Detail' value, 'Detail Report with separate lines per adjustment and matching attributes/qualifiers' description from dual ) x order by x.value Summary Y F Niveau du rapport US Report Level 6 20 1=1 (x.operating_unit is null or x.operating_unit=:p_operating_unit) LOV HR Operating Unit 8E2FF36EDEB979D2E0530100007F1FF2 Y select hou.name value, null description from hr_operating_units hou where sysdate between hou.date_from and nvl(hou.date_to,sysdate) and (:$flex$.ledger is null or hou.set_of_books_id in (select gl.ledger_id from gl_ledgers gl where xxen_util.contains(:$flex$.ledger,gl.name)='Y')) and hou.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) F Unité d'exploitation US Operating Unit 7 30 1=1 x.customer_name=:p_customer_name LOV custom Y select hp.party_name value, hca.account_number description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and hp.status='A' and hca.status='A' and hca.cust_account_id in ( select distinct hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa where hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and haouv.organization_id=hcasa.org_id and hcasa.status='A' and hcsua.status='A' and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') ) order by hp.party_name F Nom du client US Customer Name 8 40 1=1 x.account_number=:p_account_number LOV custom Y select hca.account_number value, hp.party_name||' ('||initcap(hp.party_type)||')' description from hz_parties hp, hz_cust_accounts hca where hp.party_id=hca.party_id and hp.status='A' and hca.status='A' and hca.cust_account_id in ( select distinct hcasa.cust_account_id from hr_all_organization_units_vl haouv, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa where hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and haouv.organization_id=hcasa.org_id and hcasa.status='A' and hcsua.status='A' and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haouv.name) = 'Y') ) order by hp.party_name F Numéro de compte US Account Number 9 50 1=1 (x.ship_to_location_code is null or x.ship_to_location_code=:p_ship_to_location) LOV custom Y select hcsua.location value, hp.party_name || ' (' || hca.account_number || ') - ' || haouv.name || decode(hcsua.primary_flag,'Y',' (Primary)') description from hz_parties hp, hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hr_all_organization_units_vl haouv where hca.party_id=hp.party_id and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and haouv.organization_id=hcasa.org_id and hcsua.site_use_code='SHIP_TO' and hp.status='A' and hca.status='A' and hcasa.status='A' and hcsua.status='A' and (:$flex$.operating_unit is null or haouv.name=:$flex$.operating_unit) and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.customer_name is null or hp.party_name=:$flex$.customer_name) and (:$flex$.account_number is null or hca.account_number=:$flex$.account_number) and (:$flex$.customer_name is not null or :$flex$.account_number is not null) order by hcsua.location F Lieu d'expédition du client US Customer Ship To Location 10 60 1=1 (x.bill_to_location_code is null or x.bill_to_location_code=:p_bill_to_location) LOV custom Y select hcsua.location value, hp.party_name || ' (' || hca.account_number || ') - ' || haouv.name || decode(hcsua.primary_flag,'Y',' (Primary)') description from hz_parties hp, hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hr_all_organization_units_vl haouv where hca.party_id=hp.party_id and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and haouv.organization_id=hcasa.org_id and hcsua.site_use_code='BILL_TO' and hp.status='A' and hca.status='A' and hcasa.status='A' and hcsua.status='A' and (:$flex$.operating_unit is null or haouv.name=:$flex$.operating_unit) and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.customer_name is null or hp.party_name=:$flex$.customer_name) and (:$flex$.account_number is null or hca.account_number=:$flex$.account_number) and (:$flex$.customer_name is not null or :$flex$.account_number is not null) and (:$flex$.customer_ship_to_location is null or exists (select null -- make sure the bill to is in the same OU as the slected ship to from hz_cust_acct_sites_all hcasa2, hz_cust_site_uses_all hcsua2 where hcasa2.cust_account_id = hca.cust_account_id and hcsua2.cust_acct_site_id = hcasa2.cust_acct_site_id and hcsua2.location = :$flex$.customer_ship_to_location and hcsua2.site_use_code = 'SHIP_TO' and hcsua2.org_id = hcsua.org_id ) ) order by hcsua.location select hcsua2.location from hz_parties hp, hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua, hz_cust_acct_sites_all hcasa2, hz_cust_site_uses_all hcsua2, hr_all_organization_units_vl haouv where hca.party_id=hp.party_id and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and haouv.organization_id=hcasa.org_id and hcsua.site_use_code='SHIP_TO' and hp.status='A' and hca.status='A' and hcasa.status='A' and hcsua.status='A' and (:$flex$.operating_unit is null or haouv.name=:$flex$.operating_unit) and haouv.organization_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.customer_name is null or hp.party_name=:$flex$.customer_name) and (:$flex$.account_number is null or hca.account_number=:$flex$.account_number) and (:$flex$.customer_name is not null or :$flex$.account_number is not null) and hcsua.location = :$flex$.customer_ship_to_location and hcasa2.cust_account_id=hca.cust_account_id and hcsua2.cust_acct_site_id=hcasa2.cust_acct_site_id and hcsua2.site_use_code='BILL_TO' and hcasa2.status='A' and hcsua2.status='A' and hcsua2.org_id=hcsua.org_id and (hcsua2.site_use_id = hcsua.bill_to_site_use_id or (hcsua.bill_to_site_use_id is null and hcsua2.primary_flag = 'Y')) order by hcsua.location F Lieu de facturation du client US Customer Bill To Location 11 70 1=1 x.price_list=:p_price_list LOV custom Y select distinct qslhv.name value ,qslhv.currency_code || ': ' || xxen_util.meaning(qslhv.list_type_code,'LIST_TYPE_CODE',661) || ': ' || decode(qslhv.global_flag,'Y','Global',haou.name) || ': ' || qslhv.description description from qp_pte_request_types_v qprtv, qp_secu_list_headers_vl qslhv, hr_all_organization_units haou where qslhv.pte_code = qprtv.pte_code and haou.organization_id (+) = qslhv.orig_org_id and (:$flex$.request_type_code is null or qprtv.request_type_code = :$flex$.request_type_code) and qslhv.list_type_code in ('PRL','AGR') and :$flex$.pricing_request_date between nvl(qslhv.start_date_active,:$flex$.pricing_request_date) and nvl(qslhv.end_date_active,:$flex$.pricing_request_date) and qslhv.active_flag = 'Y' and ( qslhv.global_flag = 'Y' or ( qslhv.orig_org_id in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) and (:$flex$.operating_unit is null or xxen_util.contains(:$flex$.operating_unit,haou.name) = 'Y') ) ) order by qslhv.name select qslhv.name from qp_secu_list_headers_vl qslhv where qslhv.list_header_id = coalesce( (select hcsua.price_list_id from hz_parties hp, hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua where hca.party_id=hp.party_id and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcsua.site_use_code='SHIP_TO' and (:$flex$.customer_name is null or hp.party_name=:$flex$.customer_name) and (:$flex$.account_number is null or hca.account_number=:$flex$.account_number) and hcsua.location = :$flex$.customer_ship_to_location and hcsua.price_list_id is not null and rownum=1 ) ,(select hcsua.price_list_id from hz_parties hp, hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua where hca.party_id=hp.party_id and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcsua.site_use_code='BILL_TO' and (:$flex$.customer_name is null or hp.party_name=:$flex$.customer_name) and (:$flex$.account_number is null or hca.account_number=:$flex$.account_number) and hcsua.location = :$flex$.customer_bill_to_location and hcsua.price_list_id is not null and rownum=1 ) ,(select hca.price_list_id from hz_parties hp, hz_cust_accounts hca where hca.party_id=hp.party_id and (:$flex$.customer_name is null or hp.party_name=:$flex$.customer_name) and (:$flex$.account_number is null or hca.account_number=:$flex$.account_number) and (:$flex$.customer_name is not null or :$flex$.account_number is not null) and rownum=1 ) ) F Liste des prix US Price List 12 80 :p_currency_code LOV custom Y select fcv.currency_code value, fcv.description from fnd_currencies_vl fcv where fcv.enabled_flag='Y' and ( :$flex$.price_list is null or fcv.currency_code in (select qslhv.currency_code from qp_secu_list_headers_vl qslhv where xxen_util.contains(:$flex$.price_list,qslhv.name) = 'Y' union select qdt.to_currency_code from qp_secu_list_headers_vl qslhv, qp_currency_details qdt where qdt.currency_header_id = qslhv.currency_header_id and xxen_util.contains(:$flex$.price_list,qslhv.name) = 'Y' and fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED') in ('Y','YES') and fnd_profile.value('QP_MULTI_CURRENCY_USAGE') = 'Y' ) ) order by fcv.currency_code coalesce( (select qslhv.currency_code from qp_secu_list_headers_vl qslhv where qslhv.name = :$flex$.price_list) ,(select gsob.currency_code from hr_operating_units hou, gl_sets_of_books gsob where gsob.set_of_books_id=hou.set_of_books_id and hou.organization_id=nvl(fnd_global.org_id,(select mgoat.organization_id from mo_glob_org_access_tmp mgoat where mgoat.organization_id=nvl(fnd_profile.value('DEFAULT_ORG_ID'),mgoat.organization_id) and rownum=1)) ) ) Y F Code devise US Currency Code 13 90 :p_organization_code LOV INV Organization Code 8E2FF36EDEB279D2E0530100007F1FF2 Y select ood.organization_code value, ood.organization_name||' ('||ftv.territory_short_name||', '||hla.town_or_city||decode(mp.organization_id,mp.master_organization_id,null,', '||mp0.organization_code)||')' description from org_organization_definitions ood, mtl_parameters mp, mtl_parameters mp0, hr_all_organization_units haou, hr_locations_all hla, fnd_territories_vl ftv where ood.organization_id=mp.organization_id and mp.organization_id<>mp.master_organization_id and ( 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) or not exists (select null from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and ood.operating_unit in (select mgoat.organization_id from mo_glob_org_access_tmp mgoat union select fnd_global.org_id from dual where fnd_release.major_version=11) ) 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 and mp.master_organization_id=mp0.organization_id and ood.organization_id=haou.organization_id(+) and haou.location_id=hla.location_id(+) and hla.country=ftv.territory_code(+) order by ood.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id = coalesce( to_number(fnd_profile.value('MFG_ORGANIZATION_ID')) ,(select hcsua.warehouse_id from hz_parties hp, hz_cust_accounts hca, hz_cust_acct_sites_all hcasa, hz_cust_site_uses_all hcsua where hca.party_id=hp.party_id and hcasa.cust_account_id=hca.cust_account_id and hcsua.cust_acct_site_id=hcasa.cust_acct_site_id and hcsua.site_use_code='SHIP_TO' and (:$flex$.customer_name is null or hp.party_name=:$flex$.customer_name) and (:$flex$.account_number is null or hca.account_number=:$flex$.account_number) and (:$flex$.customer_name is not null or :$flex$.account_number is not null) and hcsua.location = :$flex$.customer_ship_to_location and hcsua.warehouse_id is not null and rownum=1 ) ,(select hca.warehouse_id from hz_parties hp, hz_cust_accounts hca where hca.party_id=hp.party_id and (:$flex$.customer_name is null or hp.party_name=:$flex$.customer_name) and (:$flex$.account_number is null or hca.account_number=:$flex$.account_number) and (:$flex$.customer_name is not null or :$flex$.account_number is not null) and hca.warehouse_id is not null and rownum=1 ) ) F Code de l'organisation Ship From Organization Code US Organization Code Ship From Organization Code 14 100 :p_category_set_name 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=1)) Y F Ensemble de la catégorie US Category Set 15 &category_set_columns select xxen_util.item_category_columns(p_category_set_name=>'<parameter_value>', p_table_alias=>'msik2') sql_text from dual F Ensemble de la catégorie US Category Set 16 110 1=1 x.category_segments=:p_category LOV INV Category 8E2FF36EDECB79D2E0530100007F1FF2 Y select mcv.category_concat_segs value, mcv.description from mtl_category_sets_vl mcsv, mtl_categories_v mcv where mcsv.category_set_name=:$flex$.category_set and mcsv.structure_id=mcv.structure_id order by mcv.category_concat_segs F Catégorie US Category 17 120 1=1 x.pricing_item_code=:p_item LOV INV Item 8E2FF36EDEF179D2E0530100007F1FF2 Y Y select msiv.concatenated_segments value, msiv.description||' ('||mp.organization_code||')' description from mtl_system_items_vl msiv, mtl_parameters mp where ( :$flex$.organization_code is null and ( fnd_profile.value('MFG_ORGANIZATION_ID') is null and msiv.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) or msiv.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') ) or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y' ) and msiv.organization_id=mp.organization_id order by mp.organization_code, msiv.concatenated_segments F Article US Item 18 130 :p_pricing_qty Number 1 Y F Demande de prix Qté US Pricing Request Qty 19 140 :p_uom_code LOV custom Y select distinct muomv.uom_code value, muomv.unit_of_measure || ' - ' || muomv.description || ' - ' || muomv.uom_class description from mtl_units_of_measure_vl muomv where ( (:$flex$.item is null and :$flex$.category is null) or (:$flex$.item is not null and muomv.uom_code in (select distinct miuv.uom_code from mtl_item_uoms_view miuv, mtl_system_items_kfv msik where miuv.organization_id = msik.organization_id and miuv.inventory_item_id = msik.inventory_item_id and msik.concatenated_segments = substr(replace(:$flex$.item,'<multiple_values>') || ';',1,instr(replace(:$flex$.item,'<multiple_values>') || ';',';') - 1) and msik.organization_id = xxen_qp_preq.get_item_organization_id(:$flex$.organization_code) ) ) or (:$flex$.category is not null and muomv.uom_code in (select distinct miuv.uom_code from mtl_item_uoms_view miuv where (miuv.organization_id,miuv.inventory_item_id)in (select mic.organization_id,mic.inventory_item_id from mtl_category_sets mcs, mtl_item_categories mic, mtl_categories_kfv mck where mic.category_set_id = mcs.category_set_id and mic.category_id = mck.category_id and mic.organization_id = xxen_qp_preq.get_item_organization_id(:$flex$.organization_code) and mcs.category_set_name = :$flex$.category_set and xxen_util.contains(:$flex$.category,mck.concatenated_segments) = 'Y' and rownum < = 1 ) ) ) ) order by muomv.uom_code select msik.primary_uom_code from mtl_system_items_kfv msik where msik.organization_id = xxen_qp_preq.get_item_organization_id and (msik.concatenated_segments = substr(replace(:$flex$.item,'<multiple_values>') || ';',1,instr(replace(:$flex$.item,'<multiple_values>') || ';',';') - 1) or (:$flex$.category is not null and exists (select null from mtl_item_categories mic, mtl_category_sets mcs, mtl_categories_kfv mck where mic.organization_id = msik.organization_id and mic.inventory_item_id = msik.inventory_item_id and mcs.category_set_id = mic.category_set_id and mcs.category_set_name = :$flex$.category_set and mck.category_id = mic.category_id and xxen_util.contains(:$flex$.category,mck.concatenated_segments)='Y' ) ) ) and rownum=1 F Unité de mesure US Unit of Measure 20 150 :p_pricing_request_date Date trunc(sysdate) Y F Date de la demande de tarification US Pricing Request Date 21 160 :p_customer_order_enabled LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y F Articles activés par la commande du client uniquement US Customer Order Enabled Items Only 22 170 :p_cost_type LOV custom Y select cct.cost_type value, cct.description description from cst_cost_types cct, mtl_parameters mp where nvl(cct.organization_id,mp.organization_id)=mp.organization_id and nvl(cct.disable_date,sysdate+1)>sysdate and mp.organization_code = :$flex$.organization_code and ( cct.cost_type_id=mp.primary_cost_method or cct.cost_type_id not in (1,2,5,6) ) order by cost_type select cct.cost_type from cst_cost_types cct, mtl_parameters mp where nvl(cct.organization_id,mp.organization_id)=mp.organization_id and nvl(cct.disable_date,sysdate+1)>sysdate and mp.organization_code = :$flex$.organization_code and cct.cost_type_id=mp.primary_cost_method F Type de coût US Cost Type 23 180 :p_agreement LOV custom Y select name value, null description from so_agreements order by name F Accord de vente US Sales Agreement 24 190 :p_order_source LOV custom Y select name value, description description from so_order_sources where enabled_flag='Y' order by name F Source de la commande US Order Source 25 200 :p_order_type LOV custom Y select name value, description description from oe_order_types_v order by name F Type de commande US Order Type 26 210 :p_use_secondary_price_lists 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 N Y F Utiliser des listes de prix secondaires US Use Secondary Price Lists 27 220 :p_show_price_breaks 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 N Y F Développer les ruptures de prix US Expand Price Breaks 28 230 :p_show_promotional_goods 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 N Y F Présenter des articles promotionnels US Display Promotional Goods 29 240 :p_price_by_customer_site 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 nvl( (select 'Y' from dual where :$flex$.customer_ship_to_location is not null or :$flex$.customer_bill_to_location is not null ),'N') Y F Différences de prix pour les sites d'affichage US Display Site Pricing Differences :$flex$.account_number Account Number Customer Bill To Location :$flex$.account_number Account Number Customer Ship To Location :$flex$.account_number Account Number Organization Code :$flex$.account_number Account Number Price List :$flex$.category Category Unit of Measure :$flex$.category_set Category Set Category :$flex$.category_set Category Set Unit of Measure :$flex$.customer_bill_to_location Customer Bill To Location Display Site Pricing Differences :$flex$.customer_bill_to_location Customer Bill To Location Price List :$flex$.customer_name Customer Name Customer Bill To Location :$flex$.customer_name Customer Name Customer Ship To Location :$flex$.customer_name Customer Name Organization Code :$flex$.customer_name Customer Name Price List :$flex$.customer_ship_to_location Customer Ship To Location Customer Bill To Location :$flex$.customer_ship_to_location Customer Ship To Location Display Site Pricing Differences :$flex$.customer_ship_to_location Customer Ship To Location Organization Code :$flex$.customer_ship_to_location Customer Ship To Location Price List :$flex$.item Item Unit of Measure :$flex$.operating_unit Operating Unit Account Number :$flex$.operating_unit Operating Unit Customer Bill To Location :$flex$.operating_unit Operating Unit Customer Name :$flex$.operating_unit Operating Unit Customer Ship To Location :$flex$.operating_unit Operating Unit Organization Code :$flex$.operating_unit Operating Unit Price List :$flex$.organization_code Organization Code Category Set :$flex$.organization_code Organization Code Cost Type :$flex$.organization_code Organization Code Item :$flex$.organization_code Organization Code Unit of Measure :$flex$.price_list Price List Currency Code :$flex$.pricing_request_date Pricing Request Date Y Price List :$flex$.request_type_code Request Type Code Price List D79E45A5ABCAB24F80C2A2BAB1894F85 Customer Detailed Y All Customer Details. All Pricing Details (use with Detailed Report Level) SYSADMIN 3 ACCOUNT_NUMBER 58 ACCRUAL_AMOUNT 85 ACCRUAL_FLAG 55 ADJUSTED_UNIT_PRICE 54 ADJUSTMENT_AMOUNT 32 APPLIED_PRICE_LIST 89 ATTRIBUTE 88 ATTRIBUTE_CONTEXT 87 ATTRIBUTE_GROUPING_NUM 86 ATTRIBUTE_LEVEL 90 ATTRIBUTE_OPERATOR 93 ATTRIBUTE_PRECEDENCE 91 ATTRIBUTE_VALUE_FROM 92 ATTRIBUTE_VALUE_TO 83 AUTOMATIC_FLAG 78 BASE_CURRENCY 69 BENEFIT 72 BENEFIT_ITEM 70 BENEFIT_METHOD 73 BENEFIT_QTY 71 BENEFIT_VALUE 13 BILL_TO_LOCATION 39 BOM_ITEM_TYPE 41 CATEGORY_SEGMENTS 40 CATEGORY_SET 57 CHARGES_AMOUNT 59 COGS_AMOUNT 77 CURRENCY 8 CUSTOMER_ALLOW_DISCOUNT 4 CUSTOMER_CATEGORY 5 CUSTOMER_CLASS 2 CUSTOMER_NAME 1 CUSTOMER_OR_SITE 9 CUSTOMER_PAYMENT_TERM 10 CUSTOMER_PRICE_LIST 7 CUSTOMER_PROFILE 81 EXCHANGE_RATE 80 EXCHANGE_RATE_TYPE 56 EXTENDED_AMOUNT 43 ITEM_COST_ORGANIZATION 95 LINE_DETAIL_SEQ 94 LINE_NUMBER 49 LINE_QTY_OR_AMT 48 LINE_TYPE 46 LIST_LINE_NUM 45 LIST_NAME 47 LIST_TYPE 62 MARGIN_POST_ACCRUAL 63 MARGIN_POST_ACCRUAL_PCT 60 MARGIN_PRE_ACCRUAL 61 MARGIN_PRE_ACCRUAL_PCT 79 MULTI_CURRENCY_FLAG 74 OPERAND 75 OPERAND_VALUE 11 OPERATING_UNIT 84 OVERRIDE_FLAG 65 PB_ATTRIBUTE 67 PB_FROM 66 PB_OPERATOR 68 PB_TO 64 PB_TYPE 35 PRICED_ITEM 37 PRICED_ITEM_CODE_AND_DESCR 42 PRICED_ITEM_COST 36 PRICED_ITEM_DESCSCRIPTION 38 PRICED_ITEM_PRIMARY_UOM_CODE 50 PRICED_QTY 51 PRICED_UOM 52 PRICE_BREAK_FLAG 76 PRICE_FORMULA 14 PRICE_LIST 17 PRICE_LIST_CURRENCY 15 PRICE_LIST_DESCRIPTION 18 PRICE_LIST_GLOBAL_FLAG 19 PRICE_LIST_OPERATING_UNIT 20 PRICE_LIST_PAYMENT_TERM 16 PRICE_LIST_TYPE 27 PRICING_AGREEMENT_NAME 26 PRICING_CURRENCY_CODE 23 PRICING_DATE 21 PRICING_ITEM_CODE 22 PRICING_ITEM_DESCRIPTION 28 PRICING_ORDER_SOURCE 29 PRICING_ORDER_TYPE 31 PRICING_PAYMENT_TERM 24 PRICING_QTY 25 PRICING_QTY_UOM_CODE 30 PRICING_WAREHOUSE 82 PRODUCT_PRECEDENCE 34 PROMOTIONAL_GOODS_FLAG 44 RECORD_TYPE 6 SALES_CHANNEL 33 SECONDARY_PRICE_LIST_FLAG 12 SHIP_TO_LOCATION 53 UNIT_PRICE S Site 4FED55D2B09B84722E3A815C96C41CC8 Customer Summary Y All Customer Details. Summary Pricing Details (use with Summary Report Level) SYSADMIN 3 ACCOUNT_NUMBER 53 ACCRUAL_AMOUNT 50 ADJUSTED_UNIT_PRICE 49 ADJUSTMENT_AMOUNT 32 APPLIED_PRICE_LIST 13 BILL_TO_LOCATION 39 BOM_ITEM_TYPE 41 CATEGORY_SEGMENTS 40 CATEGORY_SET 52 CHARGES_AMOUNT 54 COGS_AMOUNT 8 CUSTOMER_ALLOW_DISCOUNT 4 CUSTOMER_CATEGORY 5 CUSTOMER_CLASS 2 CUSTOMER_NAME 1 CUSTOMER_OR_SITE 9 CUSTOMER_PAYMENT_TERM 10 CUSTOMER_PRICE_LIST 7 CUSTOMER_PROFILE 51 EXTENDED_AMOUNT 43 ITEM_COST_ORGANIZATION 60 LINE_DETAIL_SEQ 59 LINE_NUMBER 57 MARGIN_POST_ACCRUAL 58 MARGIN_POST_ACCRUAL_PCT 55 MARGIN_PRE_ACCRUAL 56 MARGIN_PRE_ACCRUAL_PCT 11 OPERATING_UNIT 35 PRICED_ITEM 37 PRICED_ITEM_CODE_AND_DESCR 42 PRICED_ITEM_COST 36 PRICED_ITEM_DESCSCRIPTION 38 PRICED_ITEM_PRIMARY_UOM_CODE 45 PRICED_QTY 46 PRICED_UOM 47 PRICE_BREAK_FLAG 14 PRICE_LIST 17 PRICE_LIST_CURRENCY 15 PRICE_LIST_DESCRIPTION 18 PRICE_LIST_GLOBAL_FLAG 19 PRICE_LIST_OPERATING_UNIT 20 PRICE_LIST_PAYMENT_TERM 16 PRICE_LIST_TYPE 27 PRICING_AGREEMENT_NAME 26 PRICING_CURRENCY_CODE 23 PRICING_DATE 21 PRICING_ITEM_CODE 22 PRICING_ITEM_DESCRIPTION 28 PRICING_ORDER_SOURCE 29 PRICING_ORDER_TYPE 31 PRICING_PAYMENT_TERM 24 PRICING_QTY 25 PRICING_QTY_UOM_CODE 30 PRICING_WAREHOUSE 34 PROMOTIONAL_GOODS_FLAG 44 RECORD_TYPE 6 SALES_CHANNEL 33 SECONDARY_PRICE_LIST_FLAG 12 SHIP_TO_LOCATION 48 UNIT_PRICE S Site 764986B8952A531056C18053F628E632 Customer and Site Detailed Y All Customer, Customer Site Details. All Pricing Details (use with Detailed Report Level) SYSADMIN 3 ACCOUNT_NUMBER 70 ACCRUAL_AMOUNT 97 ACCRUAL_FLAG 67 ADJUSTED_UNIT_PRICE 66 ADJUSTMENT_AMOUNT 44 APPLIED_PRICE_LIST 101 ATTRIBUTE 100 ATTRIBUTE_CONTEXT 99 ATTRIBUTE_GROUPING_NUM 98 ATTRIBUTE_LEVEL 102 ATTRIBUTE_OPERATOR 105 ATTRIBUTE_PRECEDENCE 103 ATTRIBUTE_VALUE_FROM 104 ATTRIBUTE_VALUE_TO 95 AUTOMATIC_FLAG 90 BASE_CURRENCY 81 BENEFIT 84 BENEFIT_ITEM 82 BENEFIT_METHOD 85 BENEFIT_QTY 83 BENEFIT_VALUE 19 BILL_TO_LOCATION 23 BILL_TO_ORDER_TYPE 24 BILL_TO_PAYMENT_TERM 25 BILL_TO_PRICE_LIST 20 BILL_TO_PRIMARY_FLAG 21 BILL_TO_PROFILE 22 BILL_TO_SHIP_FROM_WAREHOUSE 51 BOM_ITEM_TYPE 53 CATEGORY_SEGMENTS 52 CATEGORY_SET 69 CHARGES_AMOUNT 71 COGS_AMOUNT 89 CURRENCY 8 CUSTOMER_ALLOW_DISCOUNT 4 CUSTOMER_CATEGORY 5 CUSTOMER_CLASS 2 CUSTOMER_NAME 1 CUSTOMER_OR_SITE 9 CUSTOMER_PAYMENT_TERM 10 CUSTOMER_PRICE_LIST 7 CUSTOMER_PROFILE 93 EXCHANGE_RATE 92 EXCHANGE_RATE_TYPE 68 EXTENDED_AMOUNT 55 ITEM_COST_ORGANIZATION 107 LINE_DETAIL_SEQ 106 LINE_NUMBER 61 LINE_QTY_OR_AMT 60 LINE_TYPE 58 LIST_LINE_NUM 57 LIST_NAME 59 LIST_TYPE 74 MARGIN_POST_ACCRUAL 75 MARGIN_POST_ACCRUAL_PCT 72 MARGIN_PRE_ACCRUAL 73 MARGIN_PRE_ACCRUAL_PCT 91 MULTI_CURRENCY_FLAG 86 OPERAND 87 OPERAND_VALUE 11 OPERATING_UNIT 96 OVERRIDE_FLAG 77 PB_ATTRIBUTE 79 PB_FROM 78 PB_OPERATOR 80 PB_TO 76 PB_TYPE 47 PRICED_ITEM 49 PRICED_ITEM_CODE_AND_DESCR 54 PRICED_ITEM_COST 48 PRICED_ITEM_DESCSCRIPTION 50 PRICED_ITEM_PRIMARY_UOM_CODE 62 PRICED_QTY 63 PRICED_UOM 64 PRICE_BREAK_FLAG 88 PRICE_FORMULA 26 PRICE_LIST 29 PRICE_LIST_CURRENCY 27 PRICE_LIST_DESCRIPTION 30 PRICE_LIST_GLOBAL_FLAG 31 PRICE_LIST_OPERATING_UNIT 32 PRICE_LIST_PAYMENT_TERM 28 PRICE_LIST_TYPE 39 PRICING_AGREEMENT_NAME 38 PRICING_CURRENCY_CODE 35 PRICING_DATE 33 PRICING_ITEM_CODE 34 PRICING_ITEM_DESCRIPTION 40 PRICING_ORDER_SOURCE 41 PRICING_ORDER_TYPE 43 PRICING_PAYMENT_TERM 36 PRICING_QTY 37 PRICING_QTY_UOM_CODE 42 PRICING_WAREHOUSE 94 PRODUCT_PRECEDENCE 46 PROMOTIONAL_GOODS_FLAG 56 RECORD_TYPE 6 SALES_CHANNEL 45 SECONDARY_PRICE_LIST_FLAG 12 SHIP_TO_LOCATION 16 SHIP_TO_ORDER_TYPE 17 SHIP_TO_PAYMENT_TERM 18 SHIP_TO_PRICE_LIST 13 SHIP_TO_PRIMARY_FLAG 14 SHIP_TO_PROFILE 15 SHIP_TO_SHIP_FROM_WAREHOUSE 65 UNIT_PRICE S Site 0F15D9ECFB13ED0ACA2A3CD97F560A2E Customer and Site Summary Y All Customer, Customer Site Details. Summary Pricing Details (use with Summary Report Level) SYSADMIN 3 ACCOUNT_NUMBER 65 ACCRUAL_AMOUNT 62 ADJUSTED_UNIT_PRICE 61 ADJUSTMENT_AMOUNT 44 APPLIED_PRICE_LIST 19 BILL_TO_LOCATION 23 BILL_TO_ORDER_TYPE 24 BILL_TO_PAYMENT_TERM 25 BILL_TO_PRICE_LIST 20 BILL_TO_PRIMARY_FLAG 21 BILL_TO_PROFILE 22 BILL_TO_SHIP_FROM_WAREHOUSE 51 BOM_ITEM_TYPE 53 CATEGORY_SEGMENTS 52 CATEGORY_SET 64 CHARGES_AMOUNT 66 COGS_AMOUNT 8 CUSTOMER_ALLOW_DISCOUNT 4 CUSTOMER_CATEGORY 5 CUSTOMER_CLASS 2 CUSTOMER_NAME 1 CUSTOMER_OR_SITE 9 CUSTOMER_PAYMENT_TERM 10 CUSTOMER_PRICE_LIST 7 CUSTOMER_PROFILE 63 EXTENDED_AMOUNT 55 ITEM_COST_ORGANIZATION 72 LINE_DETAIL_SEQ 71 LINE_NUMBER 69 MARGIN_POST_ACCRUAL 70 MARGIN_POST_ACCRUAL_PCT 67 MARGIN_PRE_ACCRUAL 68 MARGIN_PRE_ACCRUAL_PCT 11 OPERATING_UNIT 47 PRICED_ITEM 49 PRICED_ITEM_CODE_AND_DESCR 54 PRICED_ITEM_COST 48 PRICED_ITEM_DESCSCRIPTION 50 PRICED_ITEM_PRIMARY_UOM_CODE 57 PRICED_QTY 58 PRICED_UOM 59 PRICE_BREAK_FLAG 26 PRICE_LIST 29 PRICE_LIST_CURRENCY 27 PRICE_LIST_DESCRIPTION 30 PRICE_LIST_GLOBAL_FLAG 31 PRICE_LIST_OPERATING_UNIT 32 PRICE_LIST_PAYMENT_TERM 28 PRICE_LIST_TYPE 39 PRICING_AGREEMENT_NAME 38 PRICING_CURRENCY_CODE 35 PRICING_DATE 33 PRICING_ITEM_CODE 34 PRICING_ITEM_DESCRIPTION 40 PRICING_ORDER_SOURCE 41 PRICING_ORDER_TYPE 43 PRICING_PAYMENT_TERM 36 PRICING_QTY 37 PRICING_QTY_UOM_CODE 42 PRICING_WAREHOUSE 46 PROMOTIONAL_GOODS_FLAG 56 RECORD_TYPE 6 SALES_CHANNEL 45 SECONDARY_PRICE_LIST_FLAG 12 SHIP_TO_LOCATION 16 SHIP_TO_ORDER_TYPE 17 SHIP_TO_PAYMENT_TERM 18 SHIP_TO_PRICE_LIST 13 SHIP_TO_PRIMARY_FLAG 14 SHIP_TO_PROFILE 15 SHIP_TO_SHIP_FROM_WAREHOUSE 60 UNIT_PRICE S Site 43AB020D4744C23D9003CBA69A8C803A Margin Analysis Summary Y SYSADMIN 3 ACCOUNT_NUMBER 47 ACCRUAL_AMOUNT 44 ADJUSTED_UNIT_PRICE 43 ADJUSTMENT_AMOUNT 27 APPLIED_PRICE_LIST 9 BILL_TO_LOCATION 33 BOM_ITEM_TYPE 35 CATEGORY_SEGMENTS 34 CATEGORY_SET 46 CHARGES_AMOUNT 48 COGS_AMOUNT 4 CUSTOMER_CATEGORY 5 CUSTOMER_CLASS 2 CUSTOMER_NAME 1 CUSTOMER_OR_SITE 45 EXTENDED_AMOUNT 37 ITEM_COST_ORGANIZATION 51 MARGIN_POST_ACCRUAL 52 MARGIN_POST_ACCRUAL_PCT 49 MARGIN_PRE_ACCRUAL 50 MARGIN_PRE_ACCRUAL_PCT 7 OPERATING_UNIT 30 PRICED_ITEM 36 PRICED_ITEM_COST 31 PRICED_ITEM_DESCSCRIPTION 32 PRICED_ITEM_PRIMARY_UOM_CODE 39 PRICED_QTY 40 PRICED_UOM 41 PRICE_BREAK_FLAG 10 PRICE_LIST 13 PRICE_LIST_CURRENCY 11 PRICE_LIST_DESCRIPTION 14 PRICE_LIST_GLOBAL_FLAG 15 PRICE_LIST_OPERATING_UNIT 12 PRICE_LIST_TYPE 22 PRICING_AGREEMENT_NAME 21 PRICING_CURRENCY_CODE 18 PRICING_DATE 16 PRICING_ITEM_CODE 17 PRICING_ITEM_DESCRIPTION 23 PRICING_ORDER_SOURCE 24 PRICING_ORDER_TYPE 26 PRICING_PAYMENT_TERM 19 PRICING_QTY 20 PRICING_QTY_UOM_CODE 25 PRICING_WAREHOUSE 29 PROMOTIONAL_GOODS_FLAG 38 RECORD_TYPE 6 SALES_CHANNEL 28 SECONDARY_PRICE_LIST_FLAG 8 SHIP_TO_LOCATION 42 UNIT_PRICE S Site 5B370363E20F64311EA1B121F574E76C Pivot - Margin Analysis across Price Lists Summary Y SYSADMIN 4 ACCOUNT_NUMBER 45 ACCRUAL_AMOUNT 42 ADJUSTED_UNIT_PRICE 41 ADJUSTMENT_AMOUNT 24 APPLIED_PRICE_LIST 10 BILL_TO_LOCATION 31 BOM_ITEM_TYPE 33 CATEGORY_SEGMENTS 32 CATEGORY_SET 44 CHARGES_AMOUNT 46 COGS_AMOUNT 2 CUSTOMER_AND_SITE_ORG_DESC 5 CUSTOMER_CATEGORY 6 CUSTOMER_CLASS 3 CUSTOMER_NAME 1 CUSTOMER_OR_SITE 43 EXTENDED_AMOUNT 35 ITEM_COST_ORGANIZATION 52 LINE_DETAIL_SEQ 51 LINE_NUMBER 49 MARGIN_POST_ACCRUAL 50 MARGIN_POST_ACCRUAL_PCT 47 MARGIN_PRE_ACCRUAL 48 MARGIN_PRE_ACCRUAL_PCT 8 OPERATING_UNIT 28 PRICED_ITEM 27 PRICED_ITEM_CODE_AND_DESCR 34 PRICED_ITEM_COST 29 PRICED_ITEM_DESCSCRIPTION 30 PRICED_ITEM_PRIMARY_UOM_CODE 37 PRICED_QTY 38 PRICED_UOM 39 PRICE_BREAK_FLAG 11 PRICE_LIST 14 PRICE_LIST_CURRENCY 12 PRICE_LIST_DESCRIPTION 15 PRICE_LIST_GLOBAL_FLAG 16 PRICE_LIST_OPERATING_UNIT 17 PRICE_LIST_PAYMENT_TERM 13 PRICE_LIST_TYPE 23 PRICING_CURRENCY_CODE 20 PRICING_DATE 18 PRICING_ITEM_CODE 19 PRICING_ITEM_DESCRIPTION 21 PRICING_QTY 22 PRICING_QTY_UOM_CODE 26 PROMOTIONAL_GOODS_FLAG 36 RECORD_TYPE 7 SALES_CHANNEL 25 SECONDARY_PRICE_LIST_FLAG 9 SHIP_TO_LOCATION 40 UNIT_PRICE ACCOUNT_NUMBER FILTER 1 ACCRUAL_AMOUNT VALUE 3 SUM BILL_TO_LOCATION FILTER 4 CATEGORY_SEGMENTS FILTER 6 COGS_AMOUNT VALUE 1 SUM CUSTOMER_AND_SITE_ORG_DESC ROW 1 CUSTOMER_NAME FILTER 2 EXTENDED_AMOUNT VALUE 2 SUM MARGIN_POST_ACCRUAL VALUE 5 SUM MARGIN_POST_ACCRUAL_PCT VALUE 7 SUM MARGIN_PRE_ACCRUAL VALUE 4 SUM MARGIN_PRE_ACCRUAL_PCT VALUE 6 SUM OPERATING_UNIT FILTER 5 PRICED_ITEM_CODE_AND_DESCR ROW 2 PRICE_LIST COLUMN 1 PRICING_ITEM_CODE FILTER 7 SHIP_TO_LOCATION FILTER 3 S Site B88577B52444DB16D2BBB8CF41EE1D9B Pivot - Unit Price and Adjusted Unit Price across Price Lists Summary Y SYSADMIN 4 ACCOUNT_NUMBER 45 ACCRUAL_AMOUNT 42 ADJUSTED_UNIT_PRICE 41 ADJUSTMENT_AMOUNT 24 APPLIED_PRICE_LIST 10 BILL_TO_LOCATION 31 BOM_ITEM_TYPE 33 CATEGORY_SEGMENTS 32 CATEGORY_SET 44 CHARGES_AMOUNT 46 COGS_AMOUNT 2 CUSTOMER_AND_SITE_ORG_DESC 5 CUSTOMER_CATEGORY 6 CUSTOMER_CLASS 3 CUSTOMER_NAME 1 CUSTOMER_OR_SITE 43 EXTENDED_AMOUNT 35 ITEM_COST_ORGANIZATION 52 LINE_DETAIL_SEQ 51 LINE_NUMBER 49 MARGIN_POST_ACCRUAL 50 MARGIN_POST_ACCRUAL_PCT 47 MARGIN_PRE_ACCRUAL 48 MARGIN_PRE_ACCRUAL_PCT 8 OPERATING_UNIT 28 PRICED_ITEM 27 PRICED_ITEM_CODE_AND_DESCR 34 PRICED_ITEM_COST 29 PRICED_ITEM_DESCSCRIPTION 30 PRICED_ITEM_PRIMARY_UOM_CODE 37 PRICED_QTY 38 PRICED_UOM 39 PRICE_BREAK_FLAG 11 PRICE_LIST 14 PRICE_LIST_CURRENCY 12 PRICE_LIST_DESCRIPTION 15 PRICE_LIST_GLOBAL_FLAG 16 PRICE_LIST_OPERATING_UNIT 17 PRICE_LIST_PAYMENT_TERM 13 PRICE_LIST_TYPE 23 PRICING_CURRENCY_CODE 20 PRICING_DATE 18 PRICING_ITEM_CODE 19 PRICING_ITEM_DESCRIPTION 21 PRICING_QTY 22 PRICING_QTY_UOM_CODE 26 PROMOTIONAL_GOODS_FLAG 36 RECORD_TYPE 7 SALES_CHANNEL 25 SECONDARY_PRICE_LIST_FLAG 9 SHIP_TO_LOCATION 40 UNIT_PRICE ACCOUNT_NUMBER FILTER 1 ADJUSTED_UNIT_PRICE VALUE 2 MAX BILL_TO_LOCATION FILTER 4 CATEGORY_SEGMENTS FILTER 6 CUSTOMER_AND_SITE_ORG_DESC ROW 1 CUSTOMER_NAME FILTER 2 OPERATING_UNIT FILTER 5 PRICED_ITEM_CODE_AND_DESCR ROW 2 PRICE_LIST COLUMN 1 PRICING_ITEM_CODE FILTER 7 SHIP_TO_LOCATION FILTER 3 UNIT_PRICE VALUE 1 MAX S Site SYSADMIN 5B370363E20F64311EA1B121F574E76C ENGINATICS 0F15D9ECFB13ED0ACA2A3CD97F560A2E