JA India - Commerical Invoice For AR - draft

Description
Categories: BI Publisher
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
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
Parameter Name SQL text Validation
AR Invoice No
 
LOV Oracle