FA Calendar Listing - draft

Description
Categories: BI Publisher
Application: Assets
Source: Calendar Listing (XML) - Not Supported: Reserved For Future Use
Short Name: FASLSCAL_XML
DB package: FA_FASLSCAL_XMLP_PKG
SELECT 	
	CP.Period_Num			       Period_Num,
	CP.Period_Name			       Period_Name,
	to_char(CP.Start_Date, 'DD-MON-YYYY')      Period_Start,
	to_char(CP.End_Date, 'DD-MON-YYYY')	       Period_End,
                  cp.calendar_type
FROM	
	FA_CALENDAR_PERIODS CP
WHERE 	
	CP.START_DATE >= :START_DATE  AND
	CP.START_DATE < :END_DATE 
 and cp.calendar_type=:cal_type
ORDER By CP.PERIOD_NUM
Parameter Name SQL text Validation
Fiscal Year
 
LOV Oracle
Fiscal Year Name
 
LOV Oracle
Ask a question