[Home] [Help]
1563: , nvl(line_amount, 0) line_amount --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1564: , nvl(assessable_value,0)*nvl(quantity,0) assessable_value --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1565: , nvl(vat_assessable_value,0) vat_assessable_vale --Add by Kevin Cheng for inclusive tax Dec 12, 2007
1566: FROM
1567: JAI_OM_OE_SO_LINES
1568: WHERE line_id = p_line_id;
1569:
1570: CURSOR Fetch_Dtls1_Cur IS -- AR Side
1571: SELECT Quantity, Unit_Selling_Price, Unit_Code, Inventory_Item_Id