APPS.GME_RESERVATIONS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 595: FROM gme_material_details d, mtl_system_items_b i

591:
592: CURSOR cur_batch_materials
593: IS
594: SELECT d.material_detail_id, d.batch_id, d.organization_id
595: FROM gme_material_details d, mtl_system_items_b i
596: WHERE d.organization_id = p_organization_id
597: AND d.batch_id = p_batch_id
598: AND d.line_type = gme_common_pvt.g_line_type_ing
599: AND i.organization_id = d.organization_id

Line 1317: FROM mtl_system_items_b

1313:
1314: CURSOR cur_fetch_item (v_org_id NUMBER, v_inventory_item_id NUMBER)
1315: IS
1316: SELECT *
1317: FROM mtl_system_items_b
1318: WHERE organization_id = v_org_id
1319: AND inventory_item_id = v_inventory_item_id;
1320: BEGIN
1321: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1539: l_item_rec mtl_system_items_b%ROWTYPE;

1535: p_material_details_rec IN gme_material_details%ROWTYPE
1536: ,x_return_status OUT NOCOPY VARCHAR2)
1537: IS
1538: l_api_name CONSTANT VARCHAR2 (30) := 'auto_detail_line';
1539: l_item_rec mtl_system_items_b%ROWTYPE;
1540: l_rsv_rec mtl_reservations%ROWTYPE;
1541: l_rsv_tbl gme_common_pvt.reservations_tab;
1542: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
1543: l_rsv_type NUMBER;

Line 1569: FROM mtl_system_items_b

1565:
1566: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
1567: IS
1568: SELECT *
1569: FROM mtl_system_items_b
1570: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
1571:
1572: CURSOR cur_get_mo_rec (v_move_order_line_id NUMBER)
1573: IS

Line 2029: FROM gme_material_details d,mtl_system_items_b i

2025: /* Retrieve Ingredient rows */
2026: CURSOR cur_get_reservable_ings
2027: IS
2028: SELECT d.*
2029: FROM gme_material_details d,mtl_system_items_b i
2030: WHERE d.batch_id = p_batch_rec.batch_id
2031: AND d.line_type = -1
2032: AND d.material_requirement_date < SYSDATE + NVL(gme_common_pvt.g_rule_based_resv_horizon,p_timefence)
2033: AND i. inventory_item_id = d.inventory_item_id