DBA Data[Home] [Help]

APPS.GME_MAKE_TO_ORDER_PVT dependencies on GME_MATERIAL_DETAILS

Line 63: l_material_detail_rec GME_MATERIAL_DETAILS%ROWTYPE;

59: l_res_qty_so_um NUMBER;
60:
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;

Line 156: FROM gme_material_details

152: WHERE line_id = p_so_line_id;
153:
154: CURSOR get_batch_line(p_batch_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
155: SELECT *
156: FROM gme_material_details
157: WHERE batch_id = p_batch_id
158: AND inventory_item_id = p_inventory_item_id
159: AND line_type = gme_common_pvt.g_line_type_prod;
160: