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_EVENT_PHASES

Line 1560: from qp_event_phases evt , qp_pricing_phases ph

1556: or adj_pbh.updated_flag = QP_PREQ_PUB.G_YES
1557: or p_event_code = ',' --we pad comma when it is null
1558: or adj_pbh.pricing_phase_id not in
1559: (select ph.pricing_phase_id
1560: from qp_event_phases evt , qp_pricing_phases ph
1561: where ph.pricing_phase_id = evt.pricing_phase_id
1562: --introduced for freight_rating functionality to return only modifiers in
1563: --phases where freight_exist = 'Y' if G_GET_FREIGHT_FLAG = 'Y'
1564: and ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES

Line 1623: from qp_event_phases evt, qp_pricing_phases ph

1619: or adj_pbh.updated_flag = QP_PREQ_PUB.G_YES
1620: or p_event_code = ',' --we pad comma when it is null
1621: or adj_pbh.pricing_phase_id not in
1622: (select ph.pricing_phase_id
1623: from qp_event_phases evt, qp_pricing_phases ph
1624: where ph.pricing_phase_id = evt.pricing_phase_id
1625: --introduced for freight_rating functionality to return only modifiers in
1626: --phases where freight_exist = 'Y' if G_GET_FREIGHT_FLAG = 'Y'
1627: and ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES

Line 1659: from qp_event_phases evt, qp_pricing_phases ph

1655: or adj.updated_flag = QP_PREQ_PUB.G_YES
1656: or p_event_code = ',' -- we pad ',' when it is null
1657: or adj.pricing_phase_id not in
1658: (select ph.pricing_phase_id
1659: from qp_event_phases evt, qp_pricing_phases ph
1660: where ph.pricing_phase_id = evt.pricing_phase_id
1661: --introduced for freight_rating functionality to return only modifiers in
1662: --phases where freight_exist = 'Y' if G_GET_FREIGHT_FLAG = 'Y'
1663: and ((QP_PREQ_PUB.G_GET_FREIGHT_FLAG = QP_PREQ_PUB.G_YES

Line 1688: from qp_event_phases evt, qp_pricing_phases ph

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

Line 1717: from qp_event_phases evt, qp_pricing_phases ph

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

Line 2067: from qp_event_phases ev, qp_pricing_phases ph

2063: and (adj.updated_flag = QP_PREQ_PUB.G_YES
2064: or line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
2065: or (p_event_code is null and adj.updated_flag is null)
2066: or adj.pricing_phase_id not in (select ph.pricing_phase_id
2067: from qp_event_phases ev, qp_pricing_phases ph
2068: --changes to enable multiple events passed as a string
2069: where ph.pricing_phase_id = ev.pricing_phase_id
2070: ---introduced the end date condition for bug 3376902
2071: 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 2185: from qp_event_phases ev, qp_pricing_phases ph

2181: and (adj.updated_flag = QP_PREQ_PUB.G_YES
2182: or line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
2183: or (p_event_code is null and adj.updated_flag is null)
2184: or adj.pricing_phase_id not in (select ph.pricing_phase_id
2185: from qp_event_phases ev, qp_pricing_phases ph
2186: --changes to enable multiple events passed as a string
2187: where ph.pricing_phase_id = ev.pricing_phase_id
2188: ---introduced the end date condition for bug 3376902
2189: 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 2466: from qp_event_phases ev, qp_pricing_phases ph

2462: and (ldet.updated_flag = QP_PREQ_PUB.G_YES
2463: or line.price_flag = QP_PREQ_PUB.G_CALCULATE_ONLY
2464: -- or (p_event_code is null and ldet.updated_flag is null)
2465: or ldet.pricing_phase_id not in (select ph.pricing_phase_id
2466: from qp_event_phases ev, qp_pricing_phases ph
2467: --changes to enable multiple events passed as a string
2468: where ph.pricing_phase_id = ev.pricing_phase_id
2469: ---introduced the end date condition for bug 3376902
2470: 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 2580: from qp_event_phases ev, qp_pricing_phases ph

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