[Home] [Help]
7: /* Bom Item Types */
8: C_MODEL CONSTANT NUMBER := 1;
9: C_OPTION_CLASS CONSTANT NUMBER := 2;
10: C_PLANNING CONSTANT NUMBER := 3;
11: C_STANDARD CONSTANT NUMBER := 4;
12: C_PRODUCT_FAMILY CONSTANT NUMBER := 5;
13:
14: /* ATO Forecast Control Options */
15: C_CONSUME CONSTANT NUMBER := 1;
57: * (1) Instance, (2) Source Org Pk, (3) Source Inventory Item Id
58: *
59: * Returns: 1 - Model
60: * 2 - Option Class
61: * 3 - Standard
62: * 4 - Planning
63: * 5 - Product Family
64: *
65: */
300: OR
301: ( assemble.mrp_planning_code = 6
302: AND assemble.pick_components_flag = 'Y'))
303: AND assemble.ato_forecast_control <> 3
304: AND ( assemble.bom_item_type <> 4 -- exclude Standard bom, but include Kit
305: OR
306: ( assemble.bom_item_type = 4
307: AND assemble.pick_components_flag = 'Y'))
308: AND ascp_comp.plan_id = mbc.plan_id
309: AND ascp_comp.inventory_item_id = mbc.inventory_item_id
310: AND ascp_comp.organization_id = mbc.organization_id
311: AND ascp_comp.sr_instance_id = mbc.sr_instance_id
312: AND ascp_comp.ato_forecast_control = C_CONSUME_DERIVE
313: AND ascp_comp.bom_item_type in (C_MODEL,C_STANDARD)
314: AND ( ascp_comp.mrp_planning_code <> C_NO_PLANNING
315: OR ( ascp_comp.mrp_planning_code = C_NO_PLANNING
316: AND ascp_comp.pick_components_flag = 'Y')); -- Support PTO as component
317:
575:
576: END LOOP; -- End of While Loop2
577:
578: ELSIF ( p_bom_item_type = C_MODEL
579: OR p_bom_item_type = C_STANDARD ) /* To bring PTO Kit */
580: THEN
581:
582: OPEN c2(L_INSTANCE(j), to_number(L_ORG_SR_PKS(j)), L_ASSEMBLY_ASCP_PKS(j));
583: FETCH c2 INTO x_sr_level_pk;