ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471F551A9E05362FB09050512Y select DOCUMENT_NUM, DOC_HEADER_ID , V.LINE_NUM , V.DISTRIBUTION_NUM, DOC_DISTRIBUTION_ID, LEDGER_ID, DISTRIBUTION_TYPE, ACTIVITY_AMOUNT, ACTIVITY_QUANTITY, GL_PERIOD, ENCUMBRANCE_TYPE_ID, SHIPMENT_NUM, SUPPLIER_NAME, REQUISION_CREATE_BY, REQUESTOR, REQUISITION_NUM, BUYER, APPROVED_DATE, APPROVAL_STATUS, ITEM_DESCRIPTION, LINE_TYPE, QUANTITY_ORDERED , QUANTITY_DELIVERED , QUANTITY_BILLED, QUANTITY_CANCELLED, AMOUNT_BILLED, AMOUNT_ORDERED, AMOUNT_DELIVERED, AMOUNT_CANCELLED , QUANTITY_DUE, AMOUNT_DUE, ENCUMBERED_AMOUNT, UOM, NVL(BEG_ACTIVITY_AMOUNT,0) BEG_ACTIVITY_AMT, (NVL(BEG_ACTIVITY_AMOUNT,0) + NVL(ACTIVITY_AMOUNT,0)) END_ACTIVITY_AMOUNT, e.distribution_ccid INFO_DIST_CCID FROM psa_enc_summary e, PO_PSA_POINFO_V v WHERE e.distribution_ccid = :distribution_ccid and &p_where4 and v.po_distribution_id = e.doc_distribution_id PSA PSAENCTBR AR PSA تقرير ميزان مراجعة تفاصيل الالتزام Imported from BI Publisher Application: ماليات القطاع العام Source: تقرير ميزان مراجعة تفاصيل الالتزام Short Name: PSAENCTBR DB package: psa_psaenctbr_pkg D PSA Summen/Saldenliste - Obligo - Details Imported from BI Publisher Application: Public Sector Financials Source: Summen/Saldenliste - Obligo - Details Short Name: PSAENCTBR DB package: psa_psaenctbr_pkg E PSA Iinforme de balance de comprobación de compromisos Imported from BI Publisher Application: Public Sector Financials Source: Iinforme de balance de comprobación de compromisos Short Name: PSAENCTBR DB package: psa_psaenctbr_pkg F PSA Etat détaillé Balance des engagements Imported from BI Publisher Application: Public Sector Financials Source: Etat détaillé Balance des engagements Short Name: PSAENCTBR DB package: psa_psaenctbr_pkg I PSA Rapporto Bilancio di verifica dettagli impegni Imported from BI Publisher Application: Public Sector Financials Source: Rapporto Bilancio di verifica dettagli impegni Short Name: PSAENCTBR DB package: psa_psaenctbr_pkg KO PSA 예산가집행 상세내역 시산표 보고서 Imported from BI Publisher Application: Public Sector Financials Source: 예산가집행 상세내역 시산표 보고서 Short Name: PSAENCTBR DB package: psa_psaenctbr_pkg PTB PSA Relatório de Balancete Detalhado de Empenho Imported from BI Publisher Application: Public Sector Financials Source: Relatório de Balancete Detalhado de Empenho Short Name: PSAENCTBR DB package: psa_psaenctbr_pkg US PSA Encumbrance Detail Trial Balance Imported from BI Publisher Application: Public Sector Financials Source: Encumbrance Detail Trial Balance Report Short Name: PSAENCTBR DB package: psa_psaenctbr_pkg BI Publisher &p_where4 :distribution_ccid :p_ccid_high :p_ccid_low :p_coa_id :p_dist_type :p_encumbrance_type :p_flex_range_where :p_ledger_id :p_period :p_report_by :p_report_col :p_where1 :p_where2 :p_where3 :p_where4 1 -10 :p_coa_id LOV Oracle PSA_SRS_COA_ID_BYLEDGER Y select chart_of_accounts_id id, chart_of_accounts_id value, null description from gl_ledgers_public_v where ledger_id=:$flex$.psa_ledger_name order by value,description SELECT CHART_OF_ACCOUNTS_ID FROM GL_LEDGERS WHERE LEDGER_ID = :$flex$.ledger Y AR PSA_SRS_COA_ID_BYLEDGER معرف جدول تصنيف الحسابات D PSA_SRS_COA_ID_BYLEDGER Kontenplankennung E PSA_SRS_COA_ID_BYLEDGER Id Plan de Cuentas F PSA_SRS_COA_ID_BYLEDGER ID plan de comptes I PSA_SRS_COA_ID_BYLEDGER ID piano dei conti KO PSA_SRS_COA_ID_BYLEDGER 계정 코드집 ID PTB PSA_SRS_COA_ID_BYLEDGER ID do plano de contas US PSA_SRS_COA_ID_BYLEDGER Chart of account id 2 10 :p_ledger_id LOV Oracle PSA_LEDGER_NAME Y select l.ledger_id id, l.name value, l.description description from gl_access_set_ledgers ac,gl_ledgers l where ac.access_set_id=fnd_profile.value('GL_ACCESS_SET_ID') and l.ledger_id=ac.ledger_id order by l.name select DEFAULT_LEDGER_NAME from gl_access_sets_v where ACCESS_SET_ID = fnd_profile.value('GL_ACCESS_SET_ID') Y AR الأستاذ معرف الأستاذ D Buch Buchkennung E Libro Mayor Identificador de libro mayor F Livre ID livre I Libro contabile Id del libro contabile KO 원장 원장 ID PTB Razão ID do Razão US Ledger Ledger Id 3 20 :p_period LOV Oracle PSA_ENC_TB_PERIODS Y select period_name id, period_name value, null description from psa_enc_periods where status='ACTIVE' and ledger_id=:$flex$.psa_ledger_name order by effective_period_num Y AR الفترة الفترة D Periode Periode E Período Período F Période Période I Periodo Periodo KO 기간 기간 PTB Período Período US Period Period 4 30 :p_ccid_low Char Y AR الحساب من الحساب من D Konto: Von Konto: Von E De Cuenta De Cuenta F Compte - De Compte - De I Conto - Da Conto - Da KO 계정: 부터 계정: 부터 PTB Conta - De Conta - De US Account From Account From 5 40 :p_ccid_high Char Y AR حساب إلى حساب إلى D Konto: Bis Konto: Bis E A Cuenta A Cuenta F Compte - A Compte - A I Conto - A Conto - A KO 계정: 까지 계정: 까지 PTB Conta - Até Conta - Até US Account To Account To 6 50 :p_encumbrance_type LOV Oracle PSA_GL_ENCUM_TYPE_TB Y select encumbrance_type_id id, encumbrance_type value, null description from gl_encumbrance_types where enabled_flag='Y' and encumbrance_type_key in ('Commitment','Obligation') order by value,description Y AR نوع الالتزام نوع الالتزام D Obligoart Obligoart E Tipo de Compromiso Tipo de Compromiso F Type d'engagement Type d'engagement I Tipo di impegno Tipo di impegno KO 예산가집행 유형 예산가집행 유형 PTB Tipo de Empenho Tipo de Empenho US Encumbrance Type Encumbrance Type 7 60 :p_report_by LOV Oracle PSA_SEG_REPORT_BY Y select application_column_name id, segment_name value, null description from fnd_id_flex_segments where id_flex_num=:$flex$.psa_srs_coa_id_byledger and id_flex_code='GL#' and application_id=101 and enabled_flag='Y' order by value,description Y AR تجميع التقارير بواسطة إنشاء التقرير بواسطة المقطع D Auswertungsgruppierung Segment für Auswertungsgenerierung E Grupo de Informes por Informe generado por segmento F Etat regroupé par Etat généré par segment I Raggruppamento rapporto Rapporto generato per segmento KO 보고서 그룹핑 기준 세그먼트에서 생성된 보고서 PTB Relatar Grupo por Relatório gerado por segmento US Report Group By Report generated by segment