ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1C33869E053B46B63588994 SELECT to_char(SC.LAST_MASS_ADDITIONS) REQUEST, &ACCT_FLEX_BAL_SEG COMPANY, &ACCT_FLEX_ACCT_SEG ACCOUNT, &ACCT_FLEX_COST_SEG COST_CTR, FAMA.VENDOR_NUMBER||' - '|| PV.VENDOR_NAME VENDOR, FAMA.INVOICE_NUMBER INV, FAMA.INVOICE_LINE_NUMBER||' - '|| FAMA.AP_DISTRIBUTION_LINE_NUMBER LINE, FAMA.INVOICE_DATE ID, FAMA.PAYABLES_BATCH_NAME BAT, FAMA.DESCRIPTION DESCR, FAMA.FIXED_ASSETS_COST AMT, API.INVOICE_CURRENCY_CODE CURR_CODE, decode(APID.BASE_AMOUNT, Null,to_number(Null), APID.AMOUNT) BASE_AMT, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_company', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMPANY, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') D_ACCOUNT, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') D_COST_CTR FROM FA_MASS_ADDITIONS FAMA, GL_CODE_COMBINATIONS DHCC, PO_VENDORS PV, FA_SYSTEM_CONTROLS SC, AP_INVOICE_DISTRIBUTIONS_ALL APID, AP_INVOICES_ALL API WHERE FAMA.POSTING_STATUS in ('NEW', 'MERGED') AND FAMA.BOOK_TYPE_CODE = :P_BOOK AND FAMA.PAYABLES_CODE_COMBINATION_ID = DHCC.CODE_COMBINATION_ID AND PV.VENDOR_ID(+) = FAMA.PO_VENDOR_ID AND APID.INVOICE_DISTRIBUTION_ID = FAMA.INVOICE_DISTRIBUTION_ID AND API.INVOICE_ID = APID.INVOICE_ID AND SC.LAST_MASS_ADDITIONS = FAMA.CREATE_BATCH_ID AND FAMA.invoice_payment_id is null union SELECT to_char(SC.LAST_MASS_ADDITIONS) REQUEST, &ACCT_FLEX_BAL_SEG COMPANY, &ACCT_FLEX_ACCT_SEG ACCOUNT, &ACCT_FLEX_COST_SEG COST_CTR, FAMA.VENDOR_NUMBER||' - '|| PV.VENDOR_NAME VENDOR, FAMA.INVOICE_NUMBER INV, FAMA.INVOICE_LINE_NUMBER||' - '|| FAMA.AP_DISTRIBUTION_LINE_NUMBER LINE, FAMA.INVOICE_DATE ID, FAMA.PAYABLES_BATCH_NAME BAT, FAMA.DESCRIPTION DESCR, FAMA.FIXED_ASSETS_COST AMT, API.INVOICE_CURRENCY_CODE CURR_CODE, -1 * APHD.AMOUNT BASE_AMT, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_company', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMPANY, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_account', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') D_ACCOUNT, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_ctr', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') D_COST_CTR FROM FA_MASS_ADDITIONS FAMA, GL_CODE_COMBINATIONS DHCC, PO_VENDORS PV, FA_SYSTEM_CONTROLS SC, AP_INVOICES_ALL API, AP_PAYMENT_HIST_DISTS APHD WHERE FAMA.POSTING_STATUS in ( 'NEW', 'MERGED') AND FAMA.BOOK_TYPE_CODE = :p_book AND FAMA.PAYABLES_CODE_COMBINATION_ID = DHCC.CODE_COMBINATION_ID AND PV.VENDOR_ID(+) = FAMA.PO_VENDOR_ID AND API.INVOICE_ID = FAMA.INVOICE_ID AND APHD.INVOICE_PAYMENT_ID = FAMA.INVOICE_PAYMENT_ID AND APHD.PAY_DIST_LOOKUP_CODE = 'DISCOUNT' AND APHD.INVOICE_DISTRIBUTION_ID = FAMA.INVOICE_DISTRIBUTION_ID AND SC.LAST_MASS_ADDITIONS = FAMA.CREATE_BATCH_ID AND FAMA.invoice_payment_id is not null ORDER BY 12,2,3,4,5,6,7 Y OFA FAS822_XML AR FA تقرير تكوين الإضافات المجمعة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير تكوين الإضافات المجمعة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS822_XML DB package: FA_FAS822_XMLP_PKG D FA Globale Zugänge aus Oracle Kreditoren- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Globale Zugänge aus Oracle Kreditoren (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS822_XML DB package: FA_FAS822_XMLP_PKG F FA Etat de création d'acquisitions en haut volume- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat de création d'acquisitions en haut volume (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS822_XML DB package: FA_FAS822_XMLP_PKG US FA Mass Additions Create - draft Application: Assets Source: Mass Additions Create Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS822_XML DB package: FA_FAS822_XMLP_PKG ZHS FA 成批增加创建报表- 不支持：已保留供将来使用 Application: 资产 Source: 成批增加创建报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS822_XML DB package: FA_FAS822_XMLP_PKG BI Publisher &acct_flex_acct_seg &acct_flex_bal_seg &acct_flex_cost_seg :acct_bal_aprompt :acct_cc_aprompt :cat_maj_rprompt :p_book :p_conc_request_id :p_min_precision :rp_company_name :rp_report_name 1 10 :p_book LOV Oracle FA_CORP_BOOK Y select book_type_code id, book_type_code value, book_type_name description from fa_book_controls_sec where book_class='CORPORATE' order by book_type_code Y AR الدفتر D AfA-Buch F Livre US Book ZHS 帐簿