APPS.QP_CLEANUP_ADJUSTMENTS_PVT dependencies on OE_PRICE_ADJ_ASSOCS

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

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

Line 1547: ,oe_price_adj_assocs ass

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

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

1580: and attr.list_line_id = adj.list_line_id
1581: and attr.pricing_attribute_context = QP_PREQ_PUB.G_PRIC_VOLUME_CONTEXT
1582: UNION
1583: SELECT /*+ ORDERED USE_NL(adj_pbh ass adj attr) */
1584: --/*+ index(ass OE_PRICE_ADJ_ASSOCS_N3)*/
1585: -- (adj_pbh.quote_header_id+nvl(adj_pbh.quote_line_id,0)) line_index,
1586: line.line_index,
1587: adj_pbh.line_detail_index line_detail_index,
1588: -- adj.quote_line_id related_line_index,

Line 2099: from oe_price_adj_assocs a, oe_price_adjustments b

2095: and qplh.list_header_id = adj.list_header_id
2096: and qplh.list_type_code not in (QP_PREQ_PUB.G_PRICE_LIST_HEADER,
2097: QP_PREQ_PUB.G_AGR_LIST_HEADER)
2098: and not exists (select 'x'
2099: from oe_price_adj_assocs a, oe_price_adjustments b
2100: where a.RLTD_PRICE_ADJ_ID = adj.price_adjustment_id
2101: and b.price_adjustment_id = a.price_adjustment_id
2102: and b.list_line_type_code = QP_PREQ_GRP.G_PRICE_BREAK_TYPE)
2103: UNION