ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D46F8D51A9E05362FB09050512 SELECT null C_FLEXDATA , l.description Description , wt.transaction_date Txn_date , wt.operation_seq_num OpSq , wt.resource_seq_num RsSq , we.wip_entity_name Job_Schedule , wl.line_code Line , msi.description A_Desc , wdj.class_code D_class , wri.class_code R_class , bd.department_code Department , br.resource_code Res_Ovhd , br.unit_of_measure UOM , ca.activity Activity , lu.meaning Txn_type , xlu.meaning Basis , decode(cal.accounted_dr,NULL, -1 * wt.primary_quantity,wt.primary_quantity) Primary_quantity , round(cal.rate_or_amount * :p_exchange_rate, :p_rate_precision) Rate_or_Amt , nvl(nvl(cal.accounted_dr, -1 * cal.accounted_cr),0) * :p_exchange_rate Extended_cost , fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_sort', 'SQLGL', 'GL#', L.CHART_OF_ACCOUNTS_ID, NULL, L.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') C_FLEX_SORT , fnd_flex_xml_publisher_apis.process_kff_combination_1('account', 'SQLGL', 'GL#', L.CHART_OF_ACCOUNTS_ID, NULL, L.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') Account , fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_descrip', 'SQLGL', 'GL#', L.CHART_OF_ACCOUNTS_ID, NULL, L.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') C_ACCT_DESCRIP , BOM_CSTRPWDD_XMLP_PKG.c_acct_total_rformula(:C_ACCT_TOTAL) C_acct_total_r , BOM_CSTRPWDD_XMLP_PKG.class(wri.class_code, wdj.class_code) CLASS , fnd_flex_xml_publisher_apis.process_kff_combination_1('assembly', 'INV', 'MSTK', 101, MSI.ORGANIZATION_ID, MSI.INVENTORY_ITEM_ID, 'ALL', 'Y', 'VALUE') ASSEMBLY , BOM_CSTRPWDD_XMLP_PKG.c_job_total_rformula(:C_JOB_TOTAL) C_job_total_r , BOM_CSTRPWDD_XMLP_PKG.c_ext_cost_rformula(nvl ( nvl ( cal.accounted_dr , - 1 * cal.accounted_cr ) , 0 ) * :p_exchange_rate) extended_cost_r FROM gl_code_combinations L , wip_entities we , wip_lines wl , wip_discrete_jobs wdj , wip_repetitive_items wri , mtl_system_items msi , mfg_lookups lu , mfg_lookups xlu , cst_activities ca , bom_departments bd , bom_resources br , cst_ae_headers cah , cst_ae_lines cal , wip_transactions wt WHERE cah.ae_header_id=cal.ae_header_id AND cah.accounting_event_id=wt.transaction_id AND UPPER(cah.acct_event_source_table)='WT' AND cal.code_combination_id=l.code_combination_id AND cah.cost_group_id=:p_cost_group_id AND cah.cost_type_id=:p_cost_type_id AND cah.period_id=:p_period_id AND wt.transaction_type=nvl(:p_trans_type,wt.transaction_type) AND nvl(wt.activity_id,-1)=nvl(:p_activity,nvl(wt.activity_id,-1)) AND nvl(wt.department_id,-1)=nvl(:p_department,nvl(wt.department_id,-1)) AND nvl(wt.line_id,-1)=nvl(:p_line,nvl(wt.line_id,-1)) AND wt.organization_id=cah.organization_id AND we.organization_id=wt.organization_id AND we.wip_entity_id=wt.wip_entity_id AND nvl(we.primary_item_id,-1)=nvl(:p_assembly_id,nvl(we.primary_item_id,-1)) AND wdj.organization_id(+)=wt.organization_id AND wdj.wip_entity_id(+)=wt.wip_entity_id AND wri.organization_id(+)=wt.organization_id AND wri.wip_entity_id(+)=wt.wip_entity_id AND wri.line_id(+)=wt.line_id AND wl.organization_id(+)=wt.organization_id AND wl.line_id(+)=wt.line_id AND msi.organization_id(+)=we.organization_id AND msi.inventory_item_id(+)=we.primary_item_id AND bd.department_id(+)=wt.department_id AND br.resource_id(+)=cal.resource_id AND ca.activity_id(+)=cal.activity_id AND lu.lookup_type='WIP_TRANSACTION_TYPE_SHORT' AND lu.lookup_code=wt.transaction_type AND xlu.lookup_type='CST_BASIS_SHORT' AND xlu.lookup_code=cal.basis_type AND &p_limit_entity AND &p_where_acct AND &p_limit_classes ORDER BY fnd_flex_xml_publisher_apis.process_kff_combination_1('c_flex_sort', 'SQLGL', 'GL#', L.CHART_OF_ACCOUNTS_ID, NULL, L.CODE_COMBINATION_ID, 'ALL', 'Y', 'PADDED_VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('account', 'SQLGL', 'GL#', L.CHART_OF_ACCOUNTS_ID, NULL, L.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') , fnd_flex_xml_publisher_apis.process_kff_combination_1('c_acct_descrip', 'SQLGL', 'GL#', L.CHART_OF_ACCOUNTS_ID, NULL, L.CODE_COMBINATION_ID, 'ALL', 'Y', 'DESCRIPTION') , we.wip_entity_name , wl.line_code , wt.transaction_date , wt.transaction_type , wt.operation_seq_num , wt.resource_seq_num , br.resource_code , wt.creation_date , wt.transaction_id , cal.rowid Y BOM CSTRPWDD_XML AR CST تقرير تفاصيل توزيع ما تحت التنفيذ الدوري (تنسيق XML) Imported from BI Publisher Description: تقرير تفاصيل توزيع ما تحت التنفيذ الدوري Application: شجرة المنتجات Source: تقرير تفاصيل توزيع ما تحت التنفيذ الدوري (تنسيق XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG D CST Periodische Fertigungsaufteilung - Details Imported from BI Publisher Description: Periodische Kontenaufteilung/Fertigung - Details Application: Produktionsdaten Source: Periodische Fertigungsaufteilung - Details (XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG E CST Detalles de Distribución de Obra en Curso Periódicos Imported from BI Publisher Description: Informe Detalles de Distribución Periódica de Cuenta de Obra en Curso Application: Bills of Material Source: Detalles de Distribución de Obra en Curso Periódicos (XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG F CST Etat Détail des imputations périodiques de la production Imported from BI Publisher Description: Etat détaillé des répartitions comptables atelier périodiques Application: Bills of Material Source: Etat Détail des imputations périodiques de la production (XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG I CST Rapporto Dettagli distribuzione WIP periodica Imported from BI Publisher Description: Rapporto periodico Dettagli distribuzione conti WIP Application: Bills of Material Source: Rapporto Dettagli distribuzione WIP periodica (XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG JA CST 期間WIP配分詳細レポート Imported from BI Publisher Description: 期間WIP勘定科目配分詳細レポート Application: Bills of Material Source: 期間WIP配分詳細レポート(XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG KO CST 기간별 WIP 분배 상세내역 보고서 Imported from BI Publisher Description: 기간별 WIP 계정 분배 상세내역 보고서 Application: Bills of Material Source: 기간별 WIP 분배 상세내역 보고서(XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG PTB CST Relatório Detalhado de Distribuição WIP (Periódico) Imported from BI Publisher Description: Relatório Periódico Detalhado de Distribuição de Conta do WIP Application: Bills of Material Source: Relatório Detalhado de Distribuição WIP (Periódico) (XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG RU CST Подробный отчет о периодических распределениях НзП Imported from BI Publisher Description: Подробный отчет о периодических распределениях счетов НзП Application: Спецификации Source: Подробный отчет о периодических распределениях НзП (XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG S CST Periodisk kontering av PIA - detaljrapport Imported from BI Publisher Description: Detaljer för periodisk kontering av PIA - rapport Application: Bills of Material Source: Periodisk kontering av PIA - detaljrapport (XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG TR CST Dönemsel WIP Dağıtım Detayları Raporu Imported from BI Publisher Description: Dönemsel WIP Hesap Dağıtım Detayları Raporu Application: Ürün Ağacı Source: Dönemsel WIP Dağıtım Detayları Raporu (XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG US CST Periodic WIP Distribution Details Imported from BI Publisher Description: Periodic WIP Account Distribution Details Report Application: Bills of Material Source: Periodic WIP Distribution Details Report (XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG ZHS CST 定期 WIP 分配明细报表 Imported from BI Publisher Description: 定期 WIP 帐户分配明细报表 Application: 物料清单管理系统 Source: 定期 WIP 分配明细报表 (XML) Short Name: CSTRPWDD_XML DB package: BOM_CSTRPWDD_XMLP_PKG BI Publisher &p_limit_classes &p_limit_entity &p_where_acct :c_acct_total :c_job_total :cp_activity_cov :cp_application :cp_cost_group :cp_cost_type :cp_department_code_cov :cp_legal_entity :cp_line_code_cov :cp_period_name :cp_request_time :cp_requested_by :cp_responsibility :cp_txn_type_cov :cp_wip_entity_name_cov :p_acct_hi :p_acct_lo :p_activity :p_assembly_id :p_assy_flex :p_class_code :p_conc_request_id :p_cost_group_id :p_cost_type_id :p_currency_code :p_currency_precision :p_debug :p_department :p_exchange_rate :p_flexdata :p_job :p_limit_classes :p_limit_entity :p_line :p_period_id :p_quantity_precision :p_rate_precision :p_struct_num :p_trans_type :p_where_acct 1 -60 :p_struct_num LOV Oracle CST_SRS_PAC_AP_COAID_BY_LECT Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_sets_of_books where set_of_books_id in (select set_of_books_id from cst_le_cost_types where cost_type_id=:$flex$.cst_srs_pac_ct_proc and legal_entity=:$flex$.cst_srs_pac_ap_le ) order by value,description SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id IN (SELECT set_of_books_id FROM cst_le_cost_types WHERE legal_entity = :$flex$.legal_entity and cost_type_id = :$flex$.cost_type) Y AR معرف جدول تصنيف الحسابات معرف جدول تصنيف الحسابات - معامل مخفي D Kontenplankennung Kontenplan - verborgenes Feld E Id Plan de Cuentas Identificador de Plan de Cuentas: Parámetro oculto F ID plan de comptes ID plan de comptes - paramètre caché I ID piano dei conti ID piano dei conti - parametro nascosto JA 勘定体系ID 勘定体系ID - 隠しパラメータ KO 계정 코드집 ID 계정 코드집 ID - 숨은 매개변수 PTB ID do Plano de Contas ID do plano de contas - parâmetro oculto RU Идентификатор плана счетов Идентификатор плана счетов - скрытый параметр S Kontoplans-id Kontoplans-id - dold parameter TR Hesap Planı No Hesap planı no - gizli parametre US Chart of Accounts ID Chart of account ID - hidden parameter ZHS 科目表标识 科目表标识 - 隐藏参数 2 -50 :p_master_org_id Number SELECT organization_id FROM cst_cost_groups WHERE cost_group_id = :$flex$.organization_cost_group Y AR معرف التنظيم الرئيسي معرف التنظيم الرئيسي - معامل مخفي D Kennung Hauptorganisation Kennung Hauptorganisation - verborgener Parameter E Id Organización Maestra Identificador de Organización Maestra - parámetro oculto F ID organisation principale ID organisation principale - paramètre caché I Id organizzazione principale ID dell'organizzazione principale - parametro nascosto JA マスター組織ID マスター組織ID - 隠しパラメータ KO 마스터 조직 ID 마스터 조직 ID - 숨은 매개변수 PTB ID da Organização-Mestre ID da Organização-Mestre - parâmetro oculto RU Идентификатор главной организации Идентификатор главной организации (скрытый параметр) S Huvudorganisations-id Huvudorganisations-id - dold parameter TR Ana Organizasyon No Ana Organizasyon No - gizli parametre US Master Organization ID Master Organization ID - hidden parameter ZHS 主组织标识 主组织 - 隐藏参数 3 -40 :p_inverse_rate Char fnd_profile.value('DISPLAY_INVERSE_RATE') Y AR CST_SRS_INVERSE_RATE سعر عكسي - حقل مخفي D CST_SRS_INVERSE_RATE Kehrwert - verborgenes Feld E CST_SRS_INVERSE_RATE Tipo de Cambio Inverso: Campo oculto F CST_SRS_INVERSE_RATE Taux inverse - champ masqué I CST_SRS_INVERSE_RATE Tasso inverso - campo nascosto JA CST_SRS_INVERSE_RATE 逆算レート - 隠しフィールド KO CST_SRS_INVERSE_RATE 역산율 - 비공개 필드 PTB CST_SRS_INVERSE_RATE Estornar taxa - campo oculto RU CST_SRS_INVERSE_RATE Обратный курс (скрытое поле) S CST_SRS_INVERSE_RATE Inverterad takt - dolt fält TR CST_SRS_INVERSE_RATE Ters kur - gizli alan US CST_SRS_INVERSE_RATE Inverse rate - hiden field ZHS CST_SRS_INVERSE_RATE 逆汇率 - 隐藏字段 4 -30 :p_rate_type Number fnd_profile.value('CST_EXCHANGE_RATE_TYPE') Y AR CST_SRS_RATE_TYPE نوع السعر - حقل مخفي D CST_SRS_RATE_TYPE Kursart - verborgenes Feld E CST_SRS_RATE_TYPE Clase de Tipo de Cambio - campo oculto F CST_SRS_RATE_TYPE Type de taux - champ masqué I CST_SRS_RATE_TYPE Tipo di tasso - campo nascosto JA CST_SRS_RATE_TYPE レート・タイプ - 隠しフィールド KO CST_SRS_RATE_TYPE 비율 유형 - 숨은 필드 PTB CST_SRS_RATE_TYPE Tipo de taxa - campo oculto RU CST_SRS_RATE_TYPE Тип курса (скрытое поле) S CST_SRS_RATE_TYPE Kurstyp - dolt fält TR CST_SRS_RATE_TYPE Kur tipi - gizli alan US CST_SRS_RATE_TYPE Rate type - hidden field ZHS CST_SRS_RATE_TYPE 汇率类型 - 隐藏字段 5 -20 :p_quantity_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 Nachkommastellen Nachkommastellen E Precisión de Cantidad Precisión de Cantidad F Précision des quantités Précision des quantités I Precisione quantità Precisione quantità JA 数量精度 数量精度 KO 수량 소수점 이하 자리수 수량 소수점이하 자리수 PTB Precisão da Quantidade Precisão da quantidade RU Точность количества Точность количества S Kvantitetsprecision Kvantitetsprecision TR Miktar Duyarlılığı Miktar duyarlılığı US Quantity Precision Quantity precision ZHS 数量精确度 数量精确度 6 10 :p_legal_entity_id LOV Oracle CST_SRS_PAC_AP_LE Y select legal_entity_id id, name value, null description from xle_firstparty_information_v where legal_entity_id in (select distinct legal_entity from cst_le_cost_types where create_acct_entries='Y') order by value,description Y AR الكيان القانوني كيان قانوني D Mandant Mandant E Entidad Legal Entidad Legal F Entité juridique Entité juridique I Persona giuridica Persona giuridica JA 法的エンティティ 法的エンティティ KO 법인 법인 PTB Pessoa Jurídica Pessoa jurídica RU Юридическое лицо Юридическое лицо S Juridisk enhet Juridisk enhet TR Tüzel Kişilik Tüzel kişilik US Legal Entity Legal entity ZHS 法人主体 法人主体 7 20 :p_cost_type_id LOV Oracle CST_SRS_PAC_CT_PROC Y select ct.cost_type_id id, ct.cost_type value, null description from cst_cost_types ct where ct.cost_type_id in (select distinct cost_type_id from cst_le_cost_types where legal_entity=:$flex$.cst_srs_pac_ap_le and create_acct_entries='Y') and exists (select 1 from cst_pac_periods where pac_period_id in (select pac_period_id from cst_pac_process_phases where process_phase=6 and process_status=4) and cost_type_id=ct.cost_type_id) and nvl(disable_date,sysdate+1)>sysdate order by value,description Y AR نوع التكلفة نوع التكلفة D Kostentyp Kostentyp E Tipo de Coste Tipo de Coste F Type de coût Type de coût I Tipo di costo Tipo di costo JA 原価タイプ 原価タイプ KO 원가 유형 원가 유형 PTB Tipo de Custo Tipo de custo RU Тип затрат Тип затрат S Kostnadstyp Kostnadstyp TR Maliyet Tipi Maliyet tipi US Cost Type Cost type ZHS 成本类型 成本类型 8 30 :p_cost_group_id LOV Oracle CST_SRS_PAC_CG_PROC Y select ccg.cost_group_id id, ccg.cost_group value, null description from cst_cost_groups ccg where ccg.legal_entity=:$flex$.cst_srs_pac_ap_le and exists (select 1 from cst_pac_periods cpp where legal_entity=:$flex$.cst_srs_pac_ap_le and cost_type_id=:$flex$.cst_srs_pac_ct_proc and cpp.pac_period_id in (select cppp.pac_period_id from cst_pac_process_phases cppp where cppp.cost_group_id=ccg.cost_group_id and process_phase=6 and process_status=4 ) ) order by value,description Y AR مجموعة تكاليف التنظيم مجموعة التكاليف D Organisations-Kostengruppe Kostengruppe E Grupo de Costes de Organización Grupo de Costes F Groupe de coûts organisation Groupe de coûts I Gruppo di costi organizzazione Gruppo di costi JA 組織原価グループ 原価グループ KO 조직 원가 그룹 원가 그룹 PTB Grupo de Custos da Organização Grupo de Custos RU Группа затрат для организации Группа затрат S Kostnadsgrupp för organisation Kostnadsgrupp TR Organizasyon Maliyet Grubu Maliyet grubu US Organization Cost Group Cost group ZHS 组织成本组 成本组 9 40 :p_period_id LOV Oracle CST_SRS_PAC_PRD_PROC Y select cpp.pac_period_id id, cpp.period_name value, null description from cst_pac_periods cpp where cpp.legal_entity=:$flex$.cst_srs_pac_ap_le and cpp.cost_type_id=:$flex$.cst_srs_pac_ct_proc and pac_period_id in (select distinct pac_period_id from cst_pac_process_phases where cost_group_id=:$flex$.cst_srs_pac_cg_proc and process_phase=6 and process_status=4) order by value,description Y AR الفترة فترة دورية D Periode Periodische Periode E Período Período Periódico F Période Période I Periodo Periodo per periodo JA 期間 期間別期間 KO 기간 기간별 기간 PTB Período Período (periódico) RU Период Периодический период S Period Periodiseringsperiod TR Dönem Dönemsel dönem US Period Periodic period ZHS 期间 定期期间 10 50 :p_acct_lo Char AR حساب من الحساب من D Von Konto Von Konto E De Cuenta De Cuenta F Compte - De Compte - De I Conto - Da Conto - Da JA 勘定科目:自 勘定科目:自 KO 계정: 부터 계정: 부터 PTB Conta - De Conta - de RU Счет с Счет с S Från konto Från konto TR Hesap, İlk İlk Hesap US Account From Account from ZHS 帐户自 帐户自 11 60 :p_acct_hi Char AR إلى إلى حساب D Bis Bis Konto E A A Cuenta F A Compte - A I A Conto - A JA 至 勘定科目:至 KO 까지 계정: 까지 PTB Até Conta - até RU По Счет по S Till Till konto TR Son Son Hesap US To Account to ZHS 至 帐户至 12 70 :p_organization_id LOV Oracle CST_SRS_PAC_AP_ORG_BY_CG Y select organization_id id, organization_code value, organization_name description from org_organization_definitions where organization_id in (select organization_id from cst_cost_group_assignments where cost_group_id=:$flex$.cst_srs_pac_cg_proc ) order by organization_code AR التنظيم D Organisation E Organización F Organisation I Organizzazione JA 組織 KO 조직 PTB Organização RU Организация S Organisation TR Organizasyon US Organization ZHS 组织 13 80 :p_job LOV Oracle CST_SRS_PAC_AP_ENTITY_ID Y select wip_entity_id id, wip_entity_name value, null description from wip_entities where organization_id=:$flex$.cst_srs_pac_ap_org_by_cg order by wip_entity_name AR أمر شغل/جدول أمر شغل/جدول D Auftrag Auftrag E Orden de Fabricación/Programa Orden de Fabricación/Programa F OF/Programme OF/Programme I OdL/programma OdL/programma JA 製造オーダー 製造オーダー KO 작업/스케줄 작업/스케줄 PTB Ordem Prod./Program. Ordem Prod./Program. RU Задание/график Задание/график S TO/plan TO/plan TR İş Emri/Çizelge İş Emri/Çizelge US Job/Schedule Job/Schedule ZHS 任务/计划 任务/计划 14 90 :p_line LOV Oracle CST_SRS_PAC_AP_LINE_ID Y select line_id id, line_code value, null description from wip_lines where organization_id=:$flex$.cst_srs_pac_ap_org_by_cg and nvl(disable_date,sysdate+1)>sysdate order by line_code AR السطر السطر D Linie Linie E Línea Línea F Ligne Ligne I Linea Linea JA 明細 明細 KO 라인 라인 PTB Linha Linha RU Линия Линия S Rad Rad TR Satır Satır US Line Line ZHS 生产线 生产线 15 100 :p_assembly_id Char AR المنتج المنتج D Baugruppe Baugruppe E Conjunto Conjunto F Produit Produit I Assieme Assieme JA 組立品 組立品 KO 조립품 조립품 PTB Montagem Montagem RU Сборка Сборка S Montering Montering TR Ürün Ürün US Assembly Assembly ZHS 装配件 装配件 16 110 :p_transaction_type LOV Oracle WIP_SRS_TRANSACTION_TYPES_OPT Y select lookup_code id, meaning value, null description from mfg_lookups where lookup_type='WIP_TRANSACTION_TYPE' and enabled_flag='Y' order by lookup_code AR نوع الحركة نوع الحركة D Transaktionsart Transaktionsart E Tipo de Transacción Tipo de Transacción F Type de mouvement Type de mouvement I Tipo di transazione Tipo di transazione JA 取引タイプ 取引タイプ KO 트랜잭션 유형 트랜잭션 유형 PTB Tipo de Transação Tipo de Transação RU Тип транзакции Тип транзакции S Transaktionstyp Transaktionstyp TR İşlem Tipi İşlem Tipi US Transaction Type Transaction Type ZHS 事务处理类型 事务处理类型 17 120 :p_department LOV Oracle CST_SRS_PAC_AP_DEPT_ID Y select department_id id, department_code value, null description from bom_departments where organization_id=:$flex$.cst_srs_pac_ap_org_by_cg and nvl(disable_date,sysdate+1)>sysdate order by department_code AR القسم القسم D Abteilung Abteilung E Departamento Departamento F Section Section I Reparto Reparto JA 部門 部門 KO 부서 부서 PTB Departamento Departamento RU Отдел Отдел S Avdelning Avdelning TR Departman Departman US Department Department ZHS 部门 部门 18 130 :p_activity LOV Oracle CST_SRS_PAC_AP_ACTIVITY_ID Y select activity_id id, activity value, description description from cst_activities where nvl(organization_id,:$flex$.cst_srs_pac_ap_org_by_cg) =:$flex$.cst_srs_pac_ap_org_by_cg and nvl(disable_date,sysdate+1)>sysdate order by activity AR النشاط النشاط D Prozess Prozess E Actividad Actividad F Activité Activité I Attività Attività JA 活動 活動 KO 활동 활동 PTB Atividade Atividade RU Операция Операция S Aktivitet Aktivitet TR Aktivite Aktivite US Activity Activity ZHS 活动 活动 19 140 :p_class_code LOV Oracle CST_SRS_PAC_AP_CLASS_CODE Y select class_code id, class_code value, description description from wip_accounting_classes where organization_id=:$flex$.cst_srs_pac_ap_org_by_cg and nvl(disable_date,sysdate+1)>sysdate order by class_code AR رمز الطبقة رمز الطبقة D Klassenschlüssel Klassenschlüssel E Código de Clase Código de Clase F Code classe Code classe I Codice classe Codice classe JA 区分コード 区分コード KO 분류 코드 분류 코드 PTB Código da Classe Código da Classe RU Код класса Код класса S Klasskod Klasskod TR Sınıf Kodu Sınıf Kodu US Class Code Class Code ZHS 分类代码 分类代码 20 150 :p_currency_code LOV Oracle CST_SRS_CURRENCY_CODE Y select currency_code id, currency_code value, description description from fnd_currencies_vl where trunc(nvl(start_date_active,sysdate-1))<sysdate and trunc(nvl(end_date_active,sysdate+1))>sysdate order by value,description SELECT gsob.currency_code FROM gl_sets_of_books gsob, cst_le_cost_types clct WHERE clct.cost_type_id = :$flex$.cost_type AND legal_entity = :$flex$.legal_entity AND gsob.set_of_books_id = clct.set_of_books_id Y AR العملة رمز العملة D Währung Währungsschlüssel E Divisa Código de divisa F Devise Code devise I Divisa Codice divisa JA 通貨 通貨コード KO 통화 통화 코드 PTB Moeda Código da moeda RU Валюта Код валюты S Valuta Valutakod TR Para Birimi Para Birimi kodu US Currency Currency code ZHS 币种 币种代码 21 160 :p_exchange_rate LOV Oracle CST_SRS_LE_EXCHANGE_RATE Y select actual_rate id, display_rate value, period description from cst_pac_gl_translation_view cpv,cst_le_cost_types clt where clt.legal_entity=:$flex$.cst_srs_pac_ap_le and clt.cost_type_id=:$flex$.cst_srs_pac_ct_proc and clt.set_of_books_id=cpv.set_of_books_id and cpv.currency_code=:$flex$.cst_srs_currency_code and cpv.inverse=:$flex$.cst_srs_inverse_rate and cpv.rate_type=:$flex$.cst_srs_rate_type order by cpv.period_year desc,cpv.period_num desc Y AR سعر الصرف سعر الصرف D Wechselkurs Wechselkurs E Tipo de Cambio Tipo de Cambio F Taux de change Taux de change I Tasso di cambio Tasso di cambio JA 換算レート 換算レート KO 환율 환율 PTB Taxa de Câmbio Taxa cambial RU Обменный курс Обменный курс S Växelkurs Växelkurs TR Döviz Kuru Döviz kuru US Exchange Rate Exchange rate ZHS 汇率 汇率 :$flex$.cost_type Cost Type Chart of Accounts ID :$flex$.cost_type Cost Type Currency :$flex$.cst_srs_currency_code Currency Exchange Rate :$flex$.cst_srs_inverse_rate CST_SRS_INVERSE_RATE Exchange Rate :$flex$.cst_srs_pac_ap_le Legal Entity Chart of Accounts ID :$flex$.cst_srs_pac_ap_le Legal Entity Cost Type :$flex$.cst_srs_pac_ap_le Legal Entity Exchange Rate :$flex$.cst_srs_pac_ap_le Legal Entity Organization Cost Group :$flex$.cst_srs_pac_ap_le Legal Entity Period :$flex$.cst_srs_pac_ap_org_by_cg Organization Activity :$flex$.cst_srs_pac_ap_org_by_cg Organization Class Code :$flex$.cst_srs_pac_ap_org_by_cg Organization Department :$flex$.cst_srs_pac_ap_org_by_cg Organization Job/Schedule :$flex$.cst_srs_pac_ap_org_by_cg Organization Line :$flex$.cst_srs_pac_cg_proc Organization Cost Group Organization :$flex$.cst_srs_pac_cg_proc Organization Cost Group Period :$flex$.cst_srs_pac_ct_proc Cost Type Chart of Accounts ID :$flex$.cst_srs_pac_ct_proc Cost Type Exchange Rate :$flex$.cst_srs_pac_ct_proc Cost Type Organization Cost Group :$flex$.cst_srs_pac_ct_proc Cost Type Period :$flex$.cst_srs_rate_type CST_SRS_RATE_TYPE Exchange Rate :$flex$.legal_entity Legal Entity Chart of Accounts ID :$flex$.legal_entity Legal Entity Currency :$flex$.organization_cost_group Organization Cost Group Master Organization ID