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_SEGMENTS_B

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

1024: update qp_pte_segments set used_in_setup='Y'
1025: where nvl(used_in_setup,'N')='N'
1026: and segment_id in
1027: (select a.segment_id
1028: from qp_segments_b a,qp_prc_contexts_b b,qp_qualifiers c
1029: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1030: and a.segment_mapping_column = c .qualifier_attribute
1031: and a.prc_context_id = b.prc_context_id
1032: and b.prc_context_type = 'QUALIFIER'

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

1035: update qp_pte_segments d set used_in_setup='Y'
1036: where nvl(used_in_setup,'N')='N'
1037: and exists
1038: (select 'x'
1039: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
1040: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1041: and a.segment_mapping_column = c.pricing_attribute
1042: and a.segment_id = d.segment_id
1043: and a.prc_context_id = b.prc_context_id

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

1047: update qp_pte_segments d set used_in_setup='Y'
1048: where nvl(used_in_setup,'N')='N'
1049: and exists
1050: (select 'x'
1051: from qp_segments_b a,qp_prc_contexts_b b,qp_pricing_attributes c
1052: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1053: and a.segment_mapping_column = c.product_attribute
1054: and a.segment_id = d.segment_id
1055: and a.prc_context_id = b.prc_context_id

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

1059: update qp_pte_segments set used_in_setup='Y'
1060: where nvl(used_in_setup,'N')='N'
1061: and segment_id in
1062: (select a.segment_id
1063: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c
1064: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1065: and a.segment_mapping_column = c.multival_attribute1
1066: and a.prc_context_id = b.prc_context_id
1067: and b.prc_context_type = c.multival_attr1_type

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

1070: update qp_pte_segments set used_in_setup='Y'
1071: where nvl(used_in_setup,'N')='N'
1072: and segment_id in
1073: (select a.segment_id
1074: from qp_segments_b a,qp_prc_contexts_b b,qp_limits c
1075: where c.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1076: and a.segment_mapping_column = c.multival_attribute2
1077: and a.prc_context_id = b.prc_context_id
1078: and b.prc_context_type = c.multival_attr2_type

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

1082: update qp_pte_segments set used_in_setup='Y'
1083: where nvl(used_in_setup,'N')='N'
1084: and segment_id in
1085: (select a.segment_id
1086: from qp_segments_b a,qp_prc_contexts_b b,qp_limit_attributes c,qp_limits d
1087: where c.limit_id = d.limit_id
1088: and d.list_header_id = p_MODIFIER_LIST_rec.list_header_id
1089: and a.segment_mapping_column = c.limit_attribute
1090: and a.prc_context_id = b.prc_context_id