GL Other - Recurring Formula Listing

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Other - Recurring Formula Listing (XML)
Short Name: GLXRLRFL_XML
DB package: GL_GLXRLRFL_XMLP_PKG
select 
  decode(grlcr.amount, NULL, null, NULL)	FLEX_2_DATA_ALL,
  decode(grlcr.amount, NULL, null, NULL)	FLEX_2_DATA_ALL_GLLE,
  --grlcr.recurring_header_id  HEADER_ID,
  grlcr.recurring_header_id  HEADER_ID2,
  --grlcr.recurring_line_num  LINE_NUM,
  grlcr.recurring_line_num  LINE_NUM1,
  grlcr.rule_num  RULE_NUM,
  grlcr.amount  AMOUNT,
  gl1.description  TYPE,
  gl2.meaning  AMOUNT_TYPE,
  grlcr.ledger_currency CURRENCY_CODE,
  grlcr.entered_currency ENTERED_CURRENCY,
  decode (grlcr.currency_type , 'E',gl5.description,   	  	             'S',gl6.description,    		             'T',gl7.description,     	                               'C',gl8.description ) CURRENCY_TYPE,      gl4.meaning  PERIOD,
  grlcr.operator  OPERATOR
--, decode(:BATCH_TYPE_CODE, 'S', fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_2_field_all', 'SQLGL', 'GL#', gcc1.CHART_OF_ACCOUNTS_ID, NULL, gcc1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE'), fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_2_field_all_glle', 'SQLGL', 'GLLE', CHART_OF_ACCOUNTS_ID, NULL, CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE')) FLEX_2_FIELD_ALL
  --, 
	--fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_2_field_all', 'SQLGL', 'GL#', gcc1.CHART_OF_ACCOUNTS_ID, NULL, gcc1.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_2_FIELD_ALL
from
  gl_recurring_line_calc_rules  grlcr,
  gl_lookups  gl1,
  gl_lookups  gl2,
  gl_lookups  gl4,
  gl_lookups  gl5,     
  gl_lookups  gl6,  
  gl_lookups  gl7,
  gl_lookups  gl8,
  gl_ledger_relationships lr
where
  gl1.lookup_type (+) = 'BATCH_TYPE'
  and gl1.lookup_code (+) = grlcr.actual_flag
  and gl2.lookup_type (+) =   decode( grlcr.amount_type,
          			'PTD',  'PTD_YTD',         			
         		 	'YTD',   'PTD_YTD',
          			'PATD', 'PATD_EOD',
          			'YATD', 'PATD_EOD',
          			'EOD',  'PATD_EOD',
          			'' )
  and gl2.lookup_code(+) = grlcr.amount_type
  and gl4.lookup_type (+) = 'PERIOD CODE'
  and gl4.lookup_code (+) = grlcr.relative_period_code
  and gl5.lookup_code = 'E'    
  and gl5.lookup_type = 'GL_CURRENCY_TYPE'
  and gl6.lookup_code ='S'
  and  gl6.lookup_type = 'GL_CURRENCY_TYPE'
  and gl7.lookup_code = 'T'
  and gl7.lookup_type = 'GL_CURRENCY_TYPE'
  and gl8.lookup_code ='C'
  and gl8.lookup_type = 'GL_CURRENCY_TYPE'
  and lr.source_ledger_id (+) = grlcr.ledger_id
  and lr.target_ledger_id (+) = grlcr.ledger_id
  and lr.target_currency_code (+) = grlcr.ledger_currency
  and lr.application_id (+) = 101 
 and grlcr.recurring_header_id=:HEADER_ID1 
 and grlcr.recurring_line_num=:LINE_NUM
order by
  grlcr.rule_num
Parameter Name SQL text Validation
Accounted Period Type
 
Period Set Name
 
Chart of Accounts Id
 
Number
Batch Name
 
LOV Oracle
Ask a question