Reports2017-11-18T12:27:27+00:00

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
By continuing to use the site, you agree to the use of cookies. Accept