ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0DB3869E053B46B63588994 Select DISTINCT rownum, a.customer_trx_id, a.excise_invoice_no, a.customer_trx_line_id, a.inventory_item_id, a.payment_register, a.description, a.quantity, a.unit_code, a.unit_selling_price, a.line_amount, a.auto_invoice_flag, a.assessable_value, a.EXCISE_EXEMPT_TYPE, JA_JAINVAR_XMLP_PKG.cf_22formula(:CUSTOMER_TRX_ID1, JA_JAINVAR_XMLP_PKG.cf_20formula(a.customer_trx_id, a.customer_trx_line_id, a.auto_invoice_flag, a.unit_selling_price)) CF_22, JA_JAINVAR_XMLP_PKG.cf_23formula(:CUSTOMER_TRX_ID1, JA_JAINVAR_XMLP_PKG.cf_21formula(a.auto_invoice_flag, a.quantity, JA_JAINVAR_XMLP_PKG.cf_20formula(a.customer_trx_id, a.customer_trx_line_id, a.auto_invoice_flag, a.unit_selling_price), a.line_amount)) CF_23, JA_JAINVAR_XMLP_PKG.cf_17formula(:EXCISE_INVOICE_NO, JA_JAINVAR_XMLP_PKG.cf_4formula(a.customer_trx_line_id), a.customer_trx_id, a.customer_trx_line_id, a.auto_invoice_flag, a.inventory_item_id, a.payment_register) CF_17, JA_JAINVAR_XMLP_PKG.cf_1formula(a.customer_trx_id, a.customer_trx_line_id, :EXCISE_INVOICE_NO, JA_JAINVAR_XMLP_PKG.cf_4formula(a.customer_trx_line_id), a.auto_invoice_flag, a.inventory_item_id, a.payment_register) CF_1, JA_JAINVAR_XMLP_PKG.cf_12formula(a.customer_trx_line_id) CF_12, JA_JAINVAR_XMLP_PKG.cf_11formula(a.customer_trx_line_id) CF_11, JA_JAINVAR_XMLP_PKG.cf_10formula(a.customer_trx_line_id) CF_10, JA_JAINVAR_XMLP_PKG.cf_9formula(a.customer_trx_line_id) CF_9, JA_JAINVAR_XMLP_PKG.cf_8formula(a.customer_trx_line_id) CF_8, JA_JAINVAR_XMLP_PKG.cf_16formula(a.customer_trx_line_id) CF_16, JA_JAINVAR_XMLP_PKG.cf_15formula(a.customer_trx_line_id) CF_15, JA_JAINVAR_XMLP_PKG.cf_14formula(a.customer_trx_line_id) CF_14, JA_JAINVAR_XMLP_PKG.cf_13formula(a.customer_trx_line_id) CF_13, JA_JAINVAR_XMLP_PKG.cf_6formula(:EXCISE_INVOICE_NO, a.inventory_item_id, a.payment_register) CF_6, JA_JAINVAR_XMLP_PKG.cf_5formula(:EXCISE_INVOICE_NO, a.inventory_item_id, a.payment_register) CF_5, JA_JAINVAR_XMLP_PKG.cf_4formula(a.customer_trx_line_id) CF_4, JA_JAINVAR_XMLP_PKG.cf_7formula(a.customer_trx_line_id) CF_7, JA_JAINVAR_XMLP_PKG.cf_20formula(a.customer_trx_id, a.customer_trx_line_id, a.auto_invoice_flag, a.unit_selling_price) CF_20, JA_JAINVAR_XMLP_PKG.cf_21formula(a.auto_invoice_flag, a.quantity, JA_JAINVAR_XMLP_PKG.cf_20formula(a.customer_trx_id, a.customer_trx_line_id, a.auto_invoice_flag, a.unit_selling_price), a.line_amount) CF_21, JA_JAINVAR_XMLP_PKG.conv_assessableformula(a.customer_trx_id, a.customer_trx_line_id, :CUSTOMER_TRX_ID1, a.auto_invoice_flag, a.assessable_value) conv_assessable, JA_JAINVAR_XMLP_PKG.tot_assessable_valueformula(JA_JAINVAR_XMLP_PKG.conv_assessableformula(a.customer_trx_id, a.customer_trx_line_id, :CUSTOMER_TRX_ID1, a.auto_invoice_flag, a.assessable_value), a.quantity) tot_assessable_value, JA_JAINVAR_XMLP_PKG.addl_rateformula(a.customer_trx_line_id) Addl_rate, JA_JAINVAR_XMLP_PKG.basic_rateformula(a.customer_trx_line_id) basic_rate, JA_JAINVAR_XMLP_PKG.special_rateformula(a.customer_trx_line_id) special_rate, JA_JAINVAR_XMLP_PKG.item_code_idformula(a.customer_trx_id, a.customer_trx_line_id, a.auto_invoice_flag, a.inventory_item_id) item_code_id, JA_JAINVAR_XMLP_PKG.item_codeformula(:item_code_id, :ORGANIZATION_ID) item_code, JA_JAINVAR_XMLP_PKG.cf_24formula(:ORGANIZATION_ID, :LOCATION_ID, a.customer_trx_line_id, a.inventory_item_id, a.EXCISE_EXEMPT_TYPE, a.quantity, a.unit_selling_price) modvat_amount From JAI_AR_TRX_LINES a where a.customer_trx_id=:customer_trx_id1 JA JAINVAR_XML US JA India - Commerical Invoice For AR - draft Application: Asia/Pacific Localizations Source: India - Commerical Invoice For AR (XML) - Not Supported: Reserved For Future Use Short Name: JAINVAR_XML DB package: JA_JAINVAR_XMLP_PKG ZHS JA 印度 - AR 商业发票- 不支持：已保留供将来使用 Application: 亚太地区本地化 Source: 印度 - AR 商业发票 (XML) - 不支持：已保留供将来使用 Short Name: JAINVAR_XML DB package: JA_JAINVAR_XMLP_PKG BI Publisher :customer_trx_id1 :excise_invoice_no :item_code_id :location_id :organization_id :p_conc_request_id :pf_trx_number 1 10 :pf_trx_number LOV Oracle TRX_NO_VAR Y select trx_number id, trx_number value, null description from jai_ar_trxs where once_completed_flag='Y' order by value,description US AR Invoice No ZHS AR 发票编号