APPS.QP_MAINTAIN_DENORMALIZED_DATA dependencies on QP_PRICING_ATTRIBUTES

Line 121: and not exists (select 'Y' from qp_pricing_attributes qpa

117: and G_LIST_HEADER_ID_HIGH IS NOT null
118: and qlh.list_header_id between G_LIST_HEADER_ID and G_LIST_HEADER_ID_HIGH)
119: or (G_LIST_HEADER_ID IS NULL)
120: or (G_LIST_HEADER_ID_HIGH IS NULL))
121: and not exists (select 'Y' from qp_pricing_attributes qpa
122: where qpa.list_line_id = ql.list_line_id)
123: and qlh.list_header_id = ql.list_header_id
124: and qlh.active_flag = 'Y'
125: and rownum =1);

Line 133: ,qp_pricing_attributes qpa

129: (pricing_phase_id, product_attribute, product_attr_value)
130: (select
131: distinct ql.pricing_phase_id, qpa.product_attribute, qpa.product_attr_value
132: from qp_rltd_modifiers rltd, qp_list_lines ql, qp_list_headers_b qlh
133: ,qp_pricing_attributes qpa
134: where rltd.rltd_modifier_grp_type = 'BENEFIT'
135: and ql.list_line_id = rltd.to_rltd_modifier_id
136: --and ql.list_line_type_code = 'DIS'
137: and qlh.list_header_id = ql.list_header_id

Line 156: , qp_pricing_attributes qpa

152: select
153: distinct ql.pricing_phase_id, qpa.product_attribute, qpa.product_attr_value
154: from qp_list_lines ql
155: , qp_list_headers_b qlh
156: , qp_pricing_attributes qpa
157: where ql.pricing_phase_id > 1
158: and ql.qualification_ind > 0
159: and ql.list_line_type_code in ('OID', 'PRG', 'RLTD')
160: and qpa.list_line_id = ql.list_line_id

Line 179: , qp_pricing_attributes qpa

175: select
176: distinct ql.pricing_phase_id, qpa.product_attribute, qpa.product_attr_value
177: from qp_list_lines ql
178: , qp_list_headers_b qlh
179: , qp_pricing_attributes qpa
180: where ql.modifier_level_code = 'LINEGROUP'
181: and ql.pricing_phase_id > 1
182: and qpa.list_line_id = ql.list_line_id
183: and qlh.list_header_id = ql.list_header_id

Line 865: Begin code to denormalize qp_pricing_attributes and qp_factor_list_attrs

861:
862: --************************************************************************
863:
864: /***********************************************************************
865: Begin code to denormalize qp_pricing_attributes and qp_factor_list_attrs
866: for Factor Lists only. -rchellam (08/28/01). POSCO change.
867: ***********************************************************************/
868:
869: IF p_update_type IN ('ALL','FACTOR','BATCH')

Line 906: End code to denormalize qp_pricing_attributes and qp_factor_list_attrs

902: END IF;
903:
904: END IF; --If p_update_type in ALL, FACTOR, BATCH
905: /***********************************************************************
906: End code to denormalize qp_pricing_attributes and qp_factor_list_attrs
907: for Factor Lists only. -rchellam (08/28/01). POSCO change.
908: ***********************************************************************/
909:
910: IF p_list_header_id IS NOT NULL

Line 1058: from qp_pricing_attributes

1054: select 1
1055: into l_count
1056: from dual where exists
1057: (select 'x'
1058: from qp_pricing_attributes
1059: where list_line_id = l_list_line_id_tbl(i)
1060: and excluder_flag = 'N');
1061: EXCEPTION
1062: WHEN NO_DATA_FOUND THEN

Line 1076: from qp_pricing_attributes

1072: select 1
1073: into l_count
1074: from dual where exists
1075: (select 'x'
1076: from qp_pricing_attributes
1077: where list_line_id = l_list_line_id_tbl(i)
1078: and pricing_attribute_context is not null
1079: and pricing_attribute is not null
1080: -- changes made per rchellam's request--spgopal

Line 1109: UPDATE qp_pricing_attributes

1105: SET qualification_ind = l_qualification_ind_tbl(j)
1106: WHERE list_line_id = l_list_line_id_tbl(j);
1107:
1108: FORALL k IN l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
1109: UPDATE qp_pricing_attributes
1110: SET qualification_ind = l_qualification_ind_tbl(k)
1111: WHERE list_line_id = l_list_line_id_tbl(k);
1112:
1113: l_total_rows := l_total_rows + SQL%ROWCOUNT;