DBA Data[Home] [Help]

APPS.GML_PO_CON_REQ dependencies on PO_HEADERS_ALL

Line 263: FROM po_headers_all

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
262: SELECT type_lookup_code
263: FROM po_headers_all
264: WHERE po_header_id = v_po_head_id;
265:
266: CURSOR get_trans_type(v_po_no VARCHAR2) IS
267: SELECT type_lookup_code, po_header_id

Line 268: FROM po_headers_all

264: WHERE po_header_id = v_po_head_id;
265:
266: CURSOR get_trans_type(v_po_no VARCHAR2) IS
267: SELECT type_lookup_code, po_header_id
268: FROM po_headers_all
269: WHERE segment1 = v_po_no;
270:
271: CURSOR get_synch_failed_rows_PO (v_po_header_id VARCHAR2) IS
272: SELECT po_header_id,