GL Other - Value Added Tax

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: Other - Value Added Tax (XML)
Short Name: GLXRLVAT_XML
DB package: GL_GLXRLVAT_XMLP_PKG
select
  null  FLEX_DATA_ALL,
  gjl.tax_code  TAX_CODE,
  gjl.invoice_date  INVOICE_DATE,
  gjl.invoice_identifier  INVOICE_NUMBER,
  gjl.entered_dr  RECEIPT_AMOUNT,
  gjl.entered_cr  PAYMENT_AMOUNT,
  gjl.invoice_amount  INVOICE_AMOUNT,
  gjb.name  BATCH_NAME, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1('flex_field_all', 'SQLGL', 'GL#', gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, 'ALL', 'Y', 'VALUE') FLEX_FIELD_ALL
from   
  gl_code_combinations  gcc,
  gl_je_batches  gjb,
  gl_je_headers  gjh,
  gl_je_lines  gjl
where
  gjl.period_name=:P_PERIOD_NAME
  and  gjl.tax_code = decode( :P_TAX_CODE,
  null, gjl.tax_code,:P_TAX_CODE )
  and  nvl( gjl.tax_code, ' ') <> ' '
  and  gjl.ledger_id =:P_LEDGER_ID
  and  gjh.je_header_id = gjl.je_header_id
  and  gjh.currency_code = :P_CURRENCY_CODE
  and  gjb.je_batch_id = gjh.je_batch_id
  and  gjb.status = 'P'
  and  gcc.code_combination_id = gjl.code_combination_id
  &WHERE_DAS
order by
  gjl.tax_code,
  gjl.invoice_date,
  gjl.invoice_identifier,
  &FLEX_ORDERBY_ALL
Parameter NameSQL textValidation
Access Set Id
 
Number
Tax Code
 
LOV Oracle
Currency
 
LOV Oracle
Period
 
LOV Oracle
Ledger
 
LOV Oracle