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_PREQ_GRP dependencies on QP_PRC_CONTEXTS_B

Line 31003: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS

30999: WHERE attribute_type IN ('PRICING', 'PRODUCT')
31000: AND pricing_status_code = G_STATUS_UNCHANGED
31001: AND EXISTS (SELECT format_type
31002: FROM fnd_flex_value_sets VSET,
31003: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
31004: WHERE vset.flex_value_set_id = segments.user_valueset_id
31005: AND segments.application_id = 661
31006: AND pcontexts.prc_context_type <> 'QUALIFIER'
31007: AND pcontexts.prc_context_code = lattr.context

Line 31023: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS

31019: WHERE attribute_type IN ('PRICING', 'PRODUCT', 'QUALIFIER')
31020: AND pricing_status_code = G_STATUS_UNCHANGED
31021: AND EXISTS (SELECT format_type
31022: FROM fnd_flex_value_sets VSET,
31023: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
31024: WHERE vset.flex_value_set_id = segments.user_valueset_id
31025: AND segments.application_id = 661
31026: AND pcontexts.prc_context_code = lattr.context
31027: AND segments.segment_mapping_column = lattr.attribute

Line 31037: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS , qp_segments_tl SEGMENTS_TL

31033: IS
31034: SELECT lattr.value_from,lattr.context,
31035: nvl(SEGMENTS_TL.SEEDED_SEGMENT_NAME,SEGMENTS_TL.USER_SEGMENT_NAME) attribute
31036: FROM qp_npreq_line_attrs_tmp lattr, fnd_flex_value_sets VSET,
31037: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS , qp_segments_tl SEGMENTS_TL
31038: WHERE attribute_type IN ('PRICING', 'PRODUCT', 'QUALIFIER')
31039: AND pricing_status_code = G_STATUS_UNCHANGED
31040: AND vset.flex_value_set_id = segments.user_valueset_id
31041: AND segments.application_id = 661

Line 31228: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS

31224: AND pricing_status_code = G_STATUS_UNCHANGED
31225: AND NOT EXISTS (
31226: SELECT format_type
31227: FROM fnd_flex_value_sets VSET,
31228: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
31229: WHERE vset.flex_value_set_id = segments.user_valueset_id
31230: AND segments.application_id = 661
31231: AND pcontexts.prc_context_type = decode(lattr.attribute_type,'PRICING','PRICING_ATTRIBUTE',
31232: lattr.attribute_type) -- Changed for bug2806857

Line 31881: qp_prc_contexts_b qpc,

31877: ,qnlat.PRIMARY_UOM_FLAG
31878: ,qnlat.REQUEST_ID
31879: ,'Y'
31880: FROM qp_npreq_line_attrs_tmp qnlat,
31881: qp_prc_contexts_b qpc,
31882: qp_segments_b qs,
31883: HZ_HIERARCHY_NODES hn
31884: WHERE qnlat.pricing_status_code = G_STATUS_UNCHANGED
31885: AND qnlat.attribute_type = G_QUALIFIER_TYPE

Line 32378: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS, qp_segments_tl SEGMENTS_TL

32374: IS
32375: SELECT lattr.value_from,lattr.value_to,lattr.context,
32376: nvl(SEGMENTS_TL.SEEDED_SEGMENT_NAME,SEGMENTS_TL.USER_SEGMENT_NAME) attribute
32377: FROM qp_npreq_line_attrs_tmp lattr,fnd_flex_value_sets VSET,
32378: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS, qp_segments_tl SEGMENTS_TL
32379: WHERE attribute_type = G_PRICING_TYPE
32380: AND pricing_status_code = G_STATUS_UNCHANGED
32381: AND vset.flex_value_set_id = segments.user_valueset_id
32382: AND segments.application_id = 661

Line 33015: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS

33011: AND pricing_status_code = G_STATUS_UNCHANGED
33012: AND exists (
33013: SELECT format_type
33014: FROM fnd_flex_value_sets VSET,
33015: qp_segments_b SEGMENTS, qp_prc_contexts_b PCONTEXTS
33016: WHERE vset.flex_value_set_id = segments.user_valueset_id
33017: AND segments.application_id = 661
33018: AND pcontexts.prc_context_type <> 'QUALIFIER'
33019: AND pcontexts.prc_context_code = lattr.context