APPS.GME_MAKE_TO_ORDER_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 65: l_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;

61: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
62: l_out_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
63: l_material_detail_rec GME_MATERIAL_DETAILS%ROWTYPE;
64: l_so_line_rec OE_ORDER_LINES_ALL%ROWTYPE;
65: l_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
66: l_so_batch_rsv_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
67: l_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
68: l_out_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
69: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;

Line 145: FROM mtl_system_items_b m

141: ORDER BY mr.reservation_id;
142:
143: CURSOR cur_item(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
144: SELECT *
145: FROM mtl_system_items_b m
146: WHERE m.inventory_item_id = p_inventory_item_id
147: AND m.organization_id = p_organization_id;
148:
149: CURSOR get_so_line_rec(p_so_line_id IN NUMBER) IS

Line 1047: FROM mtl_system_items_b m

1043: WHERE line_id = p_line_id;
1044:
1045: CURSOR cur_item(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
1046: SELECT item_type
1047: FROM mtl_system_items_b m
1048: WHERE m.inventory_item_id = p_inventory_item_id
1049: AND m.organization_id = p_organization_id;
1050: BEGIN
1051: IF (g_debug <= gme_debug.g_log_statement) THEN