[Home] [Help]
888: intf_lines.from_line_disp
889:
890: FROM po_lines_interface intf_lines,
891: po_headers_interface intf_headers,
892: po_headers_draft_all draft_headers
893: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
894: AND intf_headers.draft_id = draft_headers.draft_id
895: AND intf_headers.po_header_id = draft_headers.po_header_id
896: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
1834: intf_lines.from_line_disp
1835:
1836: FROM po_lines_interface intf_lines,
1837: po_headers_interface intf_headers,
1838: po_headers_draft_all draft_headers
1839: WHERE intf_lines.interface_header_id = intf_headers.interface_header_id
1840: AND intf_headers.draft_id = draft_headers.draft_id
1841: AND intf_headers.po_header_id = draft_headers.po_header_id
1842: AND intf_lines.processing_id = PO_PDOI_PARAMS.g_processing_id
9738: FROM dual;
9739:
9740: UPDATE po_session_gt psg
9741: SET psg.num4 = ( SELECT phd.clm_source_document_id
9742: FROM po_headers_draft_all phd, po_lines_interface PLI, po_headers_interface phi
9743: WHERE PLI.interface_line_id = psg.num3
9744: AND PLI.interface_header_id = phi.interface_header_id
9745: AND phi.po_header_id = phd.po_header_id
9746: )