FA Prorate Convention Listing - draft
Description
Categories: BI Publisher
Application: Assets
Source: Prorate Convention Listing Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASLSPRC_XML
DB package: FA_FASLSPRC_XMLP_PKG
Source: Prorate Convention Listing Report (XML) - Not Supported: Reserved For Future Use
Short Name: FASLSPRC_XML
DB package: FA_FASLSPRC_XMLP_PKG
Run
FA Prorate Convention Listing - draft and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT CT.PRORATE_CONVENTION_CODE PR_CODE, CT.DESCRIPTION DESCR, LU.MEANING DEPR_FLAG, CO.START_DATE CONV_START, CO.END_DATE CONV_END, CO.PRORATE_DATE PRO_DATE FROM FA_CONVENTIONS CO, FA_CONVENTION_TYPES CT, FA_FISCAL_YEAR FY, FA_LOOKUPS LU WHERE FY.FISCAL_YEAR = :P_FY_YEAR AND FY.FISCAL_YEAR_NAME = :P_FY_YEAR_NAME AND CO.START_DATE BETWEEN FY.START_DATE AND FY.END_DATE AND CO.PRORATE_CONVENTION_CODE = CT.PRORATE_CONVENTION_CODE AND LU.LOOKUP_TYPE = 'YESNO' AND LU.LOOKUP_CODE = CT.DEPR_WHEN_ACQUIRED_FLAG ORDER BY CT.PRORATE_CONVENTION_CODE, CO.START_DATE |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Fiscal Year Name |
|
LOV Oracle | |
Fiscal Year |
|
LOV Oracle |