APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_PRICE_ADJUSTMENTS

Line 5137: -- PO_PRICE_ADJUSTMENTS_ARCHIVE

5133: --Name: archive_price_adjustments
5134: --Pre-reqs:
5135: -- None.
5136: --Modifies:
5137: -- PO_PRICE_ADJUSTMENTS_ARCHIVE
5138: --Locks:
5139: -- None.
5140: --Function:
5141: -- Archive Price Adjustments

Line 5168: INSERT INTO PO_PRICE_ADJUSTMENTS_ARCHIVE

5164:
5165: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
5166:
5167: l_progress := '010';
5168: INSERT INTO PO_PRICE_ADJUSTMENTS_ARCHIVE
5169: (
5170: price_adjustment_id,
5171: creation_date,
5172: created_by,

Line 5378: FROM PO_PRICE_ADJUSTMENTS ADJ,

5374: ADJ.tax_rate_id,
5375: 'Y', -- latest_external_flag
5376: p_revision_num,
5377: ADJ.adj_line_num
5378: FROM PO_PRICE_ADJUSTMENTS ADJ,
5379: PO_LINES_ALL POL
5380: WHERE ADJ.po_line_id = POL.po_line_id
5381: AND POL.po_header_id = p_po_header_id;
5382:

Line 5473: PO_PRICE_ADJUSTMENTS ADJ,

5469: ATTR.price_adj_attrib_id,
5470: 'Y', -- latest_external_flag
5471: p_revision_num
5472: FROM PO_PRICE_ADJ_ATTRIBS ATTR,
5473: PO_PRICE_ADJUSTMENTS ADJ,
5474: PO_LINES_ALL POL
5475: WHERE ATTR.price_adjustment_id = ADJ.price_adjustment_id
5476: AND ADJ.po_line_id = POL.po_line_id
5477: AND POL.po_header_id = p_po_header_id;