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

Line 918: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c

914: update qp_pte_segments set used_in_setup='Y'
915: where nvl(used_in_setup,'N')='N'
916: and segment_id in
917: (select a.segment_id
918: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c
919: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
920: and a.segment_mapping_column = c .qualifier_attribute
921: and a.prc_context_id = b.prc_context_id
922: and b.prc_context_type = 'QUALIFIER'

Line 929: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c

925: update qp_pte_segments d set used_in_setup='Y'
926: where nvl(used_in_setup,'N')='N'
927: and exists
928: (select 'x'
929: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
930: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
931: and a.segment_mapping_column = c.pricing_attribute
932: and a.segment_id = d.segment_id
933: and a.prc_context_id = b.prc_context_id

Line 941: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c

937: update qp_pte_segments d set used_in_setup='Y'
938: where nvl(used_in_setup,'N')='N'
939: and exists
940: (select 'x'
941: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
942: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
943: and a.segment_mapping_column = c.product_attribute
944: and a.segment_id = d.segment_id
945: and a.prc_context_id = b.prc_context_id

Line 953: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c

949: update qp_pte_segments set used_in_setup='Y'
950: where nvl(used_in_setup,'N')='N'
951: and segment_id in
952: (select a.segment_id
953: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c
954: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
955: and a.segment_mapping_column = c.multival_attribute1
956: and a.prc_context_id = b.prc_context_id
957: and b.prc_context_type = c.multival_attr1_type

Line 964: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c

960: update qp_pte_segments set used_in_setup='Y'
961: where nvl(used_in_setup,'N')='N'
962: and segment_id in
963: (select a.segment_id
964: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c
965: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
966: and a.segment_mapping_column = c.multival_attribute2
967: and a.prc_context_id = b.prc_context_id
968: and b.prc_context_type = c.multival_attr2_type

Line 976: from qp_segments_b a,qp_prc_contexts_b b,qp_limit_attributes c,qp_limits d

972: update qp_pte_segments set used_in_setup='Y'
973: where nvl(used_in_setup,'N')='N'
974: and segment_id in
975: (select a.segment_id
976: from qp_segments_b a,qp_prc_contexts_b b,qp_limit_attributes c,qp_limits d
977: where c.limit_id = d.limit_id
978: and d.list_header_id = p_MODIFIER_LIST_rec.list_header_id
979: and a.segment_mapping_column = c.limit_attribute
980: and a.prc_context_id = b.prc_context_id