IGI Balanced Budget Journal Input Proforma- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: BUD: Budgeting: Balanced Budget Journal Input Proforma
Application: Public Sector Financials International
Source: Budgeting: Balanced Budget Journal Input Proforma (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBIPB_XML
DB package: IGI_IGIGBIPB_XMLP_PKG
Description: BUD: Budgeting: Balanced Budget Journal Input Proforma
Application: Public Sector Financials International
Source: Budgeting: Balanced Budget Journal Input Proforma (XML) - Not Supported: Reserved For Future Use
Short Name: IGIGBIPB_XML
DB package: IGI_IGIGBIPB_XMLP_PKG
Run
IGI Balanced Budget Journal Input Proforma- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT &P_FLEXDATA C_FLEXDATA, gl_ass.CODE_COMBINATION_ID CCID, gsob.NAME SOB_NAME, gl_ent.NAME ORG_NAME, defs.LATEST_PROFILE_CODE PROF_CODE, fnd_flex_xml_publisher_apis.process_kff_combination_1('cf_flexfield', 'SQLGL', 'GL#', gl_comb.CHART_OF_ACCOUNTS_ID, NULL, gl_comb.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') CF_FLEXFIELD FROM GL_CODE_COMBINATIONS gl_comb, GL_BUDGET_ASSIGNMENTS gl_ass, GL_SETS_OF_BOOKS gsob, GL_BUDGET_ENTITIES gl_ent, IGI_BUD_PROFILE_DEFAULTS defs, IGI_BUD_PROFILE_CODES codes, GL_LOOKUPS LK WHERE gl_ass.LEDGER_ID = :P_SOB_ID AND gl_ass.BUDGET_ENTITY_ID = :P_BUD_ENT_ID AND gl_ass.CURRENCY_CODE = :P_CURR AND gl_ass.CODE_COMBINATION_ID = gl_comb.CODE_COMBINATION_ID AND LK.LOOKUP_TYPE(+) = 'ACCOUNT TYPE' AND LK.LOOKUP_CODE(+) = gl_comb.ACCOUNT_TYPE AND gl_comb.DETAIL_BUDGETING_ALLOWED_FLAG = 'Y' AND gl_comb.SUMMARY_FLAG = 'N' AND gsob.SET_OF_BOOKS_ID = gl_ass.LEDGER_ID AND gl_comb.IGI_BALANCED_BUDGET_FLAG = 'Y' AND gl_ent.LEDGER_ID = gl_ass.LEDGER_ID AND gl_ent.BUDGET_ENTITY_ID = :P_BUD_ENT_ID AND defs.SET_OF_BOOKS_ID = gl_ass.LEDGER_ID AND defs.CODE_COMBINATION_ID = gl_ass.CODE_COMBINATION_ID AND defs.LATEST_PROFILE_CODE = codes.PROFILE_CODE AND defs.SET_OF_BOOKS_ID = codes.SET_OF_BOOKS_ID AND SYSDATE BETWEEN nvl(codes.START_DATE_ACTIVE, SYSDATE) AND nvl(codes.END_DATE_ACTIVE, SYSDATE+1) AND gl_comb.CHART_OF_ACCOUNTS_ID = :P_STRUCT_NUM ORDER BY 3, 2,1 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Ledger ID |
|
LOV Oracle | |
Currency Code ID |
|
LOV Oracle | |
Budget Entity ID |
|
LOV Oracle |