[Home] [Help]
5: /* Bom Item Types */
6: C_MODEL Constant NUMBER := 1;
7: C_OPTION_CLASS Constant NUMBER := 2;
8: C_PLANNING Constant NUMBER := 3;
9: C_STANDARD Constant NUMBER := 4;
10: C_PRODUCT_FAMILY Constant NUMBER := 5;
11:
12: /* ATO Forecast Control Options */
13: C_CONSUME Constant NUMBER := 1;
36: * (1) Instance, (2) Source Org Pk, (3) Source Inventory Item Id
37: *
38: * Returns: 1 - Model
39: * 2 - Option Class
40: * 3 - Standard
41: * 4 - Planning
42: * 5 - Product Family
43: *
44: */
146: AND assemble.organization_id = mbc.organization_id
147: AND (assemble.mrp_planning_code <> 6 or -- Exclude non plan ATO, but include PTO
148: (assemble.mrp_planning_code = 6 and assemble.pick_components_flag = 'Y'))
149: AND assemble.ato_forecast_control <> 3
150: AND (assemble.bom_item_type <> 4 or -- exclude Standard bom, but include Kit
151: (assemble.bom_item_type = 4 and assemble.pick_components_flag = 'Y'))
152: AND mbc.inventory_item_id = ascp_comp.inventory_item_id
153: AND mbc.organization_id = ascp_comp.organization_id
154: AND mbc.sr_instance_id = ascp_comp.sr_instance_id
152: AND mbc.inventory_item_id = ascp_comp.inventory_item_id
153: AND mbc.organization_id = ascp_comp.organization_id
154: AND mbc.sr_instance_id = ascp_comp.sr_instance_id
155: AND ascp_comp.ato_forecast_control = C_CONSUME_DERIVE
156: AND ascp_comp.bom_item_type in (C_MODEL,C_STANDARD)
157: AND ( ascp_comp.mrp_planning_code <> C_NO_PLANNING or
158: (ascp_comp.mrp_planning_code = C_NO_PLANNING and ascp_comp.pick_components_flag = 'Y'))
159: AND mbc.sr_instance_id = mb.sr_instance_id; -- Support PTO as component
160:
371:
372:
373:
374: elsif (p_bom_item_type = C_MODEL or
375: p_bom_item_type = C_STANDARD ) then /* To bring PTO Kit */
376:
377: open c2(L_INSTANCE(j), to_number(L_ORG_SR_PKS(j)), L_ASSEMBLY_ASCP_PKS(j));
378: fetch c2 into x_sr_level_pk;
379: close c2;