APPS.GME_MAKE_TO_ORDER_PVT dependencies on MTL_SYSTEM_ITEMS_B

Line 75: l_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;

71: l_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
72: l_out_batch_header_rec GME_BATCH_HEADER%ROWTYPE;
73: l_material_detail_rec GME_MATERIAL_DETAILS%ROWTYPE;
74: l_so_line_rec OE_ORDER_LINES_ALL%ROWTYPE;
75: l_item_rec MTL_SYSTEM_ITEMS_B%ROWTYPE;
76: l_so_batch_rsv_rec GML_BATCH_OM_UTIL.gme_om_reservation_rec;
77: l_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
78: l_out_pending_product_lots_rec GME_PENDING_PRODUCT_LOTS%ROWTYPE;
79: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;

Line 160: FROM mtl_system_items_b m

156: ORDER BY mr.reservation_id;
157:
158: CURSOR cur_item(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
159: SELECT *
160: FROM mtl_system_items_b m
161: WHERE m.inventory_item_id = p_inventory_item_id
162: AND m.organization_id = p_organization_id;
163:
164: CURSOR get_so_line_rec(p_so_line_id IN NUMBER) IS

Line 1151: FROM mtl_system_items_b m

1147: WHERE line_id = p_line_id;
1148:
1149: CURSOR cur_item(p_organization_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
1150: SELECT item_type
1151: FROM mtl_system_items_b m
1152: WHERE m.inventory_item_id = p_inventory_item_id
1153: AND m.organization_id = p_organization_id;
1154: BEGIN
1155: IF (g_debug <= gme_debug.g_log_statement) THEN