APPS.GML_GME_API_PVT dependencies on GML_BATCH_SO_RESERVATIONS

Line 76: From gml_batch_so_reservations

72: where trans_id = p_trans_id;
73:
74: Cursor check_res_whse (p_batch_line_id IN NUMBER) is
75: Select distinct whse_code
76: From gml_batch_so_reservations
77: Where batch_line_id = p_batch_line_id;
78:
79: Cursor get_res_qty(p_batch_line_id IN NUMBER
80: , p_whse_code IN VARCHAR2) is

Line 82: From gml_batch_so_reservations

78:
79: Cursor get_res_qty(p_batch_line_id IN NUMBER
80: , p_whse_code IN VARCHAR2) is
81: Select sum(reserved_qty), sum(reserved_qty2)
82: From gml_batch_so_reservations
83: Where batch_line_id = p_batch_line_id
84: and whse_code = p_whse_code
85: and delete_mark = 0;
86:

Line 129: From gml_batch_so_reservations

125: ;
126:
127: Cursor get_res_for_batch_line(p_batch_line_id In NUMBER) is
128: Select scheduled_ship_date
129: From gml_batch_so_reservations
130: Where batch_line_id = p_batch_line_id
131: and delete_mark = 0
132: and reserved_qty <> 0
133: ;

Line 137: From gml_batch_so_reservations

133: ;
134:
135: Cursor get_lnid_for_batch(p_batch_id In NUMBER) is
136: Select distinct batch_line_id
137: From gml_batch_so_reservations
138: Where batch_id = p_batch_id
139: and delete_mark = 0
140: and reserved_qty <> 0
141: ;