APPS.QP_MAINTAIN_DENORMALIZED_DATA dependencies on QP_ADV_MOD_PRODUCTS

Line 105: delete from qp_adv_mod_products;

101: --added for bug 5237249
102: --delete should not happen for parallel threads from qpxsourc.sql
103: --otherwise it will delete the previous worker's rows
104: --moved the delete to qpxsourc.sql
105: delete from qp_adv_mod_products;
106: end if;
107:
108: insert into qp_adv_mod_products
109: (pricing_phase_id, product_attribute, product_attr_value)

Line 108: insert into qp_adv_mod_products

104: --moved the delete to qpxsourc.sql
105: delete from qp_adv_mod_products;
106: end if;
107:
108: insert into qp_adv_mod_products
109: (pricing_phase_id, product_attribute, product_attr_value)
110: (select /*+ ORDERED USE_NL(qlh) */ ql.pricing_phase_id, 'PRICING_ATTRIBUTE3', 'ALL_ITEMS'
111: from qp_list_lines ql, qp_list_headers_b qlh
112: where ql.qualification_ind = 0

Line 128: insert into qp_adv_mod_products

124: and qlh.active_flag = 'Y'
125: and rownum =1);
126:
127: --Removed hints from the sql to make it more cost effective.
128: insert into qp_adv_mod_products
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

Line 147: and not exists (select 'Y' from qp_adv_mod_products item

143: or (G_LIST_HEADER_ID_HIGH IS NULL))
144: and qlh.active_flag = 'Y'
145: --and qlh.list_type_code in ( 'DEL', 'PRO')
146: and qpa.list_line_id = ql.list_line_id
147: and not exists (select 'Y' from qp_adv_mod_products item
148: where item.pricing_phase_id = qpa.pricing_phase_id
149: and item.product_attribute = qpa.product_attribute
150: and item.product_attr_value = qpa.product_attr_value)
151: UNION

Line 170: and not exists (select 'Y' from qp_adv_mod_products item

166: and qlh.list_header_id between G_LIST_HEADER_ID and G_LIST_HEADER_ID_HIGH)
167: or (G_LIST_HEADER_ID IS NULL)
168: or (G_LIST_HEADER_ID_HIGH IS NULL))
169: and qlh.list_type_code in ('DLT', 'SLT', 'DEL', 'PRO', 'CHARGES')
170: and not exists (select 'Y' from qp_adv_mod_products item
171: where item.pricing_phase_id = qpa.pricing_phase_id
172: and item.product_attribute = qpa.product_attribute
173: and item.product_attr_value = qpa.product_attr_value)
174: UNION

Line 192: and not exists (select 'Y' from qp_adv_mod_products item

188: and qlh.list_header_id between G_LIST_HEADER_ID and G_LIST_HEADER_ID_HIGH)
189: or (G_LIST_HEADER_ID IS NULL)
190: or (G_LIST_HEADER_ID_HIGH IS NULL))
191: and qlh.list_type_code in ('DLT', 'SLT', 'DEL', 'PRO', 'CHARGES')
192: and not exists (select 'Y' from qp_adv_mod_products item
193: where item.pricing_phase_id = qpa.pricing_phase_id
194: and item.product_attribute = qpa.product_attribute
195: and item.product_attr_value = qpa.product_attr_value));
196:

Line 787: --To update qp_adv_mod_products for changed lines

783:
784: begin
785:
786: --*************************************************************************
787: --To update qp_adv_mod_products for changed lines
788: --*************************************************************************
789:
790: IF P_UPDATE_TYPE in ('HVOP_PRICING_SETUP','ALL')
791: and QP_CODE_CONTROL.Get_Code_Release_Level > '110509' THEN

Line 802: --To update qp_adv_mod_products for changed lines

798: END IF;
799: END IF;--P_UPDATE_TYPE = 'HVOP_PRICING_SETUP'
800:
801: --*************************************************************************
802: --To update qp_adv_mod_products for changed lines
803: --*************************************************************************
804:
805: IF P_UPDATE_TYPE in ('BATCH_ADV_MOD_PRODUCTS', 'ADV_MOD_PRODUCTS','ALL')
806: and QP_CODE_CONTROL.Get_Code_Release_Level > '110508' THEN