DBA Data[Home] [Help]

APPS.PO_VAL_LINES dependencies on PO_HEADERS_ALL

Line 825: , PO_HEADERS_ALL HEADER

821: , l_amount_tbl
822: FROM
823: PO_SESSION_GT SES
824: , PO_LINES_ALL LINE
825: , PO_HEADERS_ALL HEADER
826: WHERE
827: SES.key = l_data_key
828: AND LINE.po_line_id = SES.num1
829: AND HEADER.po_header_id = LINE.po_header_id

Line 2314: FROM po_headers_all

2310: -- SQL What: Get type of source document
2311: -- SQL Why: To pass to validation
2312: SELECT type_lookup_code
2313: INTO l_src_doc_type_lookup_code
2314: FROM po_headers_all
2315: WHERE po_header_id = l_from_header_id;
2316:
2317: -- Throw error if following is true:
2318: -- 1) Source doc is blanket or quotation