APPS.AML_CATEGORY_MIGRATION dependencies on AS_INTEREST_CODES_B

Line 187: FROM as_interest_codes_b pic

183: UNION
184: SELECT lead.interest_type_id||'/'||lead.primary_interest_code_id code
185: FROM as_sales_lead_lines lead
186: WHERE lead.primary_interest_code_id not in (SELECT pic.interest_code_id
187: FROM as_interest_codes_b pic
188: WHERE pic.parent_interest_code_id IS null)
189: UNION
190: SELECT lead.interest_type_id||'/'||lead.primary_interest_code_id||'/'||lead.secondary_interest_code_id code
191: FROM as_sales_lead_lines lead

Line 193: FROM as_interest_codes_b sic

189: UNION
190: SELECT lead.interest_type_id||'/'||lead.primary_interest_code_id||'/'||lead.secondary_interest_code_id code
191: FROM as_sales_lead_lines lead
192: WHERE lead.secondary_interest_code_id not in (SELECT sic.interest_code_id
193: FROM as_interest_codes_b sic
194: WHERE sic.parent_interest_code_id is not null) ;
195:
196: --
197:

Line 381: from as_interest_codes_b int

377: -- Update primary interest code
378: update as_sales_lead_lines l
379: set (category_id, category_set_id) =
380: (select int.product_category_id, int.product_cat_set_id
381: from as_interest_codes_b int
382: where l.primary_interest_code_id = int.interest_code_id)
383: where l.sales_lead_line_id >= l_count
384: and l.sales_lead_line_id < l_count+G_BATCH_SIZE
385: and l.primary_interest_code_id is not null

Line 392: from as_interest_codes_b int

388: -- Update secondary interest code
389: update as_sales_lead_lines l
390: set (category_id, category_set_id) =
391: (select int.product_category_id, int.product_cat_set_id
392: from as_interest_codes_b int
393: where l.secondary_interest_code_id = int.interest_code_id)
394: where l.sales_lead_line_id >= l_count
395: and l.sales_lead_line_id < l_count+G_BATCH_SIZE
396: and l.secondary_interest_code_id is not null;