DBA Data[Home] [Help]

APPS.GME_MAKE_TO_ORDER_PVT dependencies on GME_MATERIAL_DETAILS

Line 73: l_material_detail_rec GME_MATERIAL_DETAILS%ROWTYPE;

69: l_res_qty_so_um NUMBER;
70:
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;

Line 171: FROM gme_material_details

167: WHERE line_id = p_so_line_id;
168:
169: CURSOR get_batch_line(p_batch_id IN NUMBER, p_inventory_item_id IN NUMBER) IS
170: SELECT *
171: FROM gme_material_details
172: WHERE batch_id = p_batch_id
173: AND inventory_item_id = p_inventory_item_id
174: AND line_type = gme_common_pvt.g_line_type_prod;
175: