ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 31BB3FFFAF4D0AE7E06362FB0905F05C select distinct rma_lines.rma_number rma_num, rt.oe_order_line_id rma_line_id , NVL(rma_lines.rma_line_number, 1) rma_line_num, rt.creation_date rma_rcp_date, NVL(rt.attribute5, 'GOODS RETURN') rma_type , rt.subinventory subinventory_code, hp.party_number customer_number, hp.party_name customer_name, NVL(jrt.excise_invoice_no , jrh.excise_invoice_no ) excise_invoice_no , NVL(jrt.excise_invoice_date , jrh.excise_invoice_date ) excise_invoice_date , jai_om_rma_pkg.cal_excise_duty(rt.oe_order_line_id, rt.quantity) excise_duty_due , jrt.organization_id , jrt.location_id, JA_JAINEXCL_XMLP_PKG.cf_org_nameformula(jrt.organization_id) CF_org_name, JA_JAINEXCL_XMLP_PKG.cf_locformula(jrt.location_id) CF_loc, JA_JAINEXCL_XMLP_PKG.cf_sob_nameformula(jrt.organization_id) CF_sob_name, JA_JAINEXCL_XMLP_PKG.cf_1formula(rt.oe_order_line_id, NVL ( jrt.excise_invoice_no , jrh.excise_invoice_no ), NVL ( jrt.excise_invoice_date , jrh.excise_invoice_date )) CF_cess_amount from jai_om_oe_rma_lines rma_lines, rcv_transactions rt , hz_parties hp , hz_cust_accounts hca , jai_rcv_headers jrh , jai_rcv_transactions jrt , oe_order_lines_all sl , oe_order_headers_all soh where soh.order_number = rma_lines.rma_number AND sl.header_id = soh.header_id AND soh.sold_to_org_id = hca.cust_account_id AND hca. party_id = hp.party_id and rma_lines.rma_header_id = rt.oe_order_header_id and rma_lines.rma_line_id = rt.oe_order_line_id AND rt.transaction_id = jrt.transaction_id AND jrt.shipment_header_id = jrh.shipment_header_id AND rma_lines.rma_number = NVL(:p_rma_no, rma_lines.rma_number) AND TRUNC(rt.creation_date) BETWEEN NVL(TRUNC(:p_start_date), TRUNC(rt.creation_date)) AND NVL(TRUNC(:p_end_date), TRUNC(rt.creation_date)) AND hca.cust_account_id = NVL(:p_customer_id, hca.cust_account_id) AND hp.party_number = NVL(:p_customer_no, hp.party_number) AND jai_om_rma_pkg.cal_excise_duty(rt.oe_order_line_id, rt.quantity) is not null ORDER BY 12 ASC,13 ASC JA JAINEXCL_XML US JA India - Excise Duty Claim For RMA Receipts Imported from BI Publisher Description: Excise Duty Claim For RMA Receipts - India Loc al Application: Asia/Pacific Localizations Source: India - Excise Duty Claim For RMA Receipts (XML) - Not Supported: Reserved For Future Use Short Name: JAINEXCL_XML DB package: JA_JAINEXCL_XMLP_PKG ZHS JA 印度 - RMA 接收的消费税申报- 不支持：已保留供将来使用 (1) Imported from BI Publisher Description: RMA 接收的消费税申报 - 印度本地 化 Application: 亚太地区本地化 Source: 印度 - RMA 接收的消费税申报 (XML) - 不支持：已保留供将来使用 Short Name: JAINEXCL_XML DB package: JA_JAINEXCL_XMLP_PKG India Localization 1=1 :p_conc_request_id :p_customer_id :p_customer_no :p_end_date :p_end_date_t :p_rma_no :p_start_date :p_start_date_t 1 -10 :debugflag Char N US DebugFlag DebugFlag ZHS 调试标志 调试标志 2 10 :p_customer_id LOV Oracle JAI_CUST_NAME Y select hza.cust_account_id id, hz.party_name value, null description from hz_parties hz,hz_cust_accounts hza where hz.party_id=hza.party_id order by party_name US Customer Name ZHS 客户名称 3 20 :p_customer_no LOV Oracle JAI_CUST_NUM Y select hz.party_number id, hz.party_number value, null description from hz_parties hz order by hz.party_number US Customer Number ZHS 客户编号 4 30 :p_rma_no LOV Oracle JAI_RMA_NUM Y select a.rma_number id, a.rma_number value, null description from jai_om_oe_rma_lines a where (a.rma_number,a.rowid) in (select b.rma_number,max(b.rowid) from jai_om_oe_rma_lines b group by b.rma_number ) order by value,description US RMA Number ZHS RMA 编号 5 40 :p_start_date Date Y US Start Date ZHS 起始日期 6 50 :p_end_date Date Y US End Date ZHS 终止日期