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 1815: UPDATE qp_pte_segments set used_in_setup='Y'

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

Line 2054: UPDATE qp_pte_segments set used_in_setup='Y'

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

Line 4385: qp_prc_contexts_b c, qp_pte_segments d

4381: a_pte_code VARCHAR2, a_attribute VARCHAR2)
4382: IS
4383: SELECT b.segment_code
4384: FROM qp_segments_tl a, qp_segments_b b,
4385: qp_prc_contexts_b c, qp_pte_segments d
4386: WHERE c.prc_context_type = a_context_type
4387: AND c.prc_context_code = a_context_code
4388: AND c.prc_context_id = b.prc_context_id
4389: AND b.segment_mapping_column = a_attribute