DBA Data[Home] [Help]

APPS.MRP_KANBAN_PLAN_PK dependencies on STANDARD

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

2732: -- we need to set the flags
2733: -- l_explode_always and l_sales_order_demand.
2734: -- Setting l_sales_order demand is very straight forward.
2735: -- l_explode_always is set to TRUE if the demand_type is Manual for
2736: -- either forecast or schedule inputs or if the item type is 'Standard'
2737:
2738: l_sales_order_demand := 'N';
2739:
2740: -- check to see if we are dealing with a standard item

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

2736: -- either forecast or schedule inputs or if the item type is 'Standard'
2737:
2738: l_sales_order_demand := 'N';
2739:
2740: -- check to see if we are dealing with a standard item
2741: SELECT bom_item_type,
2742: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
2743: INTO l_bom_item_type,
2744: l_foq

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

3052: -- Setting l_sales_order demand is very straight forward.
3053:
3054: l_sales_order_demand := 'N';
3055:
3056: -- check to see if we are dealing with a standard item
3057: SELECT bom_item_type,
3058: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
3059: INTO l_bom_item_type,
3060: l_foq

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

3361: -- we need to set the flags
3362: -- l_explode_always and l_sales_order_demand.
3363: -- Setting l_sales_order demand is very straight forward.
3364: -- l_explode_always is set to TRUE if the demand_type is Manual for
3365: -- either forecast or schedule inputs or if the item type is 'Standard'
3366:
3367: IF ((g_kanban_info_rec.input_type = 2 OR
3368: g_kanban_info_rec.input_type = 3) AND p_demand_type = 3) THEN
3369: l_sales_order_demand := 'Y';

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

3370: ELSE
3371: l_sales_order_demand := 'N';
3372: END IF;
3373:
3374: -- check to see if we are dealing with a standard item
3375: SELECT bom_item_type,
3376: nvl(fixed_order_quantity, nvl(minimum_order_quantity, nvl(maximum_order_quantity,1)))
3377: INTO l_bom_item_type,
3378: l_foq