org.compiere.sqlj
Class Product

java.lang.Object
  org.compiere.sqlj.Product

public class Product
extends Object

SQLJ Product related Functions

Version:

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

Author:

Jorg Janke

Constructor Summary

Product()

Method Summary

static String	attributeName(int p_M_AttributeSetInstance_ID) Get Product Attribute Instance Name.
static BigDecimal	bomPriceLimit(int p_M_Product_ID, int p_M_PriceList_Version_ID) Get BOM Price Limit Previously: BOM_PriceLimit - Now: bomPriceLimit
static BigDecimal	bomPriceList(int p_M_Product_ID, int p_M_PriceList_Version_ID) Get BOM Price List Previously: BOM_PriceList - Now: bomPriceList
static BigDecimal	bomPriceStd(int p_M_Product_ID, int p_M_PriceList_Version_ID) Get BOM Price Std Previously: BOM_PriceStd - Now: bomPriceStd
static BigDecimal	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 BigDecimal	bomQtyAvailableASI(int p_M_Product_ID, int p_M_AttributeSetInstance_ID, int p_M_Warehouse_ID, int p_M_Locator_ID) Test
static BigDecimal	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 BigDecimal	bomQtyOnHandASI(int p_M_Product_ID, int p_M_AttributeSetInstance_ID, int p_M_Warehouse_ID, int p_M_Locator_ID)
static BigDecimal	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 BigDecimal	bomQtyOrderedASI(int p_M_Product_ID, int p_M_AttributeSetInstance_ID, int p_M_Warehouse_ID, int p_M_Locator_ID)
static BigDecimal	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
static BigDecimal	bomQtyReservedASI(int p_M_Product_ID, int p_M_AttributeSetInstance_ID, int p_M_Warehouse_ID, int p_M_Locator_ID)

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 BigDecimal 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 BigDecimal 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 BigDecimal 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 BigDecimal 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 BigDecimal 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 BigDecimal 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 BigDecimal 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

bomQtyAvailableASI

public static BigDecimal bomQtyAvailableASI(int p_M_Product_ID,
                                            int p_M_AttributeSetInstance_ID,
                                            int p_M_Warehouse_ID,
                                            int p_M_Locator_ID)
                                     throws SQLException

Test

Parameters:

args - public static void main (String[] args) { try { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Adempiere.s_type = Adempiere.TYPE_ORACLE; Adempiere.s_url = "jdbc:oracle:thin:@//dev1:1521/dev1.adempiere.org"; Adempiere.s_uid = "adempiere"; Adempiere.s_pwd = "adempiere"; // System.out.println(Product.bomQtyOnHand(p_M_Product_ID, 0, p_M_Locator_ID)); } catch (SQLException e) { e.printStackTrace(); } } // main /*

Throws:

SQLException

bomQtyOnHandASI

public static BigDecimal bomQtyOnHandASI(int p_M_Product_ID,
                                         int p_M_AttributeSetInstance_ID,
                                         int p_M_Warehouse_ID,
                                         int p_M_Locator_ID)
                                  throws SQLException

Throws:

SQLException

bomQtyOrderedASI

public static BigDecimal bomQtyOrderedASI(int p_M_Product_ID,
                                          int p_M_AttributeSetInstance_ID,
                                          int p_M_Warehouse_ID,
                                          int p_M_Locator_ID)
                                   throws SQLException

Throws:

SQLException

bomQtyReservedASI

public static BigDecimal bomQtyReservedASI(int p_M_Product_ID,
                                           int p_M_AttributeSetInstance_ID,
                                           int p_M_Warehouse_ID,
                                           int p_M_Locator_ID)
                                    throws SQLException

Throws:

SQLException