[Home] [Help]
39: */
40:
41: SELECT i.atp_flag, i.bom_item_type, b.atp_check
42: INTO l_atp_flag, l_bom_item_type, l_atp_check
43: FROM msc_system_items i, msc_bom_temp b
44: WHERE i.sr_inventory_item_id = p_inventory_item_id
45: AND i.organization_id = p_organization_id
46: AND i.plan_id = p_plan_id
47: AND i.sr_instance_id = p_instance_id
126: -- C R
127: -- R R
128:
129: -- Bug 1562754, use G_ASSEMBLY_LINE_ID instead of G_COMP_LINE_ID, to make sure that
130: -- in case of CTO, we try to get the BOM correctly from msc_bom_temp_table.-NGOEL 02/01/2001
131:
132: -- ngoel 9/24/2001, added to identify if current line is a MATO line, no need to run this select again.
133:
134: IF (NVL(MSC_ATP_PVT.G_CTO_LINE, 'N') = 'N') THEN
133:
134: IF (NVL(MSC_ATP_PVT.G_CTO_LINE, 'N') = 'N') THEN
135: SELECT count(assembly_identifier)
136: INTO l_cto_bom
137: FROM msc_bom_temp mbt
138: WHERE mbt.session_id = MSC_ATP_PVT.G_SESSION_ID
139: AND mbt.assembly_identifier = MSC_ATP_PVT.G_COMP_LINE_ID
140: AND mbt.assembly_item_id = p_inventory_item_id;
141:
145: END IF;
146:
147: -- FOR CTO Models, pick_components_flag shall be 'N' and replenish_to_order
148: -- flag shall be 'Y'. Modify flag only for PTO model or an option class.
149: -- When a BOM exists in MSC_BOM_TEMP table, modify flags to always check for
150: -- material.
151:
152: IF PG_DEBUG in ('Y', 'C') THEN
153: msc_sch_wb.atp_debug('get_atp_comp_flag: ' || 'l_cto_bom = '||l_cto_bom);
171: ELSIF l_bom_item_type = 4 THEN
172: BEGIN
173: SELECT atp_check
174: INTO l_atp_check
175: FROM msc_bom_temp
176: WHERE component_item_id = p_inventory_item_id
177: AND component_identifier = MSC_ATP_PVT.G_COMP_LINE_ID
178: AND session_id = MSC_ATP_PVT.G_SESSION_ID;
179: