APPS.PO_INTERFACE_S2 dependencies on PO_LINES

Line 111: po_lines_all pl

107: ph.type_lookup_code --
108: INTO x_source_line_id,
109: x_src_document_type --
110: FROM po_headers_all ph,
111: po_lines_all pl
112: WHERE ph.po_header_id = pl.po_header_id
113: AND ph.vendor_id = x_vendor_id
114: AND ph.currency_code = x_currency --
115: AND ((ph.type_lookup_code = 'BLANKET'

Line 323: FROM po_lines POL,

319: INTO l_ga_count,
320: l_quotation_count,
321: l_lc_count,
322: l_gc_count
323: FROM po_lines POL,
324: po_headers_all POSRC,
325: po_headers_all POC
326: WHERE POL.po_header_id = p_new_po_id
327: AND POL.from_header_id = POSRC.po_header_id (+)

Line 341: -- referenced on the standard PO lines, default terms and conditions

337: -- Rules of defaulting terms and conditions:
338: -- The source document hieararchy for terms and conditions defaulting is:
339: -- Global Agreement, Quotation, Local Contract, Global Contract.
340: -- 1) For a src document type, if there is only one distinct documents
341: -- referenced on the standard PO lines, default terms and conditions
342: -- from that src document
343: -- 2) If there are more than one distinct documents on that type being
344: -- referenced on the standard PO, do not default terms and conditions
345: -- 3) If there is no document of this type being referenced on the standard

Line 534: FROM po_lines POL,

530: BEGIN
531: IF (p_src_doc_type IN ('BLANKET', 'QUOTATION')) THEN
532: SELECT POH.po_header_id
533: INTO x_src_doc_id
534: FROM po_lines POL,
535: po_headers_all POH
536: WHERE POL.po_header_id = p_po_header_id
537: AND POH.po_header_id = POL.from_header_id
538: AND POH.type_lookup_code = p_src_doc_type

Line 546: FROM po_lines POL,

542: ELSIF (p_src_doc_type = 'CONTRACT') THEN
543:
544: SELECT POH.po_header_id
545: INTO x_src_doc_id
546: FROM po_lines POL,
547: po_headers_all POH
548: WHERE POL.po_header_id = p_po_header_id
549: AND POH.po_header_id = POL.contract_id
550: AND NVL(POH.global_agreement_flag, 'N') = p_global_flag