DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_PRICE_ADJ_ATTRIBS

Line 5398: -- PO_PRICE_ADJ_ATTRIBS_ARCHIVE

5394: --Name: archive_price_adj_attribs
5395: --Pre-reqs:
5396: -- None.
5397: --Modifies:
5398: -- PO_PRICE_ADJ_ATTRIBS_ARCHIVE
5399: --Locks:
5400: -- None.
5401: --Function:
5402: -- Archive Price Adjustment Attributes

Line 5430: INSERT INTO PO_PRICE_ADJ_ATTRIBS_ARCHIVE

5426:
5427: IF PO_LOG.d_stmt THEN PO_LOG.stmt(d_mod,l_progress,'Calling INSERT'); END IF;
5428:
5429: l_progress := '010';
5430: INSERT INTO PO_PRICE_ADJ_ATTRIBS_ARCHIVE
5431: (
5432: price_adjustment_id,
5433: pricing_context,
5434: pricing_attribute,

Line 5472: FROM PO_PRICE_ADJ_ATTRIBS ATTR,

5468: ATTR.flex_title,
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