DBA Data[Home] [Help]

APPS.PO_XML_UTILS_GRP dependencies on PO_LINES_ALL

Line 348: from po_headers_all glblH, po_lines_all glblSPO

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

Line 355: from po_lines_all glblL, po_lines_all glblSPO

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