ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F1A53869E053B46B63588994 SELECT AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ASSET_NUMBER, TH.TRANSACTION_HEADER_ID TRANSNUM, DECODE(TH.TRANSACTION_HEADER_ID, DH.TRANSACTION_HEADER_ID_IN,1, DH.TRANSACTION_HEADER_ID_OUT, 0) TO_FROM, /* &ACCT_FLEX_ACCT_SEG GL_ACCOUNT, &ACCT_FLEX_BAL_SEG COMP_CODE, &ACCT_FLEX_COST_SEG COST_CENTER, &LOC_FLEX_ALL_SEG LOCATION,*/ fnd_flex_xml_publisher_apis.process_kff_combination_1('d_gl_account', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') D_GL_ACCOUNT1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMP_CODE1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_center', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') D_COST_CENTER1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, LOC.LOCATION_ID, 'ALL', 'Y', 'VALUE') D_LOCATION1, TH.TRANSACTION_DATE_ENTERED START_DATE, dh.assigned_to assigned_to, ascc.code_combination_id ccid, SUM(CADJ.ADJUSTMENT_AMOUNT* DECODE(CADJ.DEBIT_CREDIT_FLAG,'CR',-1,'DR',1)) COST, 0 DEPRN_RESERVE, SUM(distinct DECODE(TH.TRANSACTION_HEADER_ID,DH.TRANSACTION_HEADER_ID_IN,1, DH.TRANSACTION_HEADER_ID_OUT,-1)*DH.UNITS_ASSIGNED) UNITS, FA_FAS430_XMLP_PKG.D_AS_COSTFormula D_RP_DATA_FOUND /*Unnecessary Code, Commented during DT Fix FROM, &ACCT_FLEX_ACCT_SEG GL_ACCOUNT, &ACCT_FLEX_BAL_SEG COMP_CODE, &ACCT_FLEX_COST_SEG COST_CENTER, &LOC_FLEX_ALL_SEG LOCATION, TH.TRANSACTION_DATE_ENTERED START_DATE, dh.assigned_to assigned_to, ascc.code_combination_id ccid, SUM(CADJ.ADJUSTMENT_AMOUNT* DECODE(CADJ.DEBIT_CREDIT_FLAG,'CR',-1,'DR',1)) COST, 0 DEPRN_RESERVE, SUM(distinct DECODE(TH.TRANSACTION_HEADER_ID,DH.TRANSACTION_HEADER_ID_IN,1, DH.TRANSACTION_HEADER_ID_OUT,-1)*DH.UNITS_ASSIGNED) UNITS End of Comment*/ FROM FA_LOCATIONS LOC, FA_ADDITIONS AD, GL_CODE_COMBINATIONS ASCC, FA_DISTRIBUTION_HISTORY DH, FA_TRANSACTION_HEADERS TH, FA_ADJUSTMENTS CADJ WHERE TH.BOOK_TYPE_CODE = :P_BOOK AND TH.TRANSACTION_TYPE_CODE = 'TRANSFER' AND TH.DATE_EFFECTIVE >= :PERIOD1_POD AND TH.DATE_EFFECTIVE <= :PERIOD1_PCD AND nvl(TH.MASS_REFERENCE_ID, 0) = NVL(:P_MASS_REF_ID, nvl(TH.MASS_REFERENCE_ID, 0)) AND (TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_IN OR TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_OUT) AND AD.ASSET_ID = TH.ASSET_ID AND LOC.LOCATION_ID = DH.LOCATION_ID AND ASCC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID AND CADJ.BOOK_TYPE_CODE = :P_BOOK AND CADJ.ASSET_ID = TH.ASSET_ID AND CADJ.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND CADJ.TRANSACTION_HEADER_ID = TH.TRANSACTION_HEADER_ID AND CADJ.SOURCE_TYPE_CODE = 'TRANSFER' AND CADJ.ADJUSTMENT_TYPE in ('COST','CIP COST') GROUP BY TH.TRANSACTION_HEADER_ID, DECODE(TH.TRANSACTION_HEADER_ID, DH.TRANSACTION_HEADER_ID_IN,1, DH.TRANSACTION_HEADER_ID_OUT, 0) , DH.DISTRIBUTION_ID, --DT Fix Changes /* &ACCT_FLEX_ACCT_SEG, &ACCT_FLEX_BAL_SEG, &ACCT_FLEX_COST_SEG, &LOC_FLEX_ALL_SEG,*/ fnd_flex_xml_publisher_apis.process_kff_combination_1('d_gl_account', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_center', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, LOC.LOCATION_ID, 'ALL', 'Y', 'VALUE'), --End of DT Fix Changes AD.ASSET_NUMBER, AD.DESCRIPTION, TH.TRANSACTION_DATE_ENTERED, DH.ASSIGNED_TO, ascc.code_combination_id UNION SELECT AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ASSET_NUMBER, TH.TRANSACTION_HEADER_ID TRANSNUM, DECODE(TH.TRANSACTION_HEADER_ID, DH.TRANSACTION_HEADER_ID_IN,1, DH.TRANSACTION_HEADER_ID_OUT, 0) TO_FROM, /* &ACCT_FLEX_ACCT_SEG GL_ACCOUNT, &ACCT_FLEX_BAL_SEG COMP_CODE, &ACCT_FLEX_COST_SEG COST_CENTER, &LOC_FLEX_ALL_SEG LOCATION,*/ fnd_flex_xml_publisher_apis.process_kff_combination_1('d_gl_account', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') D_GL_ACCOUNT1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMP_CODE1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_center', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE') D_COST_CENTER1, fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, LOC.LOCATION_ID, 'ALL', 'Y', 'VALUE') D_LOCATION1, TH.TRANSACTION_DATE_ENTERED START_DATE, dh.assigned_to assigned_to, ascc.code_combination_id ccid, 0 COST, SUM(NVL(RADJ.ADJUSTMENT_AMOUNT,0) * DECODE(NVL(RADJ.DEBIT_CREDIT_FLAG,'CR'),'CR',1,'DR',-1)) DEPRN_RESERVE, SUM(distinct DECODE(TH.TRANSACTION_HEADER_ID,DH.TRANSACTION_HEADER_ID_IN,1, DH.TRANSACTION_HEADER_ID_OUT,-1)*DH.UNITS_ASSIGNED) UNITS, FA_FAS430_XMLP_PKG.D_AS_COSTFormula D_RP_DATA_FOUND /* Unnecessary Code, commented during DT Fix FROM, &ACCT_FLEX_ACCT_SEG GL_ACCOUNT, &ACCT_FLEX_BAL_SEG COMP_CODE, &ACCT_FLEX_COST_SEG COST_CENTER, &LOC_FLEX_ALL_SEG LOCATION, TH.TRANSACTION_DATE_ENTERED START_DATE, dh.assigned_to assigned_to, ascc.code_combination_id ccid, 0 COST, SUM(NVL(RADJ.ADJUSTMENT_AMOUNT,0) * DECODE(NVL(RADJ.DEBIT_CREDIT_FLAG,'CR'),'CR',1,'DR',-1)) DEPRN_RESERVE, SUM(distinct DECODE(TH.TRANSACTION_HEADER_ID,DH.TRANSACTION_HEADER_ID_IN,1, DH.TRANSACTION_HEADER_ID_OUT,-1)*DH.UNITS_ASSIGNED) UNITS End of Comment*/ FROM FA_LOCATIONS LOC, FA_ADDITIONS AD, GL_CODE_COMBINATIONS ASCC, FA_DISTRIBUTION_HISTORY DH, FA_TRANSACTION_HEADERS TH, FA_ADJUSTMENTS RADJ WHERE TH.BOOK_TYPE_CODE = :P_BOOK AND TH.TRANSACTION_TYPE_CODE = 'TRANSFER' AND TH.DATE_EFFECTIVE >= :PERIOD1_POD AND TH.DATE_EFFECTIVE <= :PERIOD1_PCD AND nvl(TH.MASS_REFERENCE_ID, 0) = NVL(:P_MASS_REF_ID, nvl(TH.MASS_REFERENCE_ID, 0)) AND (TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_IN OR TH.TRANSACTION_HEADER_ID = DH.TRANSACTION_HEADER_ID_OUT) AND AD.ASSET_ID = TH.ASSET_ID AND LOC.LOCATION_ID = DH.LOCATION_ID AND ASCC.CODE_COMBINATION_ID = DH.CODE_COMBINATION_ID AND RADJ.BOOK_TYPE_CODE = :P_BOOK AND RADJ.ASSET_ID = TH.ASSET_ID AND RADJ.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND RADJ.SOURCE_TYPE_CODE = 'TRANSFER' AND RADJ.ADJUSTMENT_TYPE = 'RESERVE' AND RADJ.TRANSACTION_HEADER_ID = TH.TRANSACTION_HEADER_ID GROUP BY TH.TRANSACTION_HEADER_ID, DECODE(TH.TRANSACTION_HEADER_ID, DH.TRANSACTION_HEADER_ID_IN,1, DH.TRANSACTION_HEADER_ID_OUT, 0) , DH.DISTRIBUTION_ID, --DT Fix Start /* &ACCT_FLEX_ACCT_SEG, &ACCT_FLEX_BAL_SEG, &ACCT_FLEX_COST_SEG, &LOC_FLEX_ALL_SEG,*/ fnd_flex_xml_publisher_apis.process_kff_combination_1('d_gl_account', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('d_cost_center', 'SQLGL', 'GL#', ASCC.CHART_OF_ACCOUNTS_ID, NULL, ASCC.CODE_COMBINATION_ID, 'FA_COST_CTR', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('d_location', 'OFA', 'LOC#', 101, NULL, LOC.LOCATION_ID, 'ALL', 'Y', 'VALUE'), --End of DT Fix AD.ASSET_NUMBER, AD.DESCRIPTION, TH.TRANSACTION_DATE_ENTERED, DH.ASSIGNED_TO, ascc.code_combination_id --ORDER BY 1,2,3,4,5,6,7 ORDER BY 1,2,3,4,5,6,7,8,13, 9 , 10, 12, 11 Y OFA FAS430_XML AR FA تقرير تحويلات الأصول (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Application: الأصول Source: تقرير تحويلات الأصول (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل Short Name: FAS430_XML DB package: FA_FAS430_XMLP_PKG D FA Anlagenneuzuordnungen- Nicht unterstützt: Reserviert für zukünftige Verwendung Application: Anlagen Source: Anlagenneuzuordnungen (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung Short Name: FAS430_XML DB package: FA_FAS430_XMLP_PKG F FA Etat des transferts d'immobilisations- Non pris en charge : réservé pour une utilisation future Application: Assets Source: Etat des transferts d'immobilisations (XML) - Non pris en charge : réservé pour une utilisation future Short Name: FAS430_XML DB package: FA_FAS430_XMLP_PKG US FA Asset Transfers - draft Application: Assets Source: Asset Transfers Report (XML) - Not Supported: Reserved For Future Use Short Name: FAS430_XML DB package: FA_FAS430_XMLP_PKG ZHS FA 资产转移报表- 不支持：已保留供将来使用 Application: 资产 Source: 资产转移报表 (XML) - 不支持：已保留供将来使用 Short Name: FAS430_XML DB package: FA_FAS430_XMLP_PKG BI Publisher &acct_flex_acct_seg &acct_flex_bal_seg &acct_flex_cost_seg &loc_flex_all_seg :accounting_flex_structure :currency_code :p_book :p_conc_request_id :p_mass_ref_id :p_period1 :period1_pc :period1_pcd :period1_pod :rp_bal_aprompt :rp_cc_aprompt :rp_company_name :rp_currency_code :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_period1 LOV Oracle FA_PERIOD_NAME_CORP Y select period_name id, period_name value, null description from fa_deprn_periods where book_type_code=:$flex$.fa_corp_book and period_counter>(select min(dp2.period_counter) from fa_deprn_periods dp2 where dp2.book_type_code=:$flex$.fa_corp_book) order by period_counter Y AR الفترة D Periode F Période US Period ZHS 期间