ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A8A90FEFA0BF3C79E053B46B63585557Y select gl.name ledger, hou.name operating_unit, ooha.order_number, rtrim(oola.line_number||'.'||oola.shipment_number||'.'||oola.option_number||'.'||oola.component_number||'.'||oola.service_number,'.') line, xxen_util.meaning(obpha.billing_plan_status,'BILLING_PLAN_STATUS',660) billing_plan_status, obpha.billing_frequency, obpha.billing_period, obpha.start_date, obpha.billing_amount, obpha.bill_with_source_line, obpha.type_of_billing, obpha.last_reviewed_extd_price, obpha.usage_unit_desc, obpha.type_of_usage, obpla.sequence_number, obpla.bill_date, obpla.bill_amount, obpla.description, rtrim(oola2.line_number||'.'||oola2.shipment_number||'.'||oola2.option_number||'.'||oola2.component_number||'.'||oola2.service_number,'.') billed_line, xxen_util.meaning(obpla.milestone,'BILLING_PLAN_MILESTONE',660) milestone, obpla.usage, xxen_util.user_name(obpha.created_by) created_by, xxen_util.client_time(obpha.creation_date) creation_date, xxen_util.user_name(obpha.last_updated_by) last_updated_by, xxen_util.client_time(obpha.last_update_date) last_update_date from hr_operating_units hou, gl_ledgers gl, oe_order_headers_all ooha, oe_order_lines_all oola, oe_billing_plan_headers_all obpha, oe_billing_plan_lines_all obpla, oe_order_lines_all oola2 where 1=1 and hou.organization_id=ooha.org_id and gl.ledger_id=hou.set_of_books_id and ooha.header_id=obpha.source_order_header_id and oola.line_id=obpha.source_order_line_id and obpha.billing_plan_header_id=obpla.billing_plan_header_id and obpla.billed_line_id=oola2.line_id(+) order by gl.name, hou.name, ooha.order_number, line, obpla.sequence_number (:Ledger is not null or :Operating_Unit is not null) AR ONT Recurring Billing Plan تقرير الملف الشخصي يعرض خطة الفوترة المتكررة لأمر المبيعات لتفاصيل العنوان والسطر بما في ذلك الحالة والتكرار وفترة الفوترة ومبالغ الفواتير والتواريخ. D ONT Recurring Billing Plan Profilbericht, der den Kundenauftrags-Wiederholungsfakturierungsplan für Kopf- und Zeilendetails einschließlich Status, Häufigkeit, Fakturierungszeitraum, Fakturierungsbeträge und -daten anzeigt. E ONT Recurring Billing Plan Informe de perfil que muestra el plan de facturación periódica del pedido de cliente para los detalles de la cabecera y la línea, incluyendo el estado, la frecuencia, el período de facturación, los importes de facturación y las fechas. F ONT Recurring Billing Plan Rapport de profil montrant le plan de facturation récurrente de la commande client pour les détails d'en-tête et de ligne, y compris le statut, la fréquence, la période de facturation, les montants et les dates de facturation. I ONT Recurring Billing Plan Rapporto di profilo che mostra il piano di fatturazione ricorrente dell'ordine di vendita per i dettagli dell'intestazione e della linea, compreso lo stato, la frequenza, il periodo di fatturazione, gli importi e le date di fatturazione. JA ONT Recurring Billing Plan ステータス、頻度、請求期間、請求金額、日付を含むヘッダーとラインの詳細について、販売注文の定期的な請求プランを表示するプロファイルレポートです。 KO ONT Recurring Billing Plan 상태, 빈도, 청구 기간, 청구 금액 및 날짜를 포함한 헤더 및 라인 세부 사항에 대한 판매 주문 반복 청구 계획을 보여주는 프로필 보고서. PTB ONT Recurring Billing Plan Relatório de perfil mostrando o plano de faturamento periódico da ordem de venda para detalhes de cabeçalho e linha incluindo status, freqüência, período de faturamento, valores e datas de faturamento. RU ONT Recurring Billing Plan Профильный отчет, показывающий план повторяющихся расчетов по заголовкам и строкам, включая статус, частоту, расчетный период, суммы и даты выставления счетов. S ONT Recurring Billing Plan Profilrapport som visar återkommande faktureringsplan för försäljningsorder för rubrik- och raddetaljer inklusive status, frekvens, faktureringsperiod, faktureringsbelopp och datum. TR ONT Recurring Billing Plan Durum, sıklık, fatura dönemi, fatura tutarları ve tarihleri dahil olmak üzere başlık ve satır ayrıntıları için Satış siparişi yinelenen faturalandırma planını gösteren profil raporu. US ONT Recurring Billing Plan Profile report showing the Sales order recurring billing plan for header and line details including status, frequency, billing period, billing amounts and dates. Please enter a Ledger or Operating Unit ZHS ONT Recurring Billing Plan 概要报告显示了销售订单重复计费计划的标题和行的详细信息，包括状态、频率、计费周期、计费金额和日期。 Enginatics R12 only 1=1 1 10 1=1 gl.name=:ledger 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) LOV GL Ledger 8E2FF36EDEB879D2E0530100007F1FF2 Y select gl.name value, fifsv.id_flex_structure_name||': '||decode(gl.ledger_category_code,'NONE',xxen_util.meaning(gl.object_type_code,'LEDGERS',101),xxen_util.meaning(gl.ledger_category_code,'GL_ASF_LEDGER_CATEGORY',101))||': '||gl.description description from gl_ledgers gl, fnd_id_flex_structures_vl fifsv where (:$flex$.ledger_category is null or gl.ledger_category_code=xxen_util.lookup_code(:$flex$.ledger_category,'GL_ASF_LEDGER_CATEGORY',101,'Y')) and (:$flex$.chart_of_accounts is null or xxen_util.contains(:$flex$.chart_of_accounts,fifsv.id_flex_structure_name)='Y') and gl.ledger_id in (select xroa.id from xxen_report_org_access xroa where xroa.access_type='LEDGER') 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, decode(gl.ledger_category_code,'PRIMARY',1,'SECONDARY',2,'ALC',3,'NONE',4), gl.name US Ledger 2 20 1=1 hou.name=: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 xroa.id from xxen_report_org_access xroa where xroa.access_type='OU') order by hou.name coalesce(xxen_util.default_operating_unit,xxen_util.previous_parameter_value(:parameter_id)) US Operating Unit 3 30 1=1 ooha.order_number=:order_number LOV ONT Order Number 8E2FF36EDEE779D2E0530100007F1FF2 Y Y select ooha.order_number value, ottt.name||': '||hca.account_name||' ('||xxen_util.meaning(ooha.flow_status_code,'FLOW_STATUS',660)||')' description from oe_order_headers_all ooha, oe_transaction_types_tl ottt, hz_cust_accounts hca where nvl(ooha.transaction_phase_code,'F')='F' and (:$flex$.operating_unit is null or ooha.org_id=(select haouv.organization_id from hr_all_organization_units_vl haouv where xxen_util.contains(:$flex$.operating_unit,haouv.name)='Y')) and ooha.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 ooha.sold_to_org_id=hca.cust_account_id and ooha.order_type_id=ottt.transaction_type_id and ottt.language=userenv('lang') order by ooha.order_number desc US Order Number