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_MODIFIERS_UTIL dependencies on QP_SEGMENTS_B

Line 2475: FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c

2471: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2472:
2473: SELECT nvl(user_sourcing_method,seeded_sourcing_method)
2474: INTO l_sourcing_method
2475: FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c
2476: WHERE c.prc_context_code = 'VOLUME'
2477: AND c.prc_context_type = 'PRICING_ATTRIBUTE'
2478: AND c.prc_context_id = s.prc_context_id
2479: AND s.segment_mapping_column = p_MODIFIERS_rec.accum_attribute

Line 2622: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b

2618:
2619: UPDATE qp_pte_segments set used_in_setup='Y'
2620: WHERE nvl(used_in_setup,'N')='N'
2621: AND segment_id IN
2622: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2623: WHERE a.segment_mapping_column=p_MODIFIERS_rec.accum_attribute
2624: AND a.prc_context_id=b.prc_context_id
2625: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
2626: AND b.prc_context_code=v_accum_context);

Line 2683: FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c

2679: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2680:
2681: SELECT nvl(user_sourcing_method,seeded_sourcing_method)
2682: INTO l_sourcing_method
2683: FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c
2684: WHERE c.prc_context_code = 'VOLUME'
2685: AND c.prc_context_type = 'PRICING_ATTRIBUTE'
2686: AND c.prc_context_id = s.prc_context_id
2687: AND s.segment_mapping_column = p_MODIFIERS_rec.accum_attribute

Line 2947: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b

2943:
2944: UPDATE qp_pte_segments set used_in_setup='Y'
2945: WHERE nvl(used_in_setup,'N')='N'
2946: AND segment_id IN
2947: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2948: WHERE a.segment_mapping_column=p_MODIFIERS_rec.accum_attribute
2949: AND a.prc_context_id=b.prc_context_id
2950: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
2951: AND b.prc_context_code=v_accum_context);