FA Expensed Property - draft

Description
Categories: BI Publisher
Application: Assets
Source: Expensed Property Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASEXPRP_XML
DB package: FA_FASEXPRP_XMLP_PKG
SELECT nvl(&ACCT_FLEX_BAL_SEG, 'None')        comp_code,
       &CAT_FLEX_ALL_SEG                      CATEGORY,
       AD.ASSET_NUMBER                        ASSET_NUMBER,
       AD.DESCRIPTION                         DESCRIPTION,
       AD.SERIAL_NUMBER                       SERIAL_NUMBER,
       BOOKS.DATE_PLACED_IN_SERVICE   START_DATE,
       round(sum(books.cost * nvl(dh.units_assigned,ad.current_units)/
          ad.current_units), :PRECISION) cost, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') D_COMP_CODE, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') D_CATEGORY
FROM   FA_BOOKS                BOOKS,
       FA_ADDITIONS            AD,
       FA_CATEGORIES           CAT,
       FA_SYSTEM_CONTROLS      SC,
       fa_distribution_history dh,
       gl_code_combinations    dhcc
WHERE
    BOOKS.BOOK_TYPE_CODE = :P_BOOK AND
	BOOKS.TRANSACTION_HEADER_ID_OUT is NULL       AND
    BOOKS.CAPITALIZE_FLAG = 'NO'         and
    BOOKS.period_counter_fully_retired is null           
AND    
    AD.ASSET_ID           =  BOOKS.ASSET_ID    
AND
    CAT.CATEGORY_ID       =  AD.ASSET_CATEGORY_ID
and
    books.book_type_code  =  dh.book_type_code(+)  and
    books.asset_id        =  dh.asset_id(+)     and
    dh.date_ineffective   is null
and    
    dhcc.code_combination_id(+)    =  dh.code_combination_id
GROUP BY
    nvl(&ACCT_FLEX_BAL_SEG, 'None'),
    &CAT_FLEX_ALL_SEG,
    AD.ASSET_NUMBER,
    AD.DESCRIPTION,
    AD.SERIAL_NUMBER,
    BOOKS.DATE_PLACED_IN_SERVICE
	--added
	,fnd_flex_xml_publisher_apis.process_kff_combination_1('d_comp_code', 'SQLGL', 'GL#', dhcc.CHART_OF_ACCOUNTS_ID, NULL, dhcc.CODE_COMBINATION_ID, 'GL_BALANCING', 'Y', 'VALUE') , 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('d_category', 'OFA', 'CAT#', 101, NULL, cat.CATEGORY_ID, 'ALL', 'Y', 'VALUE') 
ORDER BY 1,2,3
Parameter Name SQL text Validation
Book
 
LOV Oracle
Ask a question