APPS.CZ_OM_ATP_CALLBACK dependencies on MTL_SYSTEM_ITEMS

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:

Line 412: l_pto_model_flag mtl_system_items.pick_components_flag%TYPE;

408: l_atp_rec MRP_ATP_PUB.atp_rec_typ;
409: l_ship_set_name VARCHAR2(30);
410: l_top_model_line_id NUMBER;
411: l_validation_org NUMBER;
412: l_pto_model_flag mtl_system_items.pick_components_flag%TYPE;
413:
414: -- variables used for mandatory component addition
415: l_mc_result NUMBER;
416: l_mc_atp_rec MRP_ATP_PUB.atp_rec_typ;

Line 689: FROM mtl_system_items

685: -- the following logic will be changed because there are some special cases
686: p_ship_to_group_date := g_atp_rec.group_ship_date(1);
687: IF (aps_version >= APS_VERSION_PATCHSET_J) THEN
688: SELECT pick_components_flag INTO l_pto_model_flag
689: FROM mtl_system_items
690: WHERE inventory_item_id = g_atp_rec.inventory_item_id(1)
691: AND organization_id = l_validation_org;
692:
693: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,