JA India - Boe Write Off - draft

Description
Categories: BI Publisher
Application: Asia/Pacific Localizations
Source: India - Boe Write Off Report (XML) - Not Supported: Reserved For Future Use
Short Name: JAINBOER_XML
DB package: JA_JAINBOER_XMLP_PKG
SELECT JCWT.boe_type,
              JCWT.boe_id,
              JCWT.boe_amount boe_amount,
             JCWT.amount_applied amount_applied,
             write_off_amount,
             write_off_date,
             write_off_reason,
             organization_name,
             organization_name hdr_org,
              location_code,
             customs_write_off_account,
              address_line_1,
             address_line_2,
              address_line_3,
              chart_of_accounts_id,
              earlier_written_off_amount, 
	JA_JAINBOER_XMLP_PKG.cf_accountformula(chart_of_accounts_id, customs_write_off_account) CF_account, 
	JA_JAINBOER_XMLP_PKG.cf_boe_closingformula(JCWT.boe_amount, JCWT.amount_applied, write_off_amount) CF_closing_amt, 
	JA_JAINBOER_XMLP_PKG.cf_temp_calformula(JCWT.boe_id, write_off_amount) CF_temp_cal
FROM  JAI_CMN_WRITEOFFS_T JCWT
, JAI_CMN_BOE_HDRS JCBH
WHERE  JCWT.boe_id = JCBH.boe_id
ORDER BY customs_write_off_account,address_line_1,address_line_2,address_line_3,organization_name,chart_of_accounts_id, boe_amount,location_code,hdr_org, amount_applied,write_off_amount,write_off_reason, earlier_written_off_amount,boe_id,write_off_date,boe_type
Parameter Name SQL text Validation
p_chart_of_accounts_id
 
Number
To Date
 
Date
From Date
 
Date
BOE Type
 
LOV Oracle
BOE Number
 
LOV Oracle