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_CLEANUP_ADJUSTMENTS_PVT dependencies on QP_PRICING_PHASES

Line 1564: from qp_event_phases evt , qp_pricing_phases ph

1560: or adj_pbh.updated_flag = QP_PREQ_PUB.G_YES
1561: or p_event_code = ',' --we pad comma when it is null
1562: or adj_pbh.pricing_phase_id not in
1563: (select ph.pricing_phase_id
1564: from qp_event_phases evt , qp_pricing_phases ph
1565: where ph.pricing_phase_id = evt.pricing_phase_id
1566: ---introduced the end date condition for bug 8976668 condition was missed during the fix of 3376902
1567: and (evt.end_date_active is null or (evt.end_date_active is not null and evt.end_date_active > line.pricing_effective_date))
1568: --introduced for freight_rating functionality to return only modifiers in

Line 1629: from qp_event_phases evt, qp_pricing_phases ph

1625: or adj_pbh.updated_flag = QP_PREQ_PUB.G_YES
1626: or p_event_code = ',' --we pad comma when it is null
1627: or adj_pbh.pricing_phase_id not in
1628: (select ph.pricing_phase_id
1629: from qp_event_phases evt, qp_pricing_phases ph
1630: where ph.pricing_phase_id = evt.pricing_phase_id
1631: --introduced for freight_rating functionality to return only modifiers in
1632: --phases where freight_exist = 'Y' if G_GET_FREIGHT_FLAG = 'Y'
1633: and ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES

Line 1665: from qp_event_phases evt, qp_pricing_phases ph

1661: or adj.updated_flag = QP_PREQ_PUB.G_YES
1662: or p_event_code = ',' -- we pad ',' when it is null
1663: or adj.pricing_phase_id not in
1664: (select ph.pricing_phase_id
1665: from qp_event_phases evt, qp_pricing_phases ph
1666: where ph.pricing_phase_id = evt.pricing_phase_id
1667: --introduced for freight_rating functionality to return only modifiers in
1668: --phases where freight_exist = 'Y' if G_GET_FREIGHT_FLAG = 'Y'
1669: and ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES

Line 1694: from qp_event_phases evt, qp_pricing_phases ph

1690: or line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
1691: or p_event_code = ',' -- we pad ',' when it is null
1692: or adj.pricing_phase_id not in
1693: (select ph.pricing_phase_id
1694: from qp_event_phases evt, qp_pricing_phases ph
1695: where ph.pricing_phase_id = evt.pricing_phase_id
1696: --introduced for freight_rating functionality to return only modifiers in
1697: --phases where freight_exist = 'Y' if G_GET_FREIGHT_FLAG = 'Y'
1698: and ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES

Line 1723: from qp_event_phases evt, qp_pricing_phases ph

1719: or line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
1720: or p_event_code = ',' -- we pad ',' when it is null
1721: or adj.pricing_phase_id not in
1722: (select ph.pricing_phase_id
1723: from qp_event_phases evt, qp_pricing_phases ph
1724: where ph.pricing_phase_id = evt.pricing_phase_id
1725: --introduced for freight_rating functionality to return only modifiers in
1726: --phases where freight_exist = 'Y' if G_GET_FREIGHT_FLAG = 'Y'
1727: and ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES

Line 2073: from qp_event_phases ev, qp_pricing_phases ph

2069: and (adj.updated_flag = QP_PREQ_PUB.G_YES
2070: or line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
2071: or (p_event_code is null and adj.updated_flag is null)
2072: or adj.pricing_phase_id not in (select ph.pricing_phase_id
2073: from qp_event_phases ev, qp_pricing_phases ph
2074: --changes to enable multiple events passed as a string
2075: where ph.pricing_phase_id = ev.pricing_phase_id
2076: ---introduced the end date condition for bug 3376902
2077: and (ev.end_date_active is null or (ev.end_date_active is not null and ev.end_date_active > line.pricing_effective_date))

Line 2191: from qp_event_phases ev, qp_pricing_phases ph

2187: and (adj.updated_flag = QP_PREQ_PUB.G_YES
2188: or line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
2189: or (p_event_code is null and adj.updated_flag is null)
2190: or adj.pricing_phase_id not in (select ph.pricing_phase_id
2191: from qp_event_phases ev, qp_pricing_phases ph
2192: --changes to enable multiple events passed as a string
2193: where ph.pricing_phase_id = ev.pricing_phase_id
2194: ---introduced the end date condition for bug 3376902
2195: and (ev.end_date_active is null or (ev.end_date_active is not null and ev.end_date_active > line.pricing_effective_date))

Line 2472: from qp_event_phases ev, qp_pricing_phases ph

2468: and (ldet.updated_flag = QP_PREQ_PUB.G_YES
2469: or line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
2470: -- or (p_event_code is null and ldet.updated_flag is null)
2471: or ldet.pricing_phase_id not in (select ph.pricing_phase_id
2472: from qp_event_phases ev, qp_pricing_phases ph
2473: --changes to enable multiple events passed as a string
2474: where ph.pricing_phase_id = ev.pricing_phase_id
2475: ---introduced the end date condition for bug 3376902
2476: and (ev.end_date_active is null or (ev.end_date_active is not null and ev.end_date_active > line.pricing_effective_date))

Line 2586: from qp_event_phases ev, qp_pricing_phases ph

2582: and (ldet.updated_flag = QP_PREQ_PUB.G_YES
2583: or line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
2584: -- or (p_event_code is null and ldet.updated_flag is null)
2585: or ldet.pricing_phase_id not in (select ph.pricing_phase_id
2586: from qp_event_phases ev, qp_pricing_phases ph
2587: --changes to enable multiple events passed as a string
2588: where ph.pricing_phase_id = ev.pricing_phase_id
2589: ---introduced the end date condition for bug 3376902
2590: and (ev.end_date_active is null or (ev.end_date_active is not null and ev.end_date_active > line.pricing_effective_date))