ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1C43869E053B46B63588994 SELECT --MA.BOOK_TYPE_CODE BOOK, MA.BOOK_TYPE_CODE BOOK2, MA.MASS_ADDITION_ID MASS_ADD_ID, decode (MA.ASSET_TYPE, 'CIP',CB.CIP_COST_ACCT, CB.ASSET_COST_ACCT) ASSET_ACCOUNT, MA.PAYABLES_BATCH_NAME PAYABLES_REFER, MA.INVOICE_NUMBER INVOICE_NUMBER, VEND.VENDOR_NAME VENDOR_NAME, MA.DESCRIPTION DESCRIPTION, /*decode(fama.deprn_expense_ccid, null, null, &ACCT_FLEX_ALL_SEG) GL_NUMBER,*/ decode(fama.deprn_expense_ccid, null, null,fnd_flex_xml_publisher_apis.process_kff_combination_1('d_gl_number', 'SQLGL', 'GL#', glcc.CHART_OF_ACCOUNTS_ID, NULL, glcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE')) D_GL_NUMBER1, MA.ASSET_NUMBER ASSET_NUMBER, MA.SUM_UNITS SUM_UNITS, MA.FIXED_ASSETS_UNITS FIXED_ASSETS_UNITS, (MA.FIXED_ASSETS_COST * FAMA.UNITS) COST, --fnd_flex_xml_publisher_apis.process_kff_combination_1('d_gl_number', 'SQLGL', 'GL#', glcc.CHART_OF_ACCOUNTS_ID, NULL, glcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') D_GL_NUMBER, FA_FAS823_XMLP_PKG.new_costformula(MA.SUM_UNITS, MA.MASS_ADDITION_ID, ( MA.FIXED_ASSETS_COST * FAMA.UNITS ), MA.FIXED_ASSETS_UNITS) NEW_COST --Added during DT Fixes ,FA_FAS823_XMLP_PKG.D_COSTFormula Temp_RP_DATA_FOUND --End of DT Fixes FROM FA_MASSADD_DISTRIBUTIONS FAMA, FA_MASS_ADDITIONS MA, PO_VENDORS VEND, GL_CODE_COMBINATIONS GLCC, FA_CATEGORY_BOOKS CB WHERE MA.BOOK_TYPE_CODE = :P_BOOK AND DECODE (MA.SPLIT_CODE, 'SP', MA.POSTING_STATUS, DECODE(MA.MERGED_CODE, 'MC', MA.POSTING_STATUS, MA.QUEUE_NAME)) = :P_STATUS AND VEND.VENDOR_ID (+) = MA.PO_VENDOR_ID AND FAMA.MASS_ADDITION_ID(+) = MA.MASS_ADDITION_ID AND GLCC.CODE_COMBINATION_ID (+) = FAMA.DEPRN_EXPENSE_CCID AND CB.BOOK_TYPE_CODE (+) = :P_BOOK AND CB.CATEGORY_ID (+) = MA.ASSET_CATEGORY_ID ORDER BY lpad (decode (MA.asset_type, 'CIP', CB.CIP_COST_ACCT, CB.ASSET_COST_ACCT), 25, 0), lpad (MA.PAYABLES_BATCH_NAME, 50, 0), lpad (MA.INVOICE_NUMBER, 15, 0), lpad (&ACCT_FLEX_ALL_SEG, 25, 0), MA.ASSET_NUMBER, MA.MASS_ADDITION_ID, 3, 10, 11, 1, 2, 4, 5, 6, 7, 8, 9, 12 OFA FAS823_XML AR FA تقرير موقف الإضافات المجمعة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير موقف الإضافات المجمعة (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS823_XML DB package: FA_FAS823_XMLP_PKG D FA Globale Zugänge - Status- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Globale Zugänge - Status (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS823_XML DB package: FA_FAS823_XMLP_PKG F FA Etat des acquisitions en haut volume par statut- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des acquisitions en haut volume par statut (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS823_XML DB package: FA_FAS823_XMLP_PKG US FA Mass Additions Status - draft Application: Assets Source: Mass Additions Status Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS823_XML DB package: FA_FAS823_XMLP_PKG ZHS FA 成批增加状态报表- 不支持：已保留供将来使用 Application: 资产 Source: 成批增加状态报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS823_XML DB package: FA_FAS823_XMLP_PKG BI Publisher &acct_flex_all_seg :accounting_flex_structure :currency_code :p_book :p_conc_request_id :p_min_precision :p_status :rp_company_name :rp_data_found :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 帐簿 2 20 :p_status LOV Oracle FA_QUEUE_NAME Y select lookup_code id, lookup_code value, meaning description from fa_lookups where lookup_type='QUEUE NAME' order by meaning Y AR اسم الطابور D Warteschlangenbezeichnung F Nom de la file d'attente US Queue Name ZHS 队列名