ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1C93869E053B46B63588994 SELECT CP.START_DATE START_DATE, CP.PERIOD_NAME PERIOD_NAME, fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg', 'SQLGL', 'GL#', glcc.CHART_OF_ACCOUNTS_ID, NULL, glcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') ASSET_ACCOUNT, NVL(FALU.MEANING , ' A') STATUS, MA.VENDOR_NUMBER||' - '||POV.VENDOR_NAME VENDOR_NUMBER, MA.INVOICE_NUMBER INVOICE_NUM, ma.invoice_line_number||' - '||ma.ap_distribution_line_number LINE_NUMBER, MA.DESCRIPTION DESCRIPTION, MA.FIXED_ASSETS_COST COST, FA_FAS833_XMLP_PKG.d_statusformula(NVL ( FALU.MEANING , ' A' )) D_STATUS --Added during DT Fixes ,FA_FAS833_XMLP_PKG.D_COSTFormula Temp_RP_DATA_FOUND --End of DT Fixes FROM GL_CODE_COMBINATIONS GLCC, PO_VENDORS POV, FA_MASS_ADDITIONS MA, FA_SYSTEM_CONTROLS SC, FA_CALENDAR_PERIODS CP, FA_BOOK_CONTROLS BC, FA_LOOKUPS FALU WHERE BC.BOOK_TYPE_CODE = :P_BOOK AND MA.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND NVL(MA.POSTING_STATUS, ' A') not in ('POSTED','SPLIT') AND MA.ACCOUNTING_DATE >= CP.START_DATE AND MA.ACCOUNTING_DATE <= CP.END_DATE AND MA.PAYABLES_CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID AND MA.PO_VENDOR_ID = POV.VENDOR_ID(+) AND CP.CALENDAR_TYPE = BC.DEPRN_CALENDAR AND DECODE(MA.POSTING_STATUS , 'POST', DECODE(MA.ADD_TO_ASSET_ID, NULL, 'POST', 'ADD TO ASSET'), MA.POSTING_STATUS) = FALU.LOOKUP_CODE (+) AND FALU.LOOKUP_TYPE (+) = 'QUEUE NAME' ORDER BY CP.START_DATE, lpad(fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg', 'SQLGL', 'GL#', glcc.CHART_OF_ACCOUNTS_ID, NULL, glcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'),25,'0'), MA.POSTING_STATUS, POV.vendor_name, lpad(MA.INVOICE_NUMBER,15,'0'), ma.invoice_line_number||' - '||ma.ap_distribution_line_number OFA FAS833_XML AR FA تقرير الإضافات المجمعة غير المرحلة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير الإضافات المجمعة غير المرحلة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS833_XML DB package: FA_FAS833_XMLP_PKG D FA Globale Zugänge - nicht verbucht- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Globale Zugänge - nicht verbucht (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS833_XML DB package: FA_FAS833_XMLP_PKG F FA Etat des acquisitions en haut volume non imputées- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des acquisitions en haut volume non imputées (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS833_XML DB package: FA_FAS833_XMLP_PKG US FA Unposted Mass Additions - draft Application: Assets Source: Unposted Mass Additions Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS833_XML DB package: FA_FAS833_XMLP_PKG ZHS FA 未过帐的成批增加报表- 不支持：已保留供将来使用 Application: 资产 Source: 未过帐的成批增加报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS833_XML DB package: FA_FAS833_XMLP_PKG BI Publisher :accounting_flex_structure :currency_code :p_book :p_conc_request_id :p_min_precision :rp_company_name :rp_data_found :rp_report_name 1 10 :p_book LOV Oracle FA_BOOK_TYPE Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿