APPS.GML_PO_CON_REQ dependencies on PO_LINE_LOCATIONS_ALL

Line 139: FROM po_line_locations_all

135:
136: CURSOR get_failed_release_details (v_po_header_id NUMBER, v_release_id NUMBER)
137: IS
138: SELECT po_header_id, po_line_id, line_location_id, ship_to_location_id
139: FROM po_line_locations_all
140: WHERE po_header_id = v_po_header_id
141: AND po_release_id = v_release_id
142: ORDER BY po_header_id, po_line_id,line_location_id;
143:

Line 147: FROM po_line_locations_all

143:
144:
145: CURSOR shipping_details(v_po_header_id NUMBER) IS
146: SELECT po_header_id, po_line_id, line_location_id, ship_to_location_id
147: FROM po_line_locations_all
148: WHERE po_header_id = v_po_header_id
149: AND approved_flag ='Y'
150: ORDER BY po_header_id, po_line_id, line_location_id;
151:

Line 257: FROM po_line_locations_all

253: SELECT po_header_id,
254: po_line_id,
255: line_location_id,
256: po_release_id
257: FROM po_line_locations_all
258: WHERE (creation_date >= v_date_from AND creation_date < v_date_to + 1 )
259: ORDER BY po_header_id,po_release_id,po_line_id,line_location_id;
260:
261: CURSOR get_transaction_type(v_po_head_id NUMBER) IS

Line 276: FROM po_line_locations_all

272: SELECT po_header_id,
273: po_line_id,
274: line_location_id,
275: po_release_id
276: FROM po_line_locations_all
277: WHERE po_header_id = v_po_header_id
278: ORDER BY po_header_id,po_release_id,po_line_id,line_location_id;
279:
280: get_synch_failed_rows_PO_rec get_synch_failed_rows_PO%ROWTYPE;