eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_PREQ_PUB dependencies on OE_PRICE_ADJ_ASSOCS

Line 1605: -- from oe_price_adj_assocs a

1601: AND qplh.list_type_code NOT IN (QP_PREQ_PUB.G_PRICE_LIST_HEADER,
1602: QP_PREQ_PUB.G_AGR_LIST_HEADER)
1603: --commented out because we want to fetch PBH childs and PRG freeline adjs
1604: --and not exists (select 'x'
1605: -- from oe_price_adj_assocs a
1606: -- where a.RLTD_PRICE_ADJ_ID = adj.price_adjustment_id)
1607: UNION ALL
1608: SELECT /*+ ORDERED USE_NL(adj qplh) */
1609: adj.price_adjustment_id line_detail_index

Line 1709: SELECT /+ index(ass OE_PRICE_ADJ_ASSOCS_N1)/ --[julin/4865213] changed from N3 to N1

1705: AND qplh.list_header_id = adj.list_header_id
1706: AND qplh.list_type_code NOT IN (QP_PREQ_PUB.G_PRICE_LIST_HEADER, QP_PREQ_PUB.G_AGR_LIST_HEADER);
1707:
1708: CURSOR l_rltd_lines_cur(pbh_exist_flag VARCHAR2, prg_exist_flag VARCHAR2) IS
1709: SELECT /*+ index(ass OE_PRICE_ADJ_ASSOCS_N1)*/ --[julin/4865213] changed from N3 to N1
1710: line.line_index line_index,
1711: ass.price_adjustment_id line_detail_index,
1712: QP_PREQ_PUB.G_PBH_LINE relationship_type_code,
1713: line.line_index related_line_index,

Line 1720: , oe_price_adj_assocs ass

1716: adj.list_line_id related_list_line_id,
1717: 'INSERTED FOR CALCULATION' pricing_status_text
1718: FROM qp_int_lines line
1719: , oe_price_adjustments adj_pbh
1720: , oe_price_adj_assocs ass
1721: , oe_price_adjustments adj
1722: , qp_pricing_attributes attr
1723: WHERE pbh_exist_flag = 'Y'
1724: AND QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 1754: SELECT /+ ordered index(ass OE_PRICE_ADJ_ASSOCS_N1)/ --[julin/4865213] changed from N3 to N1, ordered

1750: AND ass.rltd_price_adj_id = adj.price_adjustment_id
1751: AND attr.list_line_id = adj.list_line_id
1752: AND attr.pricing_attribute_context = QP_PREQ_PUB.G_PRIC_VOLUME_CONTEXT
1753: UNION ALL
1754: SELECT /*+ ordered index(ass OE_PRICE_ADJ_ASSOCS_N1)*/ --[julin/4865213] changed from N3 to N1, ordered
1755: line.line_index line_index,
1756: adj_prg.price_adjustment_id line_detail_index,
1757: QP_PREQ_PUB.G_GENERATED_LINE relationship_type_code,
1758: getline.line_index related_line_index,

Line 1765: , oe_price_adj_assocs ass

1761: adj.list_line_id related_list_line_id,
1762: 'INSERTED FOR CALCULATION' pricing_status_text
1763: FROM qp_int_lines line
1764: , oe_price_adjustments adj_prg
1765: , oe_price_adj_assocs ass
1766: , oe_price_adjustments adj
1767: , qp_int_lines getline
1768: WHERE prg_exist_flag = 'Y'
1769: AND QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES

Line 1926: qp_int_ldets ldet, oe_price_adj_assocs ass

1922: , NULL BREAK_UOM_CONTEXT
1923: , NULL BREAK_UOM_ATTRIBUTE
1924: , NULL PROCESS_CODE -- 3215497
1925: FROM qp_int_lines getline, oe_price_adjustments adj,
1926: qp_int_ldets ldet, oe_price_adj_assocs ass
1927: WHERE QP_PREQ_PUB.G_CHECK_CUST_VIEW_FLAG = QP_PREQ_PUB.G_YES
1928: AND ldet.CREATED_FROM_LIST_LINE_TYPE = 'PRG'
1929: AND ass.price_adjustment_id = ldet.price_adjustment_id
1930: AND ass.rltd_price_adj_id = adj.price_adjustment_id

Line 10835: , oe_price_adj_assocs oldrltd

10831: FROM qp_npreq_lines_tmp buyline
10832: , qp_event_phases ev
10833: , qp_pricing_phases ph
10834: , oe_price_adjustments oldprg
10835: , oe_price_adj_assocs oldrltd
10836: , oe_price_adjustments oldfgdis
10837: , qp_npreq_lines_tmp oldfreeline
10838: --where G_REQUEST_TYPE_CODE = 'ONT'
10839: --bug 3085453 handle pricing availability UI

Line 10886: , oe_price_adj_assocs oldrltd

10882: FROM qp_npreq_lines_tmp buyline
10883: , qp_event_phases ev
10884: , qp_pricing_phases ph
10885: , oe_price_adjustments oldprg
10886: , oe_price_adj_assocs oldrltd
10887: , oe_price_adjustments oldfgdis
10888: , qp_npreq_lines_tmp oldfreeline
10889: --where G_REQUEST_TYPE_CODE = 'ONT'
10890: --bug 3085453 handle pricing availability UI

Line 10986: oe_price_adj_assocs ass, oe_price_adjustments fgdis

10982: prg.price_adjustment_id prg_price_adj_id,
10983: fgdis.price_adjustment_id fg_price_adj_id, fgdis.line_id fg_line_id,
10984: prg.updated_flag
10985: FROM qp_npreq_lines_tmp line, oe_price_adjustments prg,
10986: oe_price_adj_assocs ass, oe_price_adjustments fgdis
10987: WHERE line.line_type_code = G_LINE_LEVEL
10988: AND prg.line_id = line.line_id
10989: AND prg.list_line_type_code = 'PRG'
10990: AND ass.price_adjustment_id = prg.price_adjustment_id

Line 10999: oe_price_adj_assocs ass, oe_price_adjustments fgdis

10995: prg.price_adjustment_id prg_price_adj_id,
10996: fgdis.price_adjustment_id fg_price_adj_id, fgdis.line_id fg_line_id,
10997: prg.updated_flag
10998: FROM qp_npreq_lines_tmp line, oe_price_adjustments prg,
10999: oe_price_adj_assocs ass, oe_price_adjustments fgdis
11000: WHERE line.line_type_code = G_ORDER_LEVEL
11001: AND prg.header_id = line.line_id
11002: AND prg.line_id IS NULL
11003: AND prg.list_line_type_code = 'PRG'

Line 11040: , oe_price_adj_assocs oldrltd

11036: FROM qp_npreq_lines_tmp buyline
11037: , qp_event_phases ev
11038: , qp_pricing_phases ph
11039: , oe_price_adjustments oldprg
11040: , oe_price_adj_assocs oldrltd
11041: , oe_price_adjustments oldfgdis
11042: -- where G_REQUEST_TYPE_CODE = 'ONT'
11043: --bug 3085453 handle pricing availability UI
11044: -- they pass reqtype ONT and insert adj into ldets