ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F8451A9E05362FB09050512Y SELECT cavh.batch_id, we.wip_entity_id, we.wip_entity_name, cavh.inventory_item_id, null item_name, pla.item_description, pha.segment1 po_number, pla.line_num po_line_num, pda.distribution_num po_distribution_num, null po_dist_account, cavh.variance_header_id source_line, null adjustment_account, ROUND(cavh.var_amount*1/:ROUND_UNIT)* :ROUND_UNIT header_var_amount, sum(decode(wta.cost_element_id,5,0,nvl(wta.base_transaction_value,0))) applied_value, sum(decode(wta.cost_element_id,5,0,nvl(wta.primary_quantity,0))) applied_quantity, aia.invoice_num, cavl.distribution_line_number, ROUND(cavl.var_amount*1/:ROUND_UNIT)* :ROUND_UNIT line_var_amount, cavh.transaction_date, to_char(cavh.transaction_date,'DD-MON-YY') dsp_transaction_date, ppa.segment1 project_number, fnd_flex_xml_publisher_apis.process_kff_combination_1('adjustment_account_seg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') adjustment_account_seg, fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ITEM_SEGMENT, fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') ITEM_PSEG, fnd_flex_xml_publisher_apis.process_kff_combination_1('po_dist_account_seg', 'SQLGL', 'GL#', CC2.CHART_OF_ACCOUNTS_ID, NULL, CC2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') po_dist_account_seg FROM cst_ap_variance_headers cavh, cst_ap_variance_lines cavl, cst_ap_variance_batches cavb, po_distributions_all pda, po_line_locations_all plla, po_lines_all pla, po_headers_all pha, pa_projects_all ppa, ap_invoices_all aia, mtl_system_items msi, gl_code_combinations cc1, gl_code_combinations cc2, rcv_transactions rt, wip_transactions wt, wip_transaction_accounts wta, wip_entities we WHERE cavb.batch_id = nvl(:lp_batch_id, -1) AND cavh.batch_id = cavb.batch_id AND cavl.variance_header_id = cavh.variance_header_id AND pda.po_distribution_id = cavh.po_distribution_id AND plla.line_location_id = pda.line_location_id AND pla.po_line_id = plla.po_line_id AND pha.po_header_id = plla.po_header_id AND ppa.project_id (+) = cavl.project_id AND aia.invoice_id = cavl.invoice_id AND msi.organization_id (+) = :p_organization_id1 AND msi.inventory_item_id (+) = cavh.inventory_item_id AND cc1.code_combination_id = cavb.adjustment_account AND cc2.code_combination_id = pda.accrual_account_id AND rt.po_distribution_id (+) = cavh.po_distribution_id AND wt.rcv_transaction_id (+) = rt.transaction_id AND wta.transaction_id (+) = wt.transaction_id AND wta.accounting_line_type (+) = 7 AND we.wip_entity_id = pda.wip_entity_id GROUP BY cavh.batch_id, we.wip_entity_id, we.wip_entity_name, cavh.inventory_item_id, &P_ITEM_SEG, pla.item_description, pha.segment1, pla.line_num, pda.distribution_num, &P_ACCT_SEG2, cavh.variance_header_id, &P_ACCT_SEG1, cavh.var_amount, aia.invoice_num, cavl.distribution_line_number, cavl.var_amount, cavh.transaction_date, ppa.segment1, fnd_flex_xml_publisher_apis.process_kff_combination_1('adjustment_account_seg', 'SQLGL', 'GL#', CC1.CHART_OF_ACCOUNTS_ID, NULL, CC1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('item_segment', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('item_pseg', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'PADDED_VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('po_dist_account_seg', 'SQLGL', 'GL#', CC2.CHART_OF_ACCOUNTS_ID, NULL, CC2.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') BOM CSTRIVTW_XML AR CST تقرير تباين فاتورة صالة الإنتاج (تنسيق XML) Imported from BI Publisher Description: تقرير تباين فاتورة صالة الإنتاج Application: شجرة المنتجات Source: تقرير تباين فاتورة صالة الإنتاج (تنسيق XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG D CST Werkstatt - Rechnungsabweichungen Imported from BI Publisher Description: Auswertung "Werkstatt - Rechnungsabweichungen" Application: Produktionsdaten Source: Werkstatt - Rechnungsabweichungen (XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG E CST Desviación de Factura de Planta Imported from BI Publisher Description: Desviación de Factura de Planta Application: Bills of Material Source: Desviación de Factura de Planta (XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG F CST Etat de l'écart des factures de l'atelier Imported from BI Publisher Description: Etat de l'écart des factures de l'atelier Application: Bills of Material Source: Etat de l'écart des factures de l'atelier (XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG I CST Rapporto Scostamento fattura reparti produttivi Imported from BI Publisher Description: Rapporto Scostamento fattura reparti produttivi Application: Bills of Material Source: Rapporto Scostamento fattura reparti produttivi (XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG JA CST 製造現場請求書検証レポート Imported from BI Publisher Description: 製造現場請求書検証レポート Application: Bills of Material Source: 製造現場請求書検証レポート(XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG KO CST 공정 현장 송장 차이 보고서 Imported from BI Publisher Description: 공정현장 송장 차이 보고서 Application: Bills of Material Source: 공정 현장 송장 차이 보고서(XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG PTB CST Relatório de Variação da NFF de Chão-de-Fábrica Imported from BI Publisher Description: Relatório de Variação da NFF de Chão-de-Fábrica Application: Bills of Material Source: Relatório de Variação da NFF de Chão-de-Fábrica (XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG RU CST Отчет о расхождении счетов-фактур на уровне цеха Imported from BI Publisher Description: Отчет о расхождении счетов-фактур на уровне цеха Application: Спецификации Source: Отчет о расхождении счетов-фактур на уровне цеха (XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG S CST Fakturaavvikelse för produktion - rapport Imported from BI Publisher Description: Fakturaavvikelse för produktion - rapport Application: Bills of Material Source: Fakturaavvikelse för produktion - rapport (XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG TR CST Atölye Fatura Farkı Raporu Imported from BI Publisher Description: Atölye Fatura Farkı Raporu Application: Ürün Ağacı Source: Atölye Fatura Farkı Raporu (XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG US CST Shop Floor Invoice Variance Imported from BI Publisher Description: Shop Floor Invoice Variance Report Application: Bills of Material Source: Shop Floor Invoice Variance Report (XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG ZHS CST 车间发票差异报表 Imported from BI Publisher Description: 车间发票差异报表 Application: 物料清单管理系统 Source: 车间发票差异报表 (XML) Short Name: CSTRIVTW_XML DB package: BOM_CSTRIVTW_XMLP_PKG BI Publisher &p_acct_seg1 &p_acct_seg2 &p_item_seg :cp_adjustment_account :cp_category :cp_category_set :cp_item :cp_item_range :cp_item_type :cp_org_code :cp_org_name :cp_project :cp_work_order :lp_batch_id :p_acct_seg1 :p_acct_seg2 :p_adjustment_account :p_adjustment_account_v :p_batch_id :p_category_id :p_category_id_v :p_category_name :p_category_set_id :p_category_set_id_v :p_category_set_name :p_conc_request_id :p_currency_code :p_cutoff_date :p_cutoff_date_v :p_description :p_description_v :p_gl_num :p_invoice_project_option :p_item_id :p_item_id_v :p_item_name :p_item_option :p_item_option_v :p_item_seg :p_item_structure_id :p_item_type :p_item_type_meaning :p_item_type_v :p_organization_id :p_organization_id1 :p_print_report :p_project_id :p_project_id_v :p_project_name :p_transaction_process_mode :p_transfer_ipv :p_view_cost :p_work_order_id :p_work_order_id_v :p_work_order_name :round_unit 1 -60 :p_organization_id Number fnd_profile.value('MFG_ORGANIZATION_ID') Y AR Organization_Id معرف التنظيم D Organization_Id Organisationskennung E Organization_Id Id Organización F Organization_Id ID organisation I Organization_Id Id dell'organizzazione JA Organization_Id 組織ID KO Organization_Id 조직 ID PTB Organization_Id Id da Organização RU Organization_Id Идентификатор организации S Organization_Id Organisations-id TR Organization_Id Organizasyon No US Organization_Id Organization Id ZHS Organization_Id 组织标识 2 -50 :p_transfer_ipv LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT meaning FROM mfg_lookups WHERE LOOKUP_TYPE = 'SYS_YES_NO' and lookup_code = 2 Y AR تحويل تباين سعر الفاتورة تحويل تباين سعر الفاتورة D Rechnungspreisabweichung transferieren Rechnungspreisabweichung transferieren E Transferir DPF Transferir DPF F Transférer Ecart/prix facturé Transférer Ecart/prix facturé I Trasferimento scostamento prezzo fattura Trasferimento scostamento prezzo fattura JA 転送IPV 転送IPV KO 이전 IPV 이전 IPV PTB IPV de Transferência IPV de Transferência RU Перенос РФЦ Перенос РФЦ S Överför FPA Överför FPA TR FFF'yi Transfer Et FFF'yi Transfer Et US Transfer IPV Transfer IPV ZHS 转移 IPV 转移 IPV 3 -40 :p_print_report LOV Oracle CST_SRS_YES_NO Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='SYS_YES_NO' order by value,description SELECT meaning FROM mfg_lookups WHERE LOOKUP_TYPE = 'SYS_YES_NO' and lookup_code = 1 Y AR طباعة التقرير طباعة التقرير D Auswertung drucken Auswertung drucken E Imprimir Informe Imprimir informe F Imprimer un état Imprimer un état I Stampa rapporto Stampa rapporto JA レポートの印刷 レポートの印刷 KO 보고서 인쇄 보고서 인쇄 PTB Imprimir Relatório Imprimir Relatório RU Печать отчета Печать отчета S Skriv ut rapport Skriv ut rapport TR Raporu Yazdırır Raporu Yazdırır US Print Report Print Report ZHS 打印报表 打印报表 4 -30 :p_gl_num Number fnd_profile.value('MFG_CHART_OF_ACCOUNTS_ID') Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kontenplankennung E Id Plan de Cuentas Id Plan de Cuentas F ID plan de comptes ID plan de comptes I Id piano dei conti Id del piano dei conti JA 勘定体系ID 勘定体系ID KO 계정 코드집 ID 계정 코드집 ID PTB Id do Plano de Contas Id do Plano de Contas RU Идентификатор плана счетов Идентификатор плана счетов S Kontoplans-id Kontoplans-id TR Hesap Planı No Hesap Planı No US Chart of Accounts Id Chart of Accounts Id ZHS 科目表标识 科目表标识 5 -20 :p_view_cost Number fnd_profile.value('CST_VIEW_COSTS') AR امتياز عرض التكاليف امتياز عرض التكاليف D Berechtigung für Kosten anzeigen Berechtigung für Kosten anzeigen E Privilegio de Consultar Costes Privilegio de Consultar Costes F Voir privilège coût Voir privilège coût I Visualizza privilegio costi Visualizza privilegio costi JA 原価権限の表示 原価権限の表示 KO 원가 특권 조회 원가 특권 조회 PTB Verificar Privilégio de Custo Verificar Privilégio de Custo RU Привилегия просмотра затрат Привилегия просмотра затрат S Behörighet att granska kostnader Behörighet att granska kostnader TR Maliyet Ayrıcalığını Görüntüle Maliyet Ayrıcalığını Görüntüle US View Cost Privilege View Cost Privilege ZHS 查看成本权限 查看成本权限 6 10 :p_batch_date Date SELECT fnd_date.date_to_displaydate(TRUNC(SYSDATE)-7) FROM DUAL Y AR Batch_Date تاريخ المجموعة D Batch_Date Stapeldatum E Batch_Date Fecha de Lote F Batch_Date Date du lot I Batch_Date Data batch JA Batch_Date バッチ日付 KO Batch_Date 뱃치 일자 PTB Batch_Date Data do Lote RU Batch_Date Дата пакета S Batch_Date Partidatum TR Batch_Date İşlem Grup Tarihi US Batch_Date Batch Date ZHS Batch_Date 批日期 7 20 :p_batch_id LOV Oracle CST_SRS_IPV_WIP_LIMITED_BATCH Y select cavb.batch_id id, cavb.batch_id value, cavb.description description from cst_ap_variance_batches cavb,wip_entities we,mtl_system_items_kfv msik,mtl_category_sets mcs,mtl_categories_kfv mck,pa_projects_all ppa,mfg_lookups ml where cavb.organization_id=:$flex$.organization_id and cavb.wip_entity_id=we.wip_entity_id (+) and cavb.item_type=ml.lookup_code (+) and 'CST_IPV_WIP_ITEM_TYPE'=ml.lookup_type (+) and cavb.specific_item_id=msik.inventory_item_id (+) and :$flex$.organization_id=msik.organization_id (+) and cavb.category_set_id=mcs.category_set_id (+) and cavb.category_id=mck.category_id (+) and cavb.specific_project_id=ppa.project_id (+) and cavb.creation_date>=fnd_date.canonical_to_date(:$flex$.batch_date) order by cavb.creation_date desc Y AR معرف التشغيلة معرف التشغيلة D Stapelkennung Stapelkennung E Id Lote Id Lote F ID lot ID lot I Id batch Id batch JA バッチID バッチID KO 배치 ID 배치 ID PTB Id do Lote Id do Lote RU Идентификатор пакета Идентификатор пакета S Batch-id Batch-id TR İşlem Grubu No İşlem Grubu No US Batch Id Batch Id ZHS 批标识 批标识