DBA Data[Home] [Help]

APPS.MSC_GLOBAL_FORECASTING dependencies on MSC_GLOBAL_FORECASTING

Line 1: PACKAGE BODY MSC_GLOBAL_FORECASTING AS

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;

Line 186: MSC_GLOBAL_FORECASTING.get_ship_to(

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,

Line 213: MSC_GLOBAL_FORECASTING.get_ship_to(

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,

Line 1290: END MSC_GLOBAL_FORECASTING;

1286:
1287: return '-1';
1288: END get_ship_to;
1289:
1290: END MSC_GLOBAL_FORECASTING;