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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US CBFFE64F67EA19B5E0530100007F700F select :p_ledger ledger, :p_operating_unit operating_unit, :p_period_name period, q.po_header_status, q.po_line_status, q.po_number, q.po_release_number, q.line_num, q.line_type, q.item_name, q.user_item_type, q.category, q.item_description, q.vendor_name, q.vendor_site_code, case when q.line_qty_accrued > 0 then round(q.line_accrual_amt / q.line_qty_accrued,q.po_precision) when q.line_qty_accrued = 0 then round(q.po_unit_price,q.po_precision) end line_po_unit_price, case when q.line_qty_accrued > 0 then round(q.line_func_accrual_amt / q.line_qty_accrued,q.po_func_precision) when q.line_qty_accrued = 0 then round(q.func_unit_price,q.po_func_precision) end line_functional_unit_price, q.line_bill_of_lading, -- shipment q.shipment_num, case when q.ship_qty_accrued > 0 then round(q.ship_accrual_amt / q.ship_qty_accrued,q.po_precision) when q.ship_qty_accrued = 0 then round(q.po_unit_price,q.po_precision) end ship_po_unit_price, case when q.ship_qty_accrued > 0 then round(q.ship_func_accrual_amt / q.ship_qty_accrued,q.po_func_precision) when q.ship_qty_accrued = 0 then round(q.func_unit_price,q.po_func_precision) end ship_functional_unit_price, q.bill_of_lading, q.receipt_num, q.receipt_date, -- distribution q.distribution_num, q.uom_code, q.receiving_org, q.quantity_ordered, q.quantity_received, q.quantity_billed, q.quantity_accrued, q.po_currency_code, q.po_unit_price dist_po_unit_price, q.accrual_amount accrual_amount, q.accrual_currency_code, q.func_unit_price dist_functional_unit_price, q.func_accrual_amount functional_accrual_amount, q.age_in_days, q.charge_account, q.accrual_account, q.item_expense_account, q.po_creation_date, q.po_last_updated_by, &dff_columns2 -- q.pivot_sort_value, q.po_num_po_release_num "PO (Release) Number" from ( select x.*, decode(:p_orderby, 'Category', x.category, 'Vendor', x.vendor_name,x.po_num_po_release_num) pivot_sort_value, dense_rank() over (partition by x.po_line_id order by x.shipment_num) line_rank, sum(x.quantity_accrued) over (partition by x.po_line_id) line_qty_accrued, sum(x.accrual_amount) over (partition by x.po_line_id) line_accrual_amt, sum(x.func_accrual_amount) over (partition by x.po_line_id) line_func_accrual_amt, dense_rank() over (partition by x.po_shipment_id order by x.distribution_num) ship_rank, sum(x.quantity_accrued) over (partition by x.po_shipment_id) ship_qty_accrued, sum(x.accrual_amount) over (partition by x.po_shipment_id) ship_accrual_amt, sum(x.func_accrual_amount) over (partition by x.po_shipment_id) ship_func_accrual_amt, listagg(x.bill_of_lading,',') within group (order by x.bill_of_lading) over (partition by x.po_header_id,x.po_line_id,x.po_release_number) line_bill_of_lading from ( select nvl( pha.clm_document_number, pha.segment1) po_number, pra.release_num po_release_number, nvl( pha.clm_document_number, pha.segment1) || nvl2(pra.release_num,' (' || lpad(pra.release_num,6,' ') || ')',null) po_num_po_release_num, pha.po_header_id po_header_id, pla.po_line_id po_line_id, cpeat.shipment_id po_shipment_id, cpeat.distribution_id po_distribution_id, plt.line_type line_type, nvl( pla.line_num_display, to_char(pla.line_num)) line_num, msibk.concatenated_segments item_name, xxen_util.meaning(msibk.item_type,'ITEM_TYPE',3) user_item_type, mck.concatenated_segments category, pla.item_description item_description, pv.vendor_name vendor_name, xxen_util.meaning(nvl(pha.closed_code,'OPEN'),'DOCUMENT STATE',201) po_header_status, xxen_util.meaning(nvl(pla.closed_code,'OPEN'),'DOCUMENT STATE',201) po_line_status, fc2.currency_code accrual_currency_code, plla.shipment_num shipment_num, plla.unit_meas_lookup_code uom_code, pda.distribution_num distribution_num, round( nvl(cpeat.quantity_received, 0), :p_qty_precision) quantity_received, round( nvl(cpeat.quantity_billed, 0), :p_qty_precision) quantity_billed, round( nvl(cpeat.accrual_quantity, 0), :p_qty_precision) quantity_accrued, round( cpeat.unit_price, nvl(fc2.extended_precision, 2)) po_unit_price, cpeat.currency_code po_currency_code, round( decode( nvl(fc1.minimum_accountable_unit, 0), 0, cpeat.unit_price * cpeat.currency_conversion_rate, (cpeat.unit_price / fc1.minimum_accountable_unit) * cpeat.currency_conversion_rate * fc1.minimum_accountable_unit ), nvl(fc1.extended_precision, 2)) func_unit_price, gcck1.concatenated_segments charge_account, gcck2.concatenated_segments accrual_account, gcck3.concatenated_segments item_expense_account, xxen_util.client_time(pha.creation_date) po_creation_date, (select pvsa.vendor_site_code from po_vendor_sites_all pvsa where pvsa.vendor_site_id=pha.vendor_site_id) vendor_site_code, (select mp.organization_code from mtl_parameters mp where mp.organization_id=plla.ship_to_organization_id) receiving_org, round(plla.quantity,:p_qty_precision) quantity_ordered, xxen_util.user_name(pha.last_updated_by,'Y') po_last_updated_by, &dff_columns cpeat.accrual_amount accrual_amount, round( decode( nvl(fc1.minimum_accountable_unit, 0), 0, cpeat.accrual_amount * cpeat.currency_conversion_rate, (cpeat.accrual_amount / fc1.minimum_accountable_unit) * cpeat.currency_conversion_rate * fc1.minimum_accountable_unit), nvl(fc2.precision, 2)) func_accrual_amount, nvl(fc2.extended_precision,2) po_precision, nvl(fc1.extended_precision,2) po_func_precision, nvl(fc2.precision,2) accr_precision, ( select trunc(sysdate - max(rt.transaction_date)) from rcv_transactions rt where rt.po_line_location_id = cpeat.shipment_id and rt.transaction_type IN ('RECEIVE','MATCH') and rt.transaction_date <= :p_end_date ) age_in_days, ( select trunc(max(rt.transaction_date)) from rcv_transactions rt where rt.po_line_location_id = cpeat.shipment_id and rt.transaction_type IN ('RECEIVE','MATCH') and rt.transaction_date <= :p_end_date ) receipt_date, ( select listagg(rsh.bill_of_lading,',') within group (order by rsh.bill_of_lading) from ( select distinct rt.po_line_location_id, rsh.bill_of_lading from rcv_transactions rt, rcv_shipment_headers rsh where rsh.shipment_header_id = rt.shipment_header_id and rt.transaction_type IN ('RECEIVE','MATCH') and rt.transaction_date <= :p_end_date and rsh.bill_of_lading is not null ) rsh where rsh.po_line_location_id = plla.line_location_id ) bill_of_lading, ( select listagg(rsh.receipt_num,',') within group (order by rsh.shipment_header_id) from ( select distinct rt.po_line_location_id, rsh.receipt_num, rsh.shipment_header_id from rcv_transactions rt, rcv_shipment_headers rsh where rsh.shipment_header_id = rt.shipment_header_id and rt.transaction_type IN ('RECEIVE','MATCH') and rt.transaction_date <= :p_end_date and rsh.receipt_num is not null ) rsh where rsh.po_line_location_id = plla.line_location_id ) receipt_num from cst_per_end_accruals_temp cpeat, po_headers_all pha, po_lines_all pla, po_line_locations_all plla, po_distributions_all pda, po_vendors pv, po_line_types plt, po_releases_all pra, mtl_system_items_b_kfv msibk, gl_sets_of_books gsob, fnd_currencies fc1, fnd_currencies fc2, mtl_categories_kfv mck, gl_code_combinations_kfv gcck1, gl_code_combinations_kfv gcck2, gl_code_combinations_kfv gcck3 where cpeat.distribution_id=pda.po_distribution_id and pha.po_header_id=pla.po_header_id and pla.po_line_id=plla.po_line_id and plla.line_location_id=pda.line_location_id and pha.vendor_id=pv.vendor_id and pla.line_type_id=plt.line_type_id and plla.po_release_id=pra.po_release_id(+) and pla.item_id=msibk.inventory_item_id(+) and (msibk.organization_id is null or msibk.organization_id=plla.ship_to_organization_id) and gsob.set_of_books_id=:p_ledger_id and cpeat.currency_code=fc1.currency_code and gsob.currency_code=fc2.currency_code and cpeat.category_id=mck.category_id(+) and pda.code_combination_id=gcck1.code_combination_id and pda.accrual_account_id=gcck2.code_combination_id and msibk.expense_account=gcck3.code_combination_id(+) ) x ) q order by decode(:p_orderby, 'Category' , q.category, 'Vendor' , q.vendor_name,null), q.po_number, q.po_release_number, q.line_num, q.shipment_num, q.distribution_num Added PO Creation Date, Vendor Site Code, Receiving Org, Quantity Ordered, PO Last Updated By columns Y #,##0.00;[Red]-#,##0.00 XXEN_CST AR CST تقرير إيصالات لم يتم تحرير فواتير بها Imported from Concurrent Program Application: شجرة المنتجات Source: تقرير إيصالات لم يتم تحرير فواتير بها Short Name: CSTACREP DB package: D CST Wareneingang - nicht fakturiert Imported from Concurrent Program Description: Auswertung "Wareneingang - nicht fakturiert" Application: Produktionsdaten Source: Wareneingang - nicht fakturiert Short Name: CSTACREP DB package: F CST Etat des réceptions non facturées Imported from Concurrent Program Application: Bills of Material Source: Etat des réceptions non facturées Short Name: CSTACREP DB package: I CST Rapporto Ricezioni non fatturate Imported from Concurrent Program Application: Bills of Material Source: Rapporto Ricezioni non fatturate Short Name: CSTACREP DB package: US CST Uninvoiced Receipts Application: Bills of Material Description: Uninvoiced Receipts Report Templates: Select a template to show Accruals summarized by - PO/Release Distributions (Default) - PO/Release Shipments - PO/Release Lines Each template includes a Pivot summarizing the accruals by Accrual Account and the Pivot/Sort Parameter Value (Vendor, Category, PO/Release Number) Source: Uninvoiced Receipts Report Short Name: CSTACREP DB Package: XXEN_CST ZHS CST 未开票接收报表 Imported from Concurrent Program Application: 物料清单管理系统 Source: 未开票接收报表 Short Name: CSTACREP DB package: Enginatics R12 only &dff_columns &dff_columns2 :p_accrued_receipts :p_alt_bom_desg :p_alt_rtg_desg :p_assignment_set_id :p_buy_cost_type_id :p_category_from :p_category_set :p_category_set_id :p_category_set_id_out :p_category_structure_id :p_category_to :p_conc_request_id :p_conversion_type :p_cost_type_id :p_cost_type_name :p_default_cost_type_id :p_default_org_id :p_description :p_end_date :p_eng_bill_flag :p_explosion_level :p_inc_closed_pos :p_inc_online_accruals :p_inc_unimp_ecn_flag :p_item :p_item_from :p_item_id :p_item_to :p_ledger :p_ledger_id :p_lock_flag :p_material_dtl_flag :p_material_overhead_dtl_flag :p_min_accrual_amount :p_operating_unit :p_operating_unit_id :p_orderby :p_organization_id :p_period_name :p_phantom_mat :p_qty_precision :p_range_type :p_report_code :p_report_level :p_report_level_out :p_report_option_type :p_report_type_type :p_revision_date :p_rollup_id :p_rollup_option_type :p_routing_dtl_flag :p_trace :p_vendor_from :p_vendor_to 1 -30 :p_report_code Char CSTACREP F Code du rapport US Report Code 2 -20 :p_category_set 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 category_set_name from mtl_default_sets_view where functional_area_id = 2 Y AR هيكل الفئة هيكل الفئة D Kategoriestruktur Kategoriestruktur F Ensemble de la catégorie Structure de catégorie I Struttura categoria Struttura categoria US Category Set Category Structure ZHS 类别结构 类别结构 3 -10 :p_end_date Date select inv_le_timezone_pub.get_server_day_time_for_le(gps.end_date, to_number(hoi.org_information2)) from hr_operating_units hou, hr_organization_information hoi, gl_ledgers gl, gl_period_statuses gps where hou.name = :$flex$.Operating_Unit and hoi.organization_id = hou.organization_id and hoi.org_information_context = 'Operating Unit Information' and gl.ledger_id = hou.set_of_books_id and gps.application_id = 101 and gps.set_of_books_id = gl.ledger_id and gps.period_name = nvl( :$flex$.period_name , (select gp.period_name from gl_periods gp where gp.period_set_name = gl.period_set_name and gp.period_type = gl.accounted_period_type and gp.adjustment_period_flag = 'N' and gp.start_date <= trunc(sysdate) and gp.end_date >= trunc(sysdate) ) ) F Date de fin de période US Period End Date 4 10 :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)) Y F Unité d'exploitation Unité opérationnelle US Operating Unit Operating Unit 5 20 :p_accrued_receipts 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 AR إيصالات مستحقة إيصالات مستحقة D WE mit Rückstellungen WE mit Rückstellungen F Recettes à recevoir Provisions pour réceptions I Ricezioni accantonate Ricezioni accantonate US Accrued Receipts Accrued Receipts ZHS 应计接收 应计接收 6 30 :p_inc_online_accruals 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 AR تضمين استحقاقات مباشرة تضمين استحقاقات مباشرة D Mit Online-Rückstellungen Mit Online-Rückstellungen F Inclure les régularisations en ligne Inclure les provisions en ligne I Includi accantonamenti in linea Include gli accantonamenti in linea US Include Online Accruals Include Online Accruals ZHS 包括联机应计 包括联机应计 7 40 :p_inc_closed_pos 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 AR تضمين مشتريات مقفلة تضمين مشتريات مقفلة D Mit geschlossenen Bestellungen Mit geschlossenen Bestellungen F Inclure les commandes clôturées Inclure les ordres d'achat fermés I Includi OA chiusi Include gli OA chiusi US Include Closed POs Include Closed POs ZHS 包括关闭 PO 包括关闭 PO 8 50 :p_category_from 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 AR الفئات من الفئات من D Von Kategorie Von Kategorie F Catégories de Catégories - De I Categorie - Da Categorie - Da US Categories From Categories From ZHS 类别自 类别自 9 60 :p_category_to 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 AR إلى الفئات إلى D Bis Bis Kategorie F Catégories à Catégories - A I A Categorie - A US Categories To Categories To ZHS 至 类别至 10 70 :p_min_accrual_amount Number AR الحد الأدنى لمبلغ الاستحقاق الحد الأدنى لمبلغ الاستحقاق D Minimaler Rückstellungsbetrag Minimaler Rückstellungsbetrag F Montant minimum d'accumulation Montant de provision minimum I Importo minimo accantonamento Importo minimo dell'accantonamento US Minimum Accrual Amount Minimum Accrual Amount ZHS 最小应计额 最小应计额 11 80 :p_period_name LOV custom Y select gps.period_name id, gps.period_name value, null description from hr_all_organization_units_vl haouv, financials_system_params_all fspa, gl_period_statuses gps where haouv.name = :$flex$.Operating_Unit and fspa.org_id = haouv.organization_id and gps.application_id=101 and gps.set_of_books_id=fspa.set_of_books_id order by gps.start_date select gp.period_name from financials_system_parameters fsp, gl_ledgers gl, gl_periods gp where gl.ledger_id = fsp.set_of_books_id and gp.period_set_name=gl.period_set_name and gp.period_type=gl.accounted_period_type and gp.adjustment_period_flag = 'N' and gp.start_date <= trunc(sysdate) and gp.end_date >= trunc(sysdate) Y AR اسم الفترة اسم الفترة D Periodenbezeichnung Periodenbezeichnung F Nom de la période Nom de la période I Nome del periodo Nome del periodo US Period Name Period Name ZHS 期间名称 期间名称 12 90 :p_vendor_from LOV Oracle CST_SRS_VENDORS Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR الموردون من الموردون من D Von Lieferant Von Lieferant F Vendeurs de Fournisseurs - De I Fornitori - Da Fornitori - Da US Vendors From Vendors From ZHS 供应商自 供应商自 13 100 :p_vendor_to LOV Oracle CST_SRS_VENDORS Y select vendor_name id, vendor_name value, null description from po_vendors order by vendor_name AR إلى 2 موردون إلى D Bis 2 Bis Lieferant F Vendeurs à Fournisseurs - A I A 2 Fornitori - A US Vendors To Vendors To ZHS 至 2 供应商至 14 110 :p_orderby LOV custom Y select x.value, x.description from (select 'Vendor' value, null description from dual union select 'Category' value, null description from dual union select 'PO Number / PO Release Number' value, null description from dual ) x order by x.value Vendor Y AR فرز بواسطة فرز بواسطة D Sortieren nach Sortieren nach F Trier/Pivoter par Tri par I Ordina per Ordina per US Sort/Pivot By Sort By ZHS 排序依据 排序依据 15 120 :p_qty_precision LOV Oracle INV_SRS_PRECISION Y select lookup_code id, lookup_code value, meaning description from mfg_lookups where lookup_type='INV_SRS_PRECISION' and enabled_flag='Y' order by lookup_code fnd_profile.value('REPORT_QUANTITY_PRECISION') Y AR خيار الدقة الديناميكية دقة الكمية D Option Nachkommastellen Nachkommastellen F Option de précision dynamique Précision des quantités I Opzione precisione dinamica Precisione quantità US Dynamic Precision Option Quantity Precision ZHS 动态精确度选项 数量精确度 16 130 &dff_columns2 select xxen_util.dff_columns(p_table_name=>'po_distributions_all',p_column_name_prefix=>'PO Dist: ',p_prefix=>'q.') from dual LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Show DFF Attributes 17 &dff_columns select xxen_util.dff_columns(p_table_name=>'po_distributions_all',p_column_name_prefix=>'PO Dist: ') from dual US Show DFF Attributes :$flex$.Operating_Unit Operating Unit Period End Date :$flex$.Operating_Unit Operating Unit Period Name :$flex$.category_set Category Set Categories From :$flex$.category_set Category Set Categories To :$flex$.period_name Period Name Period End Date Accruals by PO/Release Distributions Accrual Detail Report by PO/Release Distributions. Includes a summary Pivot on the selected Pivot/Sort Parameter Value. SYSADMIN 32 ACCRUAL_ACCOUNT 22 ACCRUAL_AMOUNT 23 ACCRUAL_CURRENCY_CODE 26 AGE_IN_DAYS 27 BILL_OF_LADING 11 CATEGORY 31 CHARGE_ACCOUNT 15 DISTRIBUTION_NUM 6 24 DIST_FUNCTIONAL_UNIT_PRICE 21 DIST_PO_UNIT_PRICE 25 FUNCTIONAL_ACCRUAL_AMOUNT 12 ITEM_DESCRIPTION 30 ITEM_EXPENSE_ACCOUNT 10 ITEM_NAME 1 LEDGER 8 LINE_NUM 4 9 LINE_TYPE 2 OPERATING_UNIT 3 PERIOD 33 PIVOT_SORT_VALUE 1 20 PO_CURRENCY_CODE 4 PO_HEADER_STATUS 5 PO_LINE_STATUS 6 PO_NUMBER 2 7 PO_RELEASE_NUMBER 3 19 QUANTITY_ACCRUED 18 QUANTITY_BILLED 17 QUANTITY_RECEIVED 29 RECEIPT_DATE 28 RECEIPT_NUM 14 SHIPMENT_NUM 5 16 UOM_CODE 13 VENDOR_NAME ACCRUAL_ACCOUNT ROW 1 ACCRUAL_CURRENCY_CODE FILTER 4 AGE_IN_DAYS VALUE 3 MAX CHARGE_ACCOUNT FILTER 5 FUNCTIONAL_ACCRUAL_AMOUNT VALUE 2 SUM LEDGER FILTER 1 OPERATING_UNIT FILTER 2 PERIOD FILTER 3 PIVOT_SORT_VALUE ROW 2 QUANTITY_ACCRUED VALUE 1 SUM S Site Accruals by PO/Release Lines Accrual Summarized by PO/Release Lines. Includes a summary Pivot on the selected Pivot/Sort Parameter Value. SYSADMIN 28 ACCRUAL_ACCOUNT 20 ACCRUAL_AMOUNT SUM 21 ACCRUAL_CURRENCY_CODE 24 AGE_IN_DAYS MAX 11 CATEGORY 27 CHARGE_ACCOUNT 23 FUNCTIONAL_ACCRUAL_AMOUNT SUM 12 ITEM_DESCRIPTION 26 ITEM_EXPENSE_ACCOUNT 10 ITEM_NAME 1 LEDGER 25 LINE_BILL_OF_LADING 22 LINE_FUNCTIONAL_UNIT_PRICE 8 LINE_NUM 4 19 LINE_PO_UNIT_PRICE 9 LINE_TYPE 2 OPERATING_UNIT 3 PERIOD 29 PIVOT_SORT_VALUE 1 18 PO_CURRENCY_CODE 4 PO_HEADER_STATUS 5 PO_LINE_STATUS 6 PO_NUMBER 2 7 PO_RELEASE_NUMBER 3 17 QUANTITY_ACCRUED SUM 16 QUANTITY_BILLED SUM 15 QUANTITY_RECEIVED SUM 14 UOM_CODE 13 VENDOR_NAME ACCRUAL_ACCOUNT ROW 1 ACCRUAL_CURRENCY_CODE FILTER 4 AGE_IN_DAYS VALUE 3 MAX CHARGE_ACCOUNT FILTER 5 FUNCTIONAL_ACCRUAL_AMOUNT VALUE 2 SUM LEDGER FILTER 1 OPERATING_UNIT FILTER 2 PERIOD FILTER 3 PIVOT_SORT_VALUE ROW 2 QUANTITY_ACCRUED VALUE 1 SUM S Site Accruals by PO/Release Shipments Accrual Summarized by PO/Release Shipments. Includes a summary Pivot on the selected Pivot/Sort Parameter Value SYSADMIN 37 ACCRUAL_ACCOUNT 25 ACCRUAL_AMOUNT SUM 26 ACCRUAL_CURRENCY_CODE 30 AGE_IN_DAYS 31 BILL_OF_LADING 11 CATEGORY 36 CHARGE_ACCOUNT 34 DISTRIBUTION_NUM 27 DIST_FUNCTIONAL_UNIT_PRICE 23 DIST_PO_UNIT_PRICE 29 FUNCTIONAL_ACCRUAL_AMOUNT SUM 12 ITEM_DESCRIPTION 33 ITEM_EXPENSE_ACCOUNT 10 ITEM_NAME 1 LEDGER 16 LINE_BILL_OF_LADING 15 LINE_FUNCTIONAL_UNIT_PRICE 8 LINE_NUM 4 14 LINE_PO_UNIT_PRICE 9 LINE_TYPE 2 OPERATING_UNIT 3 PERIOD 38 PIVOT_SORT_VALUE 1 39 PO (Release) Number 22 PO_CURRENCY_CODE 4 PO_HEADER_STATUS 5 PO_LINE_STATUS 6 PO_NUMBER 2 7 PO_RELEASE_NUMBER 3 21 QUANTITY_ACCRUED SUM 20 QUANTITY_BILLED SUM 19 QUANTITY_RECEIVED SUM 33 RECEIPT_DATE 32 RECEIPT_NUM 17 SHIPMENT_NUM 5 28 SHIP_FUNCTIONAL_UNIT_PRICE 24 SHIP_PO_UNIT_PRICE 18 UOM_CODE 13 VENDOR_NAME ACCRUAL_ACCOUNT ROW 1 ACCRUAL_CURRENCY_CODE FILTER 4 AGE_IN_DAYS VALUE 3 MAX CHARGE_ACCOUNT FILTER 5 FUNCTIONAL_ACCRUAL_AMOUNT VALUE 2 SUM LEDGER FILTER 1 OPERATING_UNIT FILTER 2 PERIOD FILTER 3 PIVOT_SORT_VALUE ROW 2 QUANTITY_ACCRUED VALUE 1 SUM S Site SYSADMIN Accruals by PO/Release Lines USER Accruals by PO/Release Lines Accruals by PO/Release Distributions