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 9699: FROM qp_event_phases ev, qp_pricing_phases ph

9695: UPDATE qp_npreq_ldets_tmp ldet SET ldet.process_code = G_STATUS_NEW
9696: WHERE ldet.pricing_status_code = G_STATUS_UNCHANGED AND
9697: ldet.applied_flag = G_YES AND
9698: ldet.pricing_phase_id NOT IN (SELECT ev.pricing_phase_id
9699: FROM qp_event_phases ev, qp_pricing_phases ph
9700: , qp_npreq_lines_tmp line
9701: WHERE instr(p_pricing_event, ev.pricing_event_code || ',') > 0
9702: AND ev.pricing_phase_id = ph.pricing_phase_id
9703: AND line.price_flag <> G_CALCULATE_ONLY

Line 10912: , qp_pricing_phases ph

10908: oldprg.list_line_id,
10909: oldprg.updated_flag
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

Line 10967: -- , qp_pricing_phases ph

10963: -- oldprg.list_line_id,
10964: -- oldprg.updated_flag
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

Line 11018: , qp_pricing_phases ph

11014: oldprg.created_from_list_line_id,
11015: oldprg.updated_flag
11016: FROM qp_npreq_lines_tmp buyline
11017: , qp_event_phases ev
11018: , qp_pricing_phases ph
11019: , qp_npreq_ldets_tmp oldprg
11020: , qp_npreq_rltd_lines_tmp oldrltd
11021: , qp_npreq_ldets_tmp oldfgdis
11022: , qp_npreq_lines_tmp oldfreeline

Line 11125: , qp_pricing_phases ph

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

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

12451: --you don't need to match the phase as this will be called after cleanup
12452: --and by the time adjustments w/b picked up from oe_price_adj and ldets
12453: --from the right phases
12454: AND pricing_phase_id in (select ph.pricing_phase_id
12455: from qp_event_phases evt , qp_pricing_phases ph, qp_npreq_lines_tmp line
12456: where ph.pricing_phase_id = evt.pricing_phase_id
12457: and instr(p_pricing_event,evt.pricing_event_code||',') > 0
12458: and line.line_index = ldets.line_index
12459: and (line.price_flag = G_YES