DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on STANDARD

Line 2558: -- either forecast or schedule inputs or if the item type is 'Standard'

2554: -- we need to set the flags
2555: -- l_explode_always and l_sales_order_demand.
2556: -- Setting l_sales_order demand is very straight forward.
2557: -- l_explode_always is set to TRUE if the demand_type is Manual for
2558: -- either forecast or schedule inputs or if the item type is 'Standard'
2559:
2560: l_sales_order_demand := 'N';
2561:
2562: -- check to see if we are dealing with a standard item

Line 2562: -- check to see if we are dealing with a standard item

2558: -- either forecast or schedule inputs or if the item type is 'Standard'
2559:
2560: l_sales_order_demand := 'N';
2561:
2562: -- check to see if we are dealing with a standard item
2563: SELECT bom_item_type,
2564: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
2565: INTO l_bom_item_type,
2566: l_foq

Line 2807: -- check to see if we are dealing with a standard item

2803: -- Setting l_sales_order demand is very straight forward.
2804:
2805: l_sales_order_demand := 'N';
2806:
2807: -- check to see if we are dealing with a standard item
2808: SELECT bom_item_type,
2809: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
2810: INTO l_bom_item_type,
2811: l_foq

Line 3043: -- either forecast or schedule inputs or if the item type is 'Standard'

3039: -- we need to set the flags
3040: -- l_explode_always and l_sales_order_demand.
3041: -- Setting l_sales_order demand is very straight forward.
3042: -- l_explode_always is set to TRUE if the demand_type is Manual for
3043: -- either forecast or schedule inputs or if the item type is 'Standard'
3044:
3045: IF ((g_kanban_info_rec.input_type = 2 OR
3046: g_kanban_info_rec.input_type = 3) AND p_demand_type = 3) THEN
3047: l_sales_order_demand := 'Y';

Line 3052: -- check to see if we are dealing with a standard item

3048: ELSE
3049: l_sales_order_demand := 'N';
3050: END IF;
3051:
3052: -- check to see if we are dealing with a standard item
3053: SELECT bom_item_type,
3054: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
3055: INTO l_bom_item_type,
3056: l_foq