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 10914: , oe_price_adj_assocs oldrltd

10910: FROM qp_npreq_lines_tmp buyline
10911: , qp_event_phases ev
10912: , qp_pricing_phases ph
10913: , oe_price_adjustments oldprg
10914: , oe_price_adj_assocs oldrltd
10915: , oe_price_adjustments oldfgdis
10916: , qp_npreq_lines_tmp oldfreeline
10917: --where G_REQUEST_TYPE_CODE = 'ONT'
10918: --bug 3085453 handle pricing availability UI

Line 10969: -- , oe_price_adj_assocs oldrltd

10965: -- FROM qp_npreq_lines_tmp buyline
10966: -- , qp_event_phases ev
10967: -- , qp_pricing_phases ph
10968: -- , oe_price_adjustments oldprg
10969: -- , oe_price_adj_assocs oldrltd
10970: -- , oe_price_adjustments oldfgdis
10971: -- , qp_npreq_lines_tmp oldfreeline
10972: --where G_REQUEST_TYPE_CODE = 'ONT'
10973: --bug 3085453 handle pricing availability UI

Line 11072: oe_price_adj_assocs ass, oe_price_adjustments fgdis

11068: prg.price_adjustment_id prg_price_adj_id,
11069: fgdis.price_adjustment_id fg_price_adj_id, fgdis.line_id fg_line_id,
11070: prg.updated_flag
11071: FROM qp_npreq_lines_tmp line, oe_price_adjustments prg,
11072: oe_price_adj_assocs ass, oe_price_adjustments fgdis
11073: WHERE line.line_type_code = G_LINE_LEVEL
11074: AND prg.line_id = line.line_id
11075: AND prg.list_line_type_code = 'PRG'
11076: AND ass.price_adjustment_id = prg.price_adjustment_id

Line 11085: oe_price_adj_assocs ass, oe_price_adjustments fgdis

11081: prg.price_adjustment_id prg_price_adj_id,
11082: fgdis.price_adjustment_id fg_price_adj_id, fgdis.line_id fg_line_id,
11083: prg.updated_flag
11084: FROM qp_npreq_lines_tmp line, oe_price_adjustments prg,
11085: oe_price_adj_assocs ass, oe_price_adjustments fgdis
11086: WHERE line.line_type_code = G_ORDER_LEVEL
11087: AND prg.header_id = line.line_id
11088: AND prg.line_id IS NULL
11089: AND prg.list_line_type_code = 'PRG'

Line 11127: , oe_price_adj_assocs oldrltd

11123: FROM qp_npreq_lines_tmp buyline
11124: , qp_event_phases ev
11125: , qp_pricing_phases ph
11126: , oe_price_adjustments oldprg
11127: , oe_price_adj_assocs oldrltd
11128: , oe_price_adjustments oldfgdis
11129: -- where G_REQUEST_TYPE_CODE = 'ONT'
11130: --bug 3085453 handle pricing availability UI
11131: -- they pass reqtype ONT and insert adj into ldets