ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4704051A9E05362FB09050512 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 Y JA JAINBOER_XML US JA India - Boe Write Off Report- Not Supported: Reserved For Future Use 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 ZHS JA 印度 - BOE 注销报表- 不支持：已保留供将来使用 Imported from BI Publisher Description: 印度 - BOE 注销报表 Application: 亚太地区本地化 Source: 印度 - BOE 注销报表 (XML) - 不支持：已保留供将来使用 Short Name: JAINBOER_XML DB package: JA_JAINBOER_XMLP_PKG BI Publisher :p_boe_no :p_boe_type :p_chart_of_accounts_id :p_conc_request_id :p_end_date :p_end_date1 :p_flex_acc :p_legal_entity :p_start_date :p_start_date1 :p_temp_amt :p_temp_amt1 :p_temp_id 1 -20 :p_chart_of_accounts_id Number SELECT chart_of_accounts_id FROM gl_sets_of_books WHERE set_of_books_id = fnd_profile.value('GL_SET_OF_BKS_ID') US p_chart_of_accounts_id Chart Of Accounts Id ZHS p_chart_of_accounts_id 科目表标识 2 10 :p_boe_no LOV Oracle JA_IN_BOE_NO Y select boe_id id, boe_id value, null description from jai_cmn_boe_hdrs order by boe_id US BOE Number ZHS BOE 编号 3 20 :p_boe_type LOV Oracle JA_IN_BOE_TYPE Y select a.boe_type id, a.boe_type value, null description from jai_cmn_boe_hdrs a where (a.boe_type,a.rowid) in (select b.boe_type,max(b.rowid) from jai_cmn_boe_hdrs b group by b.boe_type) order by value,description US BOE Type ZHS BOE 类型 4 30 :p_start_date Date Y US From Date ZHS 自日期 5 40 :p_end_date Date Y US To Date ZHS 至日期