[Home] [Help]
1: PACKAGE BODY MSC_GLOBAL_FORECASTING AS
2: /* $Header: MSCPHOGB.pls 120.11 2007/01/17 19:25:29 hulu ship $ */
3:
4: SYS_YES CONSTANT INTEGER := 1;
5: SYS_NO CONSTANT INTEGER := 2;
182: decode(list.number8, 6, to_char(forecast.inventory_item_id),
183: 2, nvl(to_char(forecast.ship_id),'-99'),
184: 3, nvl(to_char(forecast.bill_id),'-99'),
185: 10, nvl(forecast.demand_class,'-99'),
186: MSC_GLOBAL_FORECASTING.get_ship_to(
187: list.number8,
188: forecast.plan_id,
189: forecast.sales_order_id)) ship_to,
190: CONSUMED row_type,
209: decode(list.number8, 6, to_char(forecast.inventory_item_id),
210: 2, nvl(to_char(forecast.ship_id),'-99'),
211: 3, nvl(to_char(forecast.bill_id),'-99'),
212: 10, nvl(forecast.demand_class,'-99'),
213: MSC_GLOBAL_FORECASTING.get_ship_to(
214: list.number8,
215: forecast.plan_id,
216: forecast.sales_order_id)),
217: CONSUMED, CONSUMED_OFF,
1286:
1287: return '-1';
1288: END get_ship_to;
1289:
1290: END MSC_GLOBAL_FORECASTING;