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_PRC_CONTEXTS_B

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

2400: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2401:
2402: SELECT nvl(seeded_sourcing_method, user_sourcing_method)
2403: INTO l_sourcing_method
2404: FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c
2405: WHERE c.prc_context_code = 'VOLUME'
2406: AND c.prc_context_type = 'PRICING_ATTRIBUTE'
2407: AND c.prc_context_id = s.prc_context_id
2408: AND s.segment_mapping_column = p_MODIFIERS_rec.accum_attribute

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

2545:
2546: UPDATE qp_pte_segments set used_in_setup='Y'
2547: WHERE nvl(used_in_setup,'N')='N'
2548: AND segment_id IN
2549: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2550: WHERE a.segment_mapping_column=p_MODIFIERS_rec.accum_attribute
2551: AND a.prc_context_id=b.prc_context_id
2552: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
2553: AND b.prc_context_code=v_accum_context);

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

2606: l_pte_code:=nvl(fnd_profile.value('QP_PRICING_TRANSACTION_ENTITY'), 'ORDFUL');
2607:
2608: SELECT nvl(seeded_sourcing_method, user_sourcing_method)
2609: INTO l_sourcing_method
2610: FROM qp_pte_segments ps, qp_segments_b s, qp_prc_contexts_b c
2611: WHERE c.prc_context_code = 'VOLUME'
2612: AND c.prc_context_type = 'PRICING_ATTRIBUTE'
2613: AND c.prc_context_id = s.prc_context_id
2614: AND s.segment_mapping_column = p_MODIFIERS_rec.accum_attribute

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

2866:
2867: UPDATE qp_pte_segments set used_in_setup='Y'
2868: WHERE nvl(used_in_setup,'N')='N'
2869: AND segment_id IN
2870: (SELECT a.segment_id FROM qp_segments_b a,qp_prc_contexts_b b
2871: WHERE a.segment_mapping_column=p_MODIFIERS_rec.accum_attribute
2872: AND a.prc_context_id=b.prc_context_id
2873: AND b.prc_context_type = 'PRICING_ATTRIBUTE'
2874: AND b.prc_context_code=v_accum_context);