APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on OE_PRICE_ADJ_ASSOCS

Line 1518: /*index(ass OE_PRICE_ADJ_ASSOCS_N3)*/

1514: x_return_status_text OUT NOCOPY VARCHAR2) IS
1515:
1516: CURSOR l_rltd_line_info_cur IS
1517: SELECT /*+ ORDERED USE_NL(adj_pbh ass adj attr) */
1518: /*index(ass OE_PRICE_ADJ_ASSOCS_N3)*/
1519: line.line_index line_index,
1520: adj_pbh.price_adjustment_id line_detail_index,
1521: line.line_index related_line_index,
1522: ass.rltd_price_adj_id related_line_detail_index,

Line 1543: ,oe_price_adj_assocs ass

1539: attr.list_header_id,
1540: adj.list_line_no
1541: FROM qp_npreq_lines_tmp line
1542: ,oe_price_adjustments adj_pbh
1543: ,oe_price_adj_assocs ass
1544: ,oe_price_adjustments adj
1545: , qp_pricing_attributes attr
1546: -- WHERE p_request_type_code = 'ONT'
1547: --bug 3085453 handle pricing availability UI

Line 1578: --/*+ index(ass OE_PRICE_ADJ_ASSOCS_N3)*/

1574: and attr.list_line_id = adj.list_line_id
1575: and attr.pricing_attribute_context = QP_PREQ_PUB.G_PRIC_VOLUME_CONTEXT
1576: UNION
1577: SELECT /*+ ORDERED USE_NL(adj_pbh ass adj attr) */
1578: --/*+ index(ass OE_PRICE_ADJ_ASSOCS_N3)*/
1579: -- (adj_pbh.quote_header_id+nvl(adj_pbh.quote_line_id,0)) line_index,
1580: line.line_index,
1581: adj_pbh.line_detail_index line_detail_index,
1582: -- adj.quote_line_id related_line_index,

Line 2093: from oe_price_adj_assocs a, oe_price_adjustments b

2089: and qplh.list_header_id = adj.list_header_id
2090: and qplh.list_type_code not in (QP_PREQ_PUB.G_PRICE_LIST_HEADER,
2091: QP_PREQ_PUB.G_AGR_LIST_HEADER)
2092: and not exists (select 'x'
2093: from oe_price_adj_assocs a, oe_price_adjustments b
2094: where a.RLTD_PRICE_ADJ_ID = adj.price_adjustment_id
2095: and b.price_adjustment_id = a.price_adjustment_id
2096: and b.list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE)
2097: UNION