SELECT
CP.START_DATE START_DATE,
CP.PERIOD_NAME PERIOD_NAME,
fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg', 'SQLGL', 'GL#', glcc.CHART_OF_ACCOUNTS_ID, NULL, glcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE') ASSET_ACCOUNT,
NVL(FALU.MEANING , ' A') STATUS,
MA.VENDOR_NUMBER||' - '||POV.VENDOR_NAME VENDOR_NUMBER,
MA.INVOICE_NUMBER INVOICE_NUM,
ma.invoice_line_number||' - '||ma.ap_distribution_line_number LINE_NUMBER,
MA.DESCRIPTION DESCRIPTION,
MA.FIXED_ASSETS_COST COST,
FA_FAS833_XMLP_PKG.d_statusformula(NVL ( FALU.MEANING , ' A' )) D_STATUS
--Added during DT Fixes
,FA_FAS833_XMLP_PKG.D_COSTFormula Temp_RP_DATA_FOUND
--End of DT Fixes
FROM
GL_CODE_COMBINATIONS GLCC,
PO_VENDORS POV,
FA_MASS_ADDITIONS MA,
FA_SYSTEM_CONTROLS SC,
FA_CALENDAR_PERIODS CP,
FA_BOOK_CONTROLS BC,
FA_LOOKUPS FALU
WHERE
BC.BOOK_TYPE_CODE = :P_BOOK
AND
MA.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND
NVL(MA.POSTING_STATUS, ' A') not in ('POSTED','SPLIT') AND
MA.ACCOUNTING_DATE >= CP.START_DATE AND
MA.ACCOUNTING_DATE <= CP.END_DATE
AND
MA.PAYABLES_CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID AND
MA.PO_VENDOR_ID = POV.VENDOR_ID(+)
AND
CP.CALENDAR_TYPE = BC.DEPRN_CALENDAR
AND DECODE(MA.POSTING_STATUS , 'POST',
DECODE(MA.ADD_TO_ASSET_ID, NULL, 'POST', 'ADD TO ASSET'), MA.POSTING_STATUS) =
FALU.LOOKUP_CODE (+)
AND FALU.LOOKUP_TYPE (+) = 'QUEUE NAME'
ORDER BY
CP.START_DATE,
lpad(fnd_flex_xml_publisher_apis.process_kff_combination_1('acct_flex_acct_seg', 'SQLGL', 'GL#', glcc.CHART_OF_ACCOUNTS_ID, NULL, glcc.CODE_COMBINATION_ID, 'GL_ACCOUNT', 'Y', 'VALUE'),25,'0'),
MA.POSTING_STATUS,
POV.vendor_name,
lpad(MA.INVOICE_NUMBER,15,'0'),
ma.invoice_line_number||' - '||ma.ap_distribution_line_number |
