FA Unposted Mass Additions - draft
Description
Categories: BI Publisher
Application: Assets
Source: Unposted Mass Additions Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS833_XML
DB package: FA_FAS833_XMLP_PKG
Source: Unposted Mass Additions Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS833_XML
DB package: FA_FAS833_XMLP_PKG
Run
FA Unposted Mass Additions - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Book |
|
LOV Oracle |