APPS.GME_RESERVATIONS_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 875: FROM gme_material_details d, mtl_system_items_b i

871:
872: CURSOR cur_batch_materials
873: IS
874: SELECT d.material_detail_id, d.batch_id, d.organization_id
875: FROM gme_material_details d, mtl_system_items_b i
876: WHERE d.organization_id = p_organization_id
877: AND d.batch_id = p_batch_id
878: AND d.line_type = gme_common_pvt.g_line_type_ing
879: AND i.organization_id = d.organization_id

Line 1611: FROM mtl_system_items_b

1607:
1608: CURSOR cur_fetch_item (v_org_id NUMBER, v_inventory_item_id NUMBER)
1609: IS
1610: SELECT *
1611: FROM mtl_system_items_b
1612: WHERE organization_id = v_org_id
1613: AND inventory_item_id = v_inventory_item_id;
1614: BEGIN
1615: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1839: l_item_rec mtl_system_items_b%ROWTYPE;

1835: p_material_details_rec IN gme_material_details%ROWTYPE
1836: ,x_return_status OUT NOCOPY VARCHAR2)
1837: IS
1838: l_api_name CONSTANT VARCHAR2 (30) := 'auto_detail_line';
1839: l_item_rec mtl_system_items_b%ROWTYPE;
1840: l_rsv_rec mtl_reservations%ROWTYPE;
1841: l_rsv_tbl gme_common_pvt.reservations_tab;
1842: l_reservations_tbl inv_reservation_global.mtl_reservation_tbl_type;
1843: l_rsv_type NUMBER;

Line 1874: FROM mtl_system_items_b

1870:
1871: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER)
1872: IS
1873: SELECT *
1874: FROM mtl_system_items_b
1875: WHERE inventory_item_id = v_item_id AND organization_id = v_org_id;
1876:
1877: CURSOR cur_get_mo_rec (v_move_order_line_id NUMBER)
1878: IS

Line 2438: FROM gme_material_details d,mtl_system_items_b i

2434: /* Retrieve Ingredient rows */
2435: CURSOR cur_get_reservable_ings
2436: IS
2437: SELECT d.*
2438: FROM gme_material_details d,mtl_system_items_b i
2439: WHERE d.batch_id = p_batch_rec.batch_id
2440: AND d.line_type = -1
2441: AND d.material_requirement_date < SYSDATE + NVL(gme_common_pvt.g_rule_based_resv_horizon,p_timefence)
2442: AND i. inventory_item_id = d.inventory_item_id