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_PRICE_LIST_LINE_UTIL dependencies on QP_PTE_SEGMENTS

Line 1810: UPDATE qp_pte_segments set used_in_setup='Y'

1806: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
1807: IF(p_PRICE_LIST_LINE_rec.break_uom_context IS NOT NULL) AND
1808: (p_PRICE_LIST_LINE_rec.break_uom_attribute IS NOT NULL) THEN
1809:
1810: UPDATE qp_pte_segments set used_in_setup='Y'
1811: WHERE nvl(used_in_setup,'N')='N'
1812: AND segment_id IN
1813: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
1814: WHERE a.segment_mapping_column=p_PRICE_LIST_LINE_rec.break_uom_attribute

Line 2049: UPDATE qp_pte_segments set used_in_setup='Y'

2045: IF (l_check_active_flag='N') OR (l_check_active_flag='Y' AND l_active_flag='Y') THEN
2046: IF(p_PRICE_LIST_LINE_rec.break_uom_context IS NOT NULL) AND
2047: (p_PRICE_LIST_LINE_rec.break_uom_attribute IS NOT NULL) THEN
2048:
2049: UPDATE qp_pte_segments set used_in_setup='Y'
2050: WHERE nvl(used_in_setup,'N')='N'
2051: AND segment_id IN
2052: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2053: WHERE a.segment_mapping_column=p_PRICE_LIST_LINE_rec.break_uom_attribute

Line 4239: qp_prc_contexts_b c, qp_pte_segments d

4235: a_pte_code VARCHAR2, a_attribute VARCHAR2)
4236: IS
4237: SELECT b.segment_code
4238: FROM qp_segments_tl a, qp_segments_b b,
4239: qp_prc_contexts_b c, qp_pte_segments d
4240: WHERE c.prc_context_type = a_context_type
4241: AND c.prc_context_code = a_context_code
4242: AND c.prc_context_id = b.prc_context_id
4243: AND b.segment_mapping_column = a_attribute