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 |
