FA Unposted Mass Additions - draft

Description
Categories: BI Publisher
Columns: Start Date, Period Name, Asset Account, Status, Vendor Number, Invoice Num, Line Number, Description, Cost, D Status ...
Application: Assets
Source: Unposted Mass Additions Report (XML) - Not Supported: Reserved For Future Use
Short Name: FAS833_XML
DB package: FA_FAS833_XMLP_PKG
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