DBA Data[Home] [Help]

APPS.PO_XML_UTILS_GRP dependencies on PO_LINES_ALL

Line 350: from po_headers_all glblH, po_lines_all glblSPO

346: begin
347:
348: select glblH.segment1
349: into x_GLOBALCONTRACT
350: from po_headers_all glblH, po_lines_all glblSPO
351: where glblSPO.po_line_id = p_po_line_id and
352: glblSPO.from_header_id = glblH.po_header_id and
353: glblH.global_agreement_flag = 'Y';
354:

Line 357: from po_lines_all glblL, po_lines_all glblSPO

353: glblH.global_agreement_flag = 'Y';
354:
355: select to_char(glblL.line_Num)
356: into x_GLOBALCONTRACTLIN
357: from po_lines_all glblL, po_lines_all glblSPO
358: where glblSPO.po_line_id = p_po_line_id and
359: glblSPO.from_line_id = glblL.po_line_id;
360:
361: EXCEPTION