org.compiere.sqlj
Class Manufacturing

java.lang.Object
  org.compiere.sqlj.Manufacturing

public class Manufacturing
extends Object

SQLJ Manufacturing related Functions

Version:

$Id: Manufacturing.java,v 1 2005/04/06 10:15:02 vj-cd Exp $

Author:

Victor Perez

Constructor Summary

Manufacturing()

Method Summary

static String

documentNo(int p_PP_MRP_ID) Get Order_ID for OrderType

Methods inherited from class java.lang.Object

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

Constructor Detail

Manufacturing

public Manufacturing()

Method Detail

documentNo

public static String documentNo(int p_PP_MRP_ID)
                         throws SQLException

Get Order_ID for OrderType. * Test: SELECT CASE WHEN mrp.OrderType = 'FTC' THEN (SELECT f.Name FROM M_Forecast f WHERE f.M_Forecast_ID=mrp.M_Forecast_ID) WHEN mrp.OrderType = 'POO' THEN (SELECT o.DocumentNo FROM C_Order o WHERE o.C_Order_ID=mrp.C_Order_ID) WHEN mrp.OrderType = 'DOO' THEN (SELECT o.DocumentNo FROM DD_Order o WHERE o.DD_Order_ID=mrp.DD_Order_ID) WHEN mrp.OrderType = 'SOO' THEN (SELECT o.DocumentNo FROM C_Order o WHERE o.C_Order_ID=mrp.C_Order_ID) WHEN mrp.OrderType = 'MOP' THEN (SELECT o.DocumentNo FROM PP_Order o WHERE o.PP_Order_ID=mrp.PP_Order_ID) WHEN mrp.OrderType = 'POR' THEN (SELECT r.DocumentNo FROM M_Requisition r WHERE r.M_Requisition_ID=mrp.M_Requisition_ID) END AS DocumentNo FROM PP_MRP mrp WHERE mrp.PP_MRP_ID=PP_MRP.PP_MRP_ID))

Parameters:

p_PP_MRP_ID -

Returns:

DocumentNo

Throws:

SQLException