JA India - Boe Write Off Report- Not Supported: Reserved For Future Use

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
Description: India-Boe Write Off Report
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
Run JA India - Boe Write Off Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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
BOE Number 
 
 LOV Oracle
BOE Type 
 
 LOV Oracle
From Date 
 
 Date
To Date 
 
 Date
Download
Related Blitz Reports
JA India - RG 23 D - draft JA India - ST Forms Customer - draft JA India - ARE1 Report- Not Supported: Reserved For Future Use JA India - TDS Prescribed Rate - draft JA India - TDS at Lower Rates - draft JA India - OSP Stock Register - draft JA India - AR3A Status - draft JA India - RG23C Part I Report - draft - draft JA India - RG23 Part II Report - draft - draft
Blitz Report™

Blitz Report™ provides multiple benefits:

Blitz Report™