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 854: Begin code to denormalize qp_pricing_attributes and qp_factor_list_attrs

850:
851: --************************************************************************
852:
853: /***********************************************************************
854: Begin code to denormalize qp_pricing_attributes and qp_factor_list_attrs
855: for Factor Lists only. -rchellam (08/28/01). POSCO change.
856: ***********************************************************************/
857:
858: IF p_update_type IN ('ALL','FACTOR','BATCH')

Line 895: End code to denormalize qp_pricing_attributes and qp_factor_list_attrs

891: END IF;
892:
893: END IF; --If p_update_type in ALL, FACTOR, BATCH
894: /***********************************************************************
895: End code to denormalize qp_pricing_attributes and qp_factor_list_attrs
896: for Factor Lists only. -rchellam (08/28/01). POSCO change.
897: ***********************************************************************/
898:
899: IF p_list_header_id IS NOT NULL

Line 1047: from qp_pricing_attributes

1043: select 1
1044: into l_count
1045: from dual where exists
1046: (select 'x'
1047: from qp_pricing_attributes
1048: where list_line_id = l_list_line_id_tbl(i)
1049: and excluder_flag = 'N');
1050: EXCEPTION
1051: WHEN NO_DATA_FOUND THEN

Line 1065: from qp_pricing_attributes

1061: select 1
1062: into l_count
1063: from dual where exists
1064: (select 'x'
1065: from qp_pricing_attributes
1066: where list_line_id = l_list_line_id_tbl(i)
1067: and pricing_attribute_context is not null
1068: and pricing_attribute is not null
1069: -- changes made per rchellam's request--spgopal

Line 1098: UPDATE qp_pricing_attributes

1094: SET qualification_ind = l_qualification_ind_tbl(j)
1095: WHERE list_line_id = l_list_line_id_tbl(j);
1096:
1097: FORALL k IN l_list_line_id_tbl.FIRST..l_list_line_id_tbl.LAST
1098: UPDATE qp_pricing_attributes
1099: SET qualification_ind = l_qualification_ind_tbl(k)
1100: WHERE list_line_id = l_list_line_id_tbl(k);
1101:
1102: l_total_rows := l_total_rows + SQL%ROWCOUNT;