DBA Data[Home] [Help]

APPS.AS_INT_TYP_COD_MIGRATION dependencies on AS_LEAD_LINES_LOG_S

Line 904: select AS_LEAD_LINES_LOG_S.nextval

900: select max(log_id)
901: from as_lead_lines_log;
902:
903: CURSOR Get_Next_Val IS
904: select AS_LEAD_LINES_LOG_S.nextval
905: from dual;
906:
907: BEGIN
908: -- First load the schema name

Line 1448: update as_lead_lines_log set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;

1444: Change the date as per requirements.
1445: update as_lead_lines_all set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1446: update as_interests_all set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1447: update as_sales_credits_denorm set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1448: update as_lead_lines_log set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1449: update as_fst_sales_categories set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1450: update as_opp_worksheet_lines set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1451: update as_prod_worksheet_lines set product_category_id=null,product_cat_set_id=null where nvl(interest_type_id,-1)<>-1;
1452: commit;