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 |
