DBA Data[Home] [Help]

APPS.GML_BATCH_OM_RES_PVT dependencies on OE_ORDER_LINES_ALL

Line 342: , oe_order_lines_all ol

338: , res.so_line_id
339: , res.delivery_detail_id
340: , res.batch_id
341: From gml_batch_so_reservations res
342: , oe_order_lines_all ol
343: Where res.batch_line_id = p_batch_line_id
344: and res.delete_mark = 0
345: and res.reserved_qty <> 0
346: and res.whse_code = p_whse_code

Line 1043: FROM oe_order_lines_all

1039:
1040:
1041: CURSOR CSR_for_so_line(p_so_line_id IN NUMBER) IS
1042: SELECT last_updated_by, created_by,header_id
1043: FROM oe_order_lines_all
1044: WHERE line_id = p_so_line_id;
1045:
1046: Cursor find_nonstgd_alloc_for_trans (P_batch_trans_id IN NUMBER) IS
1047: Select count(*)