ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F8351A9E05362FB09050512Y select null ITEM_NAME, batch_id, null adjustment_account, project_number , cost_group, transaction_date, variance_header_id interface_txn_src_line, msi.description item_description, current_quantity, ROUND(current_item_cost * 1 / :ROUND_UNIT) * :ROUND_UNIT current_item_cost, ROUND(pcnt_value_change,2) pcnt_value_change, po_number, po_line_num, invoice_num, invoice_dist_line_num, po_distribution_num, null po_dist_account, ROUND(header_var_amount * 1 / :ROUND_UNIT) * :ROUND_UNIT header_var_amount, ROUND(line_var_amount * 1 / :ROUND_UNIT) * :ROUND_UNIT line_var_amount, cavv.inventory_item_id item_id, 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_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('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('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_v cavv, mtl_system_items msi, gl_code_combinations cc1, gl_code_combinations cc2 where cavv.organization_id = :p_org_id and cavv.batch_id = nvl(:p_batch_id, cavv.batch_id) and cavv.inventory_item_id = nvl(:p_inventory_item_id,cavv.inventory_item_id) and msi.organization_id = :p_org_id and msi.inventory_item_id = cavv.inventory_item_id and cc1.code_combination_id = cavv.adjustment_account and cc2.code_combination_id = cavv.po_dist_account ORDER BY 2 ASC,3 ASC,5 ASC,8 ASC,20 ASC,10 ASC,9 ASC,13 ASC,12 ASC,16 ASC,6 ASC,7 ASC,18 ASC,11 ASC,17 ASC BOM CSTRIVTI_XML AR CST تحويل الفاتورة إلى المخزن (تنسيق XML) Imported from BI Publisher Description: تحويل الفاتورة إلى المخازن Application: شجرة المنتجات Source: تحويل الفاتورة إلى المخزن (تنسيق XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG D CST Rechnungs-Neuzuordnung - Lager Imported from BI Publisher Description: Rechnungs-Neuzuordnung - Lager Application: Produktionsdaten Source: Rechnungs-Neuzuordnung - Lager (XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG E CST Transferencia de Facturas a Inventario Imported from BI Publisher Description: Transferencia de Factura a Inventario Application: Bills of Material Source: Transferencia de Facturas a Inventario (XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG F CST Transfert des factures dans Inventory Imported from BI Publisher Description: Transfert des factures dans Oracle Inventory Application: Bills of Material Source: Transfert des factures dans Inventory (XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG I CST Trasferimento fattura a magazzino Imported from BI Publisher Description: Trasferisci fattura a magazzino Application: Bills of Material Source: Trasferimento fattura a magazzino (XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG JA CST 在庫への請求書転送 Imported from BI Publisher Description: 在庫への請求書転送 Application: Bills of Material Source: 在庫への請求書転送(XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG KO CST 재고로 송장 이전 Imported from BI Publisher Description: 재고로 송장 이전 Application: Bills of Material Source: 재고로 송장 이전(XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG PTB CST Transferência de NFF para Inventário Imported from BI Publisher Description: Transferência de NFF para Inventário Application: Bills of Material Source: Transferência de NFF para Inventário (XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG RU CST Перенос запасов в складское подразделение Imported from BI Publisher Description: Перенос запасов в складское подразделение Application: Спецификации Source: Перенос запасов в складское подразделение (XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG S CST Överföring av faktura till lager Imported from BI Publisher Description: Överföring av faktura till lager Application: Bills of Material Source: Överföring av faktura till lager (XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG TR CST Envantere Fatura Transferi Imported from BI Publisher Description: Envantere Fatura Transferi Application: Ürün Ağacı Source: Envantere Fatura Transferi (XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG US CST Invoice Transfer to Inventory Imported from BI Publisher Description: Invoice Transfer to Inventory Application: Bills of Material Source: Invoice Transfer to Inventory (XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG ZHS CST 发票传送至 Oracle Inventory Imported from BI Publisher Description: 将发票传送至库存管理系统 Application: 物料清单管理系统 Source: 发票传送至 Oracle Inventory (XML) Short Name: CSTRIVTI_XML DB package: BOM_CSTRIVTI_XMLP_PKG BI Publisher :cp_org_name :p_acct_seg1 :p_acct_seg2 :p_batch_id :p_conc_request_id :p_currency_code :p_gl_num :p_inventory_item_id :p_item_seg :p_item_structure_id :p_org_id :p_view_cost :round_unit 1 -40 :p_org_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 -30 :p_gl_num Number fnd_profile.value('MFG_CHART_OF_ACCOUNTS_ID') Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات D Kontenplankennung Kennung Kontenplan E Id Plan de Cuentas Identificador de 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 科目表标识 科目表标识 3 -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 Görüntüleme ayrıcalığı US View Cost Privilege View Cost privilege ZHS 查看成本权限 查看成本权限 4 10 :p_batch_id LOV Oracle CST_SRS_IPV_BATCH Y select batch_id id, batch_id value, description description from cst_ap_variance_batches where organization_id=:$flex$.organization_id order by value,description AR التشغيلة معرف التشغيلة D Stapel Stapelkennung E Lote Id Lote F Lot ID lot I Batch Id batch JA バッチ バッチID KO 뱃치 배치 ID PTB Lote Id do Lote RU Пакет Идентификатор пакета S Batch Batch-id TR İşlem Grubu İşlem Grubu No US Batch Batch Id ZHS 批 批标识 5 20 :p_inventory_item_id Char AR صنف مخزني معرف صنف المخزن D Lagerartikel Lagerartikel-Nr. E Artículo de Inventario Identificador de artículo de inventario F Article stocké ID article stocké I Articolo magazzino Id articolo di magazzino JA 在庫品目 在庫品目ID KO 재고 품목 재고 품목 Id PTB Item do Inventário Id do item do inventário RU Позиция запасов Идентификатор позиции запасов S Lagerartikel Lagerartikel-id TR Envanter Kalemi Envanter kalem no US Inventory Item Inventory item id ZHS 库存物料 库存物料标识