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 QP_PRICING_PHASES

Line 84: FROM QP_PRICING_PHASES

80: indxno index used
81: */
82: CURSOR l_init_pricelist_phase_cur IS
83: SELECT PHASE_SEQUENCE, PRICING_PHASE_ID
84: FROM QP_PRICING_PHASES
85: WHERE LIST_TYPE_CODE = 'PRL'
86: AND ROWNUM < 2;
87:
88: /*

Line 89: INDX,QP_PREQ_PUB.initialize_constants.l_check_pricing_phase_exists,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1

85: WHERE LIST_TYPE_CODE = 'PRL'
86: AND ROWNUM < 2;
87:
88: /*
89: INDX,QP_PREQ_PUB.initialize_constants.l_check_pricing_phase_exists,QP_PRICING_PHASES_U1,PRICING_PHASE_ID,1
90: INDX,QP_PREQ_PUB.initialize_constants.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_EVENT_CODE,1
91: INDX,QP_PREQ_PUB.initialize_constants.l_check_pricing_phase_exists,QP_EVENT_PHASES_U1,PRICING_PHASE_ID,1
92: */
93: CURSOR l_check_pricing_phase_exists(p_event VARCHAR2) IS

Line 96: FROM qp_event_phases a, qp_pricing_phases b

92: */
93: CURSOR l_check_pricing_phase_exists(p_event VARCHAR2) IS
94: SELECT b.pricing_phase_id
95: , nvl(b.user_freeze_override_flag, b.freeze_override_flag)
96: FROM qp_event_phases a, qp_pricing_phases b
97: WHERE instr(p_event, a.pricing_event_code || ',') > 0
98: AND ((G_GET_FREIGHT_FLAG = G_YES AND b.freight_exists = G_YES)
99: OR (G_GET_FREIGHT_FLAG = G_NO))
100: AND a.pricing_phase_id = G_PRICE_LIST_PHASE_ID

Line 1575: FROM qp_event_phases ev, qp_pricing_phases ph

1571: OR line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
1572: OR (p_event_code IS NULL AND adj.updated_flag IS NULL)
1573: OR (adj.list_line_type_code = 'PRG'
1574: AND adj.pricing_phase_id IN (SELECT ph.pricing_phase_id
1575: FROM qp_event_phases ev, qp_pricing_phases ph
1576: WHERE ph.pricing_phase_id = ev.pricing_phase_id
1577: AND ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES
1578: AND ph.freight_exists = QP_PREQ_PUB.G_YES)
1579: OR (QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_NO))

Line 1587: FROM qp_event_phases ev, qp_pricing_phases ph

1583: AND (line.price_flag = QP_PREQ_PUB.G_YES
1584: OR (line.price_flag = QP_PREQ_PUB.G_PHASE
1585: AND nvl(ph.user_freeze_override_flag, ph.freeze_override_flag) = QP_PREQ_PUB.G_YES))))
1586: OR adj.pricing_phase_id NOT IN (SELECT ph.pricing_phase_id
1587: FROM qp_event_phases ev, qp_pricing_phases ph
1588: WHERE ph.pricing_phase_id = ev.pricing_phase_id
1589: AND ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES
1590: AND ph.freight_exists = QP_PREQ_PUB.G_YES)
1591: OR (QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_NO))

Line 1692: FROM qp_event_phases ev, qp_pricing_phases ph

1688: OR line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
1689: OR (p_event_code IS NULL AND adj.updated_flag IS NULL)
1690: OR adj.pricing_phase_id NOT IN
1691: (SELECT ph.pricing_phase_id
1692: FROM qp_event_phases ev, qp_pricing_phases ph
1693: WHERE ph.pricing_phase_id = ev.pricing_phase_id
1694: AND ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES
1695: AND ph.freight_exists = QP_PREQ_PUB.G_YES)
1696: OR (QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_NO))

Line 1735: FROM qp_event_phases evt, qp_pricing_phases ph

1731: OR adj_pbh.updated_flag = QP_PREQ_PUB.G_YES
1732: OR p_event_code = ',' --we pad comma when it is null
1733: OR adj_pbh.pricing_phase_id NOT IN
1734: (SELECT ph.pricing_phase_id
1735: FROM qp_event_phases evt, qp_pricing_phases ph
1736: WHERE ph.pricing_phase_id = evt.pricing_phase_id
1737: --introduced for freight_rating functionality to return only modifiers in
1738: --phases where freight_exist = 'Y' if G_GET_FREIGHT_FLAG = 'Y'
1739: AND ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES

Line 1777: FROM qp_event_phases evt, qp_pricing_phases ph

1773: AND line.line_id = adj_prg.line_id
1774: AND adj_prg.list_line_type_code = G_PROMO_GOODS_DISCOUNT
1775: AND adj_prg.pricing_phase_id IN
1776: (SELECT ph.pricing_phase_id
1777: FROM qp_event_phases evt, qp_pricing_phases ph
1778: WHERE ph.pricing_phase_id = evt.pricing_phase_id
1779: AND instr(p_event_code, evt.pricing_event_code || ',') > 0
1780: AND (line.price_flag = QP_PREQ_PUB.G_YES
1781: OR (line.price_flag = QP_PREQ_PUB.G_PHASE

Line 1804: FROM qp_event_phases evt, qp_pricing_phases ph

1800: OR adj.updated_flag = QP_PREQ_PUB.G_YES
1801: OR p_event_code = ',' -- we pad ',' when it is null
1802: OR adj.pricing_phase_id NOT IN
1803: (SELECT ph.pricing_phase_id
1804: FROM qp_event_phases evt, qp_pricing_phases ph
1805: WHERE ph.pricing_phase_id = evt.pricing_phase_id
1806: --introduced for freight_rating functionality to return only modifiers in
1807: --phases where freight_exist = 'Y' if G_GET_FREIGHT_FLAG = 'Y'
1808: AND ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES

Line 1829: FROM qp_event_phases evt, qp_pricing_phases ph

1825: OR line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
1826: OR p_event_code = ',' -- we pad ',' when it is null
1827: OR adj.pricing_phase_id NOT IN
1828: (SELECT ph.pricing_phase_id
1829: FROM qp_event_phases evt, qp_pricing_phases ph
1830: WHERE ph.pricing_phase_id = evt.pricing_phase_id
1831: --introduced for freight_rating functionality to return only modifiers in
1832: --phases where freight_exist = 'Y' if G_GET_FREIGHT_FLAG = 'Y'
1833: AND ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES

Line 1853: FROM qp_event_phases evt, qp_pricing_phases ph

1849: AND line.line_type_code = QP_PREQ_PUB.G_LINE_LEVEL
1850: AND adj.list_line_type_code = 'PRG'
1851: AND adj.pricing_phase_id IN
1852: (SELECT ph.pricing_phase_id
1853: FROM qp_event_phases evt, qp_pricing_phases ph
1854: WHERE ph.pricing_phase_id = evt.pricing_phase_id
1855: AND instr(p_event_code, evt.pricing_event_code || ',') > 0
1856: AND (line.price_flag = QP_PREQ_PUB.G_YES
1857: OR (line.price_flag = QP_PREQ_PUB.G_PHASE

Line 9620: FROM qp_event_phases ev, qp_pricing_phases ph

9616: UPDATE qp_npreq_ldets_tmp ldet SET ldet.process_code = G_STATUS_NEW
9617: WHERE ldet.pricing_status_code = G_STATUS_UNCHANGED AND
9618: ldet.applied_flag = G_YES AND
9619: ldet.pricing_phase_id NOT IN (SELECT ev.pricing_phase_id
9620: FROM qp_event_phases ev, qp_pricing_phases ph
9621: , qp_npreq_lines_tmp line
9622: WHERE instr(p_pricing_event, ev.pricing_event_code || ',') > 0
9623: AND ev.pricing_phase_id = ph.pricing_phase_id
9624: AND line.price_flag <> G_CALCULATE_ONLY

Line 10833: , qp_pricing_phases ph

10829: oldprg.list_line_id,
10830: oldprg.updated_flag
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

Line 10884: , qp_pricing_phases ph

10880: oldprg.list_line_id,
10881: oldprg.updated_flag
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

Line 10934: , qp_pricing_phases ph

10930: oldprg.created_from_list_line_id,
10931: oldprg.updated_flag
10932: FROM qp_npreq_lines_tmp buyline
10933: , qp_event_phases ev
10934: , qp_pricing_phases ph
10935: , qp_npreq_ldets_tmp oldprg
10936: , qp_npreq_rltd_lines_tmp oldrltd
10937: , qp_npreq_ldets_tmp oldfgdis
10938: , qp_npreq_lines_tmp oldfreeline

Line 11038: , qp_pricing_phases ph

11034: , oldprg.list_line_id, oldfgdis.line_id
11035: , oldprg.updated_flag
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'

Line 12298: from qp_event_phases evt , qp_pricing_phases ph, qp_npreq_lines_tmp line

12294: --you don't need to match the phase as this will be called after cleanup
12295: --and by the time adjustments w/b picked up from oe_price_adj and ldets
12296: --from the right phases
12297: AND pricing_phase_id in (select ph.pricing_phase_id
12298: from qp_event_phases evt , qp_pricing_phases ph, qp_npreq_lines_tmp line
12299: where ph.pricing_phase_id = evt.pricing_phase_id
12300: and instr(p_pricing_event,evt.pricing_event_code||',') > 0
12301: and line.line_index = ldets.line_index
12302: and (line.price_flag = G_YES