APPS.CZ_OM_ATP_CALLBACK dependencies on MTL_SYSTEM_ITEMS_B

Line 241: l_pto_flag mtl_system_items_b.pick_components_flag%TYPE;

237: ,x_ret_status OUT NOCOPY NUMBER
238: ,x_msg_data OUT NOCOPY VARCHAR2
239: )
240: IS
241: l_pto_flag mtl_system_items_b.pick_components_flag%TYPE;
242: l_grp_id NUMBER;
243: l_err_code NUMBER;
244: l_err_msg VARCHAR2(2000);
245:

Line 255: FROM mtl_system_items_b

251: BEGIN
252: x_ret_status := 0;
253:
254: SELECT UPPER(pick_components_flag) INTO l_pto_flag
255: FROM mtl_system_items_b
256: WHERE inventory_item_id = p_top_item_id AND organization_id = p_organization_id;
257:
258: IF l_pto_flag <> 'Y' THEN
259: RETURN;

Line 266: FROM mtl_system_items_b

262: l_count := 0;
263: FOR i IN g_atp_rec.inventory_item_id.FIRST .. p_count LOOP
264: IF g_atp_rec.inventory_item_id(i) <> p_top_item_id THEN
265: SELECT UPPER(pick_components_flag) INTO l_pto_flag
266: FROM mtl_system_items_b
267: WHERE inventory_item_id = g_atp_rec.inventory_item_id(i)
268: AND organization_id = p_organization_id;
269: END IF;
270: