APPS.PO_LINES_SV4_832_UPDATE dependencies on PO_HEADERS

Line 651: po_headers poh

647:
648: select fnd.precision
649: into l_precision
650: from fnd_currencies fnd,
651: po_headers poh
652: where poh.currency_code = fnd.currency_code
653: and poh.po_header_id = x_current_po_header_id;
654:
655: -- Bug 3346174

Line 1092: po_headers_all poh

1088: BEGIN
1089: SELECT NVL(MAX(pll.shipment_num),0) + 1
1090: INTO X_shipment_num
1091: FROM po_line_locations pll,
1092: po_headers_all poh
1093: WHERE pll.po_header_id = X_po_header_id
1094: AND pll.po_line_id = X_po_line_id
1095: AND poh.po_header_id = pll.po_header_id
1096: AND pll.shipment_type = x_shipment_type;

Line 1249: from po_headers_interface

1245: --
1246:
1247:
1248: select process_code into l_process_code
1249: from po_headers_interface
1250: where interface_header_id = X_interface_header_id;
1251:
1252: if NVL(l_process_code, 'UPDATE') = 'NOTIFIED' then
1253:

Line 1425: from po_headers

1421:
1422:
1423: begin
1424: select segment1 into l_document_num
1425: from po_headers
1426: where po_header_id = X_po_header_id;
1427:
1428: exception
1429: when others then

Line 1488: from po_headers

1484: aname => 'BUYER_ID',
1485: avalue => X_buyer_id );
1486:
1487: select agent_id, vendor_id into x_agent_id, X_supplier_id
1488: from po_headers
1489: where po_header_id = X_po_header_id;
1490:
1491: l_orig_system:= 'PER';
1492:

Line 1623: from po_headers_interface

1619: PO_DEBUG.put_line ('$ Checking price tolerance');
1620: END IF;
1621:
1622: select process_code into l_process_code
1623: from po_headers_interface
1624: where interface_header_id = p_interface_header_id;
1625:
1626: select price_chg_accept_flag into l_acceptance_flag
1627: from po_lines_interface

Line 1679: from po_headers

1675: begin
1676: -- original document (blanket)
1677:
1678: select price_update_tolerance into l_price_update_tolerance
1679: from po_headers
1680: where po_header_id = p_document_id
1681: and type_lookup_code = 'BLANKET';
1682:
1683: exception