GL Budget - Frozen Budgets Accounts Listing

Description

Imported from BI Publisher
Description: All frozen budgets. organizations and accounts
Application: General Ledger
Source: Budget - Frozen Budgets Accounts Listing (XML)
Short Name: GLXRLFBL_XML
DB package: GL_GLXRLFBL_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Copy

select 
  &FLEX_SELECT_ALL_LOW  FLEX_DATA_ALL_LOW,
  &FLEX_SELECT_ALL_HIGH  FLEX_DATA_ALL_HIGH,
  gbv.budget_name  BUDGET_NAME,
  gbv.status  STATUS,
  decode( gbv.status, 
          'F', gl1.meaning, 
               gl2.meaning )  FROZEN1,
  gbe.name  BUDGET_ORGANIZATION,
  geb.frozen_flag  FROZEN_FLAG,
  gl3.meaning  FROZEN2, 
	GL_GLXRLFBL_XMLP_PKG.flex_field_all_lowformula(:FLEX_FIELD_ALL_LOW) FLEX_FIELD_ALL_LOW, 
	GL_GLXRLFBL_XMLP_PKG.flex_field_all_highformula(:FLEX_FIELD_ALL_HIGH) FLEX_FIELD_ALL_HIGH
from   
  gl_lookups  gl1,
  gl_lookups  gl2,
  gl_lookups  gl3,
  gl_budget_frozen_ranges  gbfr,
  gl_entity_budgets  geb,
  gl_budget_entities  gbe,
  gl_budget_versions  gbv
where  
  gbe.ledger_id = :P_LEDGER_ID
  and gbe.budget_entity_id = geb.budget_entity_id
  and gbv.budget_version_id = geb.budget_version_id
  and gbfr.budget_version_id (+)  = geb.budget_version_id
  and gbfr.budget_entity_id (+)   = geb.budget_entity_id
  and gl1.lookup_type = 'YES/NO'
  and gl1.lookup_code = 'Y'
  and gl2.lookup_type = 'YES/NO'
  and gl2.lookup_code = 'N'
  and gl3.lookup_type(+) = 'YES/NO'
  and gl3.lookup_code(+) = geb.frozen_flag
order by
  gbv.budget_name,
  gbv.status,
  gbe.name,
  geb.frozen_flag