APPS.GME_MAKE_TO_ORDER_PVT dependencies on MTL_SYSTEM_ITEMS

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 168: ,mtl_system_items mtl

164: oh.order_number
165: FROM oe_order_headers_all oh
166: ,oe_order_lines_all ol
167: ,oe_transaction_types_all ot
168: ,mtl_system_items mtl
169: WHERE ol.line_id = p_so_line_id
170: and ol.header_id = oh.header_id
171: and oh.order_type_id = ot.transaction_type_id
172: and mtl.inventory_item_id = ol.inventory_item_id;

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