org.compiere.udf
Class Product

java.lang.Object
  COM.ibm.db2.app.UDF
      org.compiere.udf.Product

public class Product
extends COM.ibm.db2.app.UDF

SQLJ Product related Functions

Version:

$Id: Product.java,v 1.3 2006/07/30 00:59:07 jjanke Exp $

Author:

Jorg Janke

Field Summary

Fields inherited from class COM.ibm.db2.app.UDF

SQLUDF_FIRST_CALL, SQLUDF_NORMAL_CALL, SQLUDF_TF_CLOSE, SQLUDF_TF_FETCH, SQLUDF_TF_FINAL, SQLUDF_TF_FIRST, SQLUDF_TF_OPEN

Constructor Summary

Product()

Method Summary

static String	attributeName(int p_M_AttributeSetInstance_ID) Get Product Attribute Instance Name.
static double	bomPriceLimit(int p_M_Product_ID, int p_M_PriceList_Version_ID) Get BOM Price Limit Previously: BOM_PriceLimit - Now: bomPriceLimit
static double	bomPriceList(int p_M_Product_ID, int p_M_PriceList_Version_ID) Get BOM Price List Previously: BOM_PriceList - Now: bomPriceList
static double	bomPriceStd(int p_M_Product_ID, int p_M_PriceList_Version_ID) Get BOM Price Std Previously: BOM_PriceStd - Now: bomPriceStd
static double	bomQtyAvailable(int p_M_Product_ID, int p_M_Warehouse_ID, int p_M_Locator_ID) Get BOM Quantity Available Previously: BOM_Qty_Available - Now: bomQtyAvailable
static double	bomQtyOnHand(int p_M_Product_ID, int p_M_Warehouse_ID, int p_M_Locator_ID) Get BOM Quantity OnHand Previously: BOM_Qty_OnHand - Now: bomQtyOnHand
static double	bomQtyOrdered(int p_M_Product_ID, int p_M_Warehouse_ID, int p_M_Locator_ID) Get BOM Quantity Ordered Previously: BOM_Qty_Ordered - Now: bomQtyOrdered
static double	bomQtyReserved(int p_M_Product_ID, int p_M_Warehouse_ID, int p_M_Locator_ID) Get BOM Quantity Reserved Previously: BOM_Qty_Reserved - Now: bomQtyReserved

Methods inherited from class COM.ibm.db2.app.UDF

close, getCallType, getConnection, getDBapplid, getDBauthid, getDBcodepg, getDBcolname, getDBinfo, getDBname, getDBplatform, getDBprocid, getDBtbname, getDBtbschema, getDBver_rel, getFunctionName, getScratchpad, getSpecificName, isNull, needToSet, set, set, set, set, set, set, set, set, set, set, set, setCodepage, setScratchpad, setSQLmessage, setSQLstate

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Product

public Product()

Method Detail

attributeName

public static String attributeName(int p_M_AttributeSetInstance_ID)
                            throws SQLException

Get Product Attribute Instance Name. Previously: M_Attribute_Name - Now: productAttribute Test: SELECT M_Attribute_Name (M_AttributeSetInstance_ID) FROM M_InOutLine WHERE M_AttributeSetInstance_ID > 0 -- SELECT p.Name FROM C_InvoiceLine il LEFT OUTER JOIN M_Product p ON (il.M_Product_ID=p.M_Product_ID); SELECT p.Name || M_Attribute_Name (il.M_AttributeSetInstance_ID) FROM C_InvoiceLine il LEFT OUTER JOIN M_Product p ON (il.M_Product_ID=p.M_Product_ID);

Parameters:

p_M_AttributeSetInstance_ID - instance

Returns:

Name or ""

Throws:

SQLException

bomPriceLimit

public static double bomPriceLimit(int p_M_Product_ID,
                                   int p_M_PriceList_Version_ID)
                            throws SQLException

Get BOM Price Limit Previously: BOM_PriceLimit - Now: bomPriceLimit

Parameters:

p_M_Product_ID -

p_M_PriceList_Version_ID -

Returns:

Price Limit

Throws:

SQLException

bomPriceList

public static double bomPriceList(int p_M_Product_ID,
                                  int p_M_PriceList_Version_ID)
                           throws SQLException

Get BOM Price List Previously: BOM_PriceList - Now: bomPriceList

Parameters:

p_M_Product_ID -

p_M_PriceList_Version_ID -

Returns:

Price List

Throws:

SQLException

bomPriceStd

public static double bomPriceStd(int p_M_Product_ID,
                                 int p_M_PriceList_Version_ID)
                          throws SQLException

Get BOM Price Std Previously: BOM_PriceStd - Now: bomPriceStd

Parameters:

p_M_Product_ID -

p_M_PriceList_Version_ID -

Returns:

Price Std

Throws:

SQLException

bomQtyAvailable

public static double bomQtyAvailable(int p_M_Product_ID,
                                     int p_M_Warehouse_ID,
                                     int p_M_Locator_ID)
                              throws SQLException

Get BOM Quantity Available Previously: BOM_Qty_Available - Now: bomQtyAvailable

Parameters:

p_M_Product_ID - product

p_M_Warehouse_ID - warehouse

p_M_Locator_ID - locator

Returns:

Quantity Available

Throws:

SQLException

bomQtyOnHand

public static double bomQtyOnHand(int p_M_Product_ID,
                                  int p_M_Warehouse_ID,
                                  int p_M_Locator_ID)
                           throws SQLException

Get BOM Quantity OnHand Previously: BOM_Qty_OnHand - Now: bomQtyOnHand

Parameters:

p_M_Product_ID - product

p_M_Warehouse_ID - warehouse

p_M_Locator_ID - locator

Returns:

Quantity Available

Throws:

SQLException

bomQtyOrdered

public static double bomQtyOrdered(int p_M_Product_ID,
                                   int p_M_Warehouse_ID,
                                   int p_M_Locator_ID)
                            throws SQLException

Get BOM Quantity Ordered Previously: BOM_Qty_Ordered - Now: bomQtyOrdered

Parameters:

p_M_Product_ID - product

p_M_Warehouse_ID - warehouse

p_M_Locator_ID - locator

Returns:

Quantity Ordered

Throws:

SQLException

bomQtyReserved

public static double bomQtyReserved(int p_M_Product_ID,
                                    int p_M_Warehouse_ID,
                                    int p_M_Locator_ID)
                             throws SQLException

Get BOM Quantity Reserved Previously: BOM_Qty_Reserved - Now: bomQtyReserved

Parameters:

p_M_Product_ID - product

p_M_Warehouse_ID - warehouse

p_M_Locator_ID - locator

Returns:

Qyantity Reserved

Throws:

SQLException