DBA Data[Home] [Help]

APPS.AS_INT_TYP_COD_MIGRATION dependencies on AS_FST_SALES_CATEGORIES_S

Line 675: select AS_FST_SALES_CATEGORIES_S.nextval

671: select max(fst_sales_category_id)
672: from as_fst_sales_categories;
673:
674: CURSOR Get_Next_Val IS
675: select AS_FST_SALES_CATEGORIES_S.nextval
676: from dual;
677:
678: BEGIN
679: -- First load the schema name

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

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;
1453: */