ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F26E3869E053B46B63588994 SELECT XE.EVENT_ID EVEN_ID, PRJ.SEGMENT1 PROJECT_NUMBER, PRJ.NAME PROJECT_NAME , CDL.EXPENDITURE_ITEM_ID TRANSACTION_NUMBER, CDL.LINE_NUM LINE_NUMBER, JC.USER_JE_CATEGORY_NAME JOURNAL_CATEGORY, EI.EXPENDITURE_ITEM_DATE TRANSACTION_DATE, XE.TRANSACTION_DATE GL_DATE, DECODE ( JC.EVENT_CLASS_CODE , 'BURDEN_COST' , CDL.ACCT_BURDENED_COST , CDL.ACCT_RAW_COST ) AMOUNT, LKP_EXC.MEANING EXCEPTION_REASON, XER.ENCODED_MSG ERROR_MSG, DECODE ( LINE_TYPE, 'R', NVL(CDL.PJI_SUMMARIZED_FLAG, 'Y'), Null) PJI_SUMM_FLG, XE.PROCESS_STATUS_CODE EVENT_STATUS FROM PA_PROJECTS_ALL PRJ, PA_COST_DISTRIBUTION_LINES CDL, XLA_EVENTS XE, XLA_EVENT_CLASS_ATTRS_FVL JC, PA_LOOKUPS LKP_EXC, XLA_ACCOUNTING_ERRORS XER, PA_EXPENDITURE_ITEMS_ALL EI, XLA_EVENT_TYPES_B XET WHERE XE.APPLICATION_ID = 275 AND XE.PROCESS_STATUS_CODE <> 'P' AND XER.EVENT_ID(+) = XE.EVENT_ID AND CDL.ACCT_EVENT_ID = XE.EVENT_ID AND EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID AND PRJ.PROJECT_ID = CDL.PROJECT_ID AND LKP_EXC.LOOKUP_TYPE = 'PROJECT EVENT ERRORS' AND NVL(:P_TRAN_TYPE, 'EXPENDITURES') = 'EXPENDITURES' AND XET.APPLICATION_ID = 275 AND XET.EVENT_TYPE_CODE = XE.EVENT_TYPE_CODE AND JC.APPLICATION_ID = 275 AND JC.EVENT_CLASS_CODE = XET.EVENT_CLASS_CODE AND ( ( :P_MODE = 'S' AND CDL.REQUEST_ID = :P_CONC_REQUEST_ID ) OR ( :P_MODE = 'R' AND XE.EVENT_DATE BETWEEN :P_FIRST_DATE AND :P_LAST_DATE ) ) AND LKP_EXC.LOOKUP_CODE = DECODE(XE.PROCESS_STATUS_CODE, 'U','UNPROCESSED' , 'D' ,'DRAFT' , 'ERROR' ) UNION ALL SELECT XE.EVENT_ID EVEN_ID, PRJ.SEGMENT1 PROJECT_NUMBER, PRJ.NAME PROJECT_NAME , CCDL.EXPENDITURE_ITEM_ID TRANSACTION_NUMBER, CCDL.LINE_NUM LINE_NUMBER, JC.USER_JE_CATEGORY_NAME JOURNAL_CATEGORY, EI.EXPENDITURE_ITEM_DATE TRANSACTION_DATE, XE.TRANSACTION_DATE GL_DATE, CCDL.AMOUNT AMOUNT, LKP_EXC.MEANING EXCEPTION_REASON, XER.ENCODED_MSG ERROR_MSG, NULL PJI_SUMM_FLG, XE.PROCESS_STATUS_CODE EVENT_STATUS FROM PA_PROJECTS_ALL PRJ, PA_CC_DIST_LINES CCDL, XLA_EVENTS XE, XLA_EVENT_CLASS_ATTRS_FVL JC, PA_LOOKUPS LKP_EXC, XLA_ACCOUNTING_ERRORS XER, PA_EXPENDITURE_ITEMS_ALL EI, XLA_EVENT_TYPES_B XET WHERE XE.APPLICATION_ID = 275 AND XE.PROCESS_STATUS_CODE <> 'P' AND XER.EVENT_ID(+) = XE.EVENT_ID AND CCDL.ACCT_EVENT_ID = XE.EVENT_ID AND EI.EXPENDITURE_ITEM_ID = CCDL.EXPENDITURE_ITEM_ID AND PRJ.PROJECT_ID = CCDL.PROJECT_ID AND JC.APPLICATION_ID = 275 AND JC.EVENT_CLASS_CODE = XET.EVENT_CLASS_CODE AND XET.APPLICATION_ID = 275 AND XET.EVENT_TYPE_CODE = XE.EVENT_TYPE_CODE AND LKP_EXC.LOOKUP_TYPE = 'PROJECT EVENT ERRORS' AND NVL(:P_TRAN_TYPE,'CROSSCHARGE') = 'CROSSCHARGE' AND ( ( :P_MODE = 'S' AND CCDL.REQUEST_ID = :P_CONC_REQUEST_ID ) OR ( :P_MODE = 'R' AND XE.EVENT_DATE BETWEEN :P_FIRST_DATE AND :P_LAST_DATE ) ) AND LKP_EXC.LOOKUP_CODE = DECODE(XE.PROCESS_STATUS_CODE, 'U','UNPROCESSED' , 'D' ,'DRAFT' , 'ERROR' ) UNION ALL SELECT XE.EVENT_ID EVEN_ID, PRJ.SEGMENT1 PROJECT_NUMBER, PRJ.NAME PROJECT_NAME , RDL.DRAFT_REVENUE_NUM TRANSACTION_NUMBER, NULL LINE_NUMBER, JC.USER_JE_CATEGORY_NAME JOURNAL_CATEGORY, RDL.ACCRUE_THROUGH_DATE TRANSACTION_DATE, XE.TRANSACTION_DATE GL_DATE, SUM(RI.AMOUNT) AMOUNT, LKP_EXC.MEANING EXCEPTION_REASON, XER.ENCODED_MSG ERROR_MSG, NULL PJI_SUMM_FLG, XE.PROCESS_STATUS_CODE EVENT_STATUS FROM PA_PROJECTS_ALL PRJ, PA_DRAFT_REVENUES RDL, PA_DRAFT_REVENUE_ITEMS RI , XLA_EVENTS XE, XLA_EVENT_CLASS_ATTRS_FVL JC, PA_LOOKUPS LKP_EXC, XLA_ACCOUNTING_ERRORS XER, XLA_EVENT_TYPES_B XET WHERE XE.PROCESS_STATUS_CODE <> 'P' AND XER.EVENT_ID(+) = XE.EVENT_ID AND RDL.EVENT_ID = XE.EVENT_ID AND PRJ.PROJECT_ID = RDL.PROJECT_ID AND RI.PROJECT_ID = RDL.PROJECT_ID AND RI.DRAFT_REVENUE_NUM = RDL.DRAFT_REVENUE_NUM AND JC.APPLICATION_ID = 275 AND JC.EVENT_CLASS_CODE = XET.EVENT_CLASS_CODE AND XET.APPLICATION_ID = 275 AND XET.EVENT_TYPE_CODE = XE.EVENT_TYPE_CODE AND LKP_EXC.LOOKUP_TYPE = 'PROJECT EVENT ERRORS' AND NVL(:P_TRAN_TYPE,'REVENUE') = 'REVENUE' AND ( ( :P_MODE = 'S' AND RDL.REQUEST_ID = :P_CONC_REQUEST_ID ) OR ( :P_MODE = 'R' AND XE.EVENT_DATE BETWEEN :P_FIRST_DATE AND :P_LAST_DATE ) ) AND LKP_EXC.LOOKUP_CODE = DECODE(XE.PROCESS_STATUS_CODE, 'U','UNPROCESSED' , 'D' ,'DRAFT' , 'ERROR' ) GROUP BY XE.EVENT_ID , PRJ.SEGMENT1 , PRJ.NAME , RDL.DRAFT_REVENUE_NUM , NULL , JC.USER_JE_CATEGORY_NAME , RDL.ACCRUE_THROUGH_DATE , XE.TRANSACTION_DATE , LKP_EXC.MEANING , XER.ENCODED_MSG , NULL , XE.PROCESS_STATUS_CODE ORDER BY JOURNAL_CATEGORY, TRANSACTION_NUMBER, LINE_NUMBER Y PA PACCGLER_XML AR PA تحويل الأحداث المحاسبية للحركة (بتنسيق XML) Application: المشروعات Source: PRC: تحويل الأحداث المحاسبية للحركة (بتنسيق XML) Short Name: PACCGLER_XML DB package: PA_PACCGLER_XMLP_PKG D PA Transaktionsbuchungsereignisse verschieben Application: Projects Source: PA: Transaktionsbuchungsereignisse verschieben (XML) Short Name: PACCGLER_XML DB package: PA_PACCGLER_XMLP_PKG F PA Transfert d'événements comptables Application: Projects Source: PRC : Transfert d'événements comptables (XML) Short Name: PACCGLER_XML DB package: PA_PACCGLER_XMLP_PKG US PA Sweep Transaction Accounting Events Application: Projects Source: PRC: Sweep Transaction Accounting Events (XML) Short Name: PACCGLER_XML DB package: PA_PACCGLER_XMLP_PKG ZHS PA PRC：转移事务处理会计事件 Application: 项目 Source: PRC：转移事务处理会计事件 (XML) Short Name: PACCGLER_XML DB package: PA_PACCGLER_XMLP_PKG BI Publisher :c_company_name_header :operating_unit :p_conc_request_id :p_debug_mode :p_first_date :p_gl_period :p_last_date :p_mode :p_org_id :p_sob_id :p_tran_type :p_user_id 1 10 :p_mode LOV Oracle PA_SRS_SWEEP_REVIEW_MODE Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='SWEEP_REVIEW_MODE' order by meaning R Y AR الطور D Modus US Mode ZHS 模式 2 20 :p_tran_type LOV Oracle PA_SRS_TYPE_OF_TRAN Y select lookup_code id, meaning value, null description from pa_lookups where lookup_type='PROJECT PROCESS ENTITIES' order by meaning AR نوع الحركة D Transaktionsart F Type de mouvement US Type of Transaction ZHS 事务处理类型 3 30 :p_gl_period LOV Oracle PA_SRS_CLOSE_GL_PERIODS Y select period_name id, period_name value, null description from gl_period_statuses where application_id=101 and nvl(adjustment_period_flag,'N')='N' and set_of_books_id=(select set_of_books_id from pa_implementations) and ((closing_status='C' and :$flex$.pa_srs_sweep_review_mode='S') or (1=1 and :$flex$.pa_srs_sweep_review_mode='R')) order by end_date desc Y AR اسم الفترة D Periodenbezeichnung F Nom de la période US Period Name ZHS 期间名称 :$flex$.pa_srs_sweep_review_mode Mode Period Name