APPS.GME_MAKE_TO_ORDER_PVT dependencies on MTL_SYSTEM_ITEMS

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

179: oh.order_number
180: FROM oe_order_headers_all oh
181: ,oe_order_lines_all ol
182: ,oe_transaction_types_all ot
183: ,mtl_system_items mtl
184: WHERE ol.line_id = p_so_line_id
185: and ol.header_id = oh.header_id
186: and oh.order_type_id = ot.transaction_type_id
187: and mtl.inventory_item_id = ol.inventory_item_id;

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