DBA Data[Home] [Help]

APPS.AS_INT_TYP_COD_MIGRATION dependencies on AS_PROD_WORKSHEET_LINES_S

Line 1158: select AS_PROD_WORKSHEET_LINES_S.nextval

1154: select max(PROD_WORKSHEET_LINE_ID)
1155: from AS_PROD_WORKSHEET_LINES;
1156:
1157: CURSOR Get_Next_Val IS
1158: select AS_PROD_WORKSHEET_LINES_S.nextval
1159: from dual;
1160:
1161: BEGIN
1162: -- First load the schema name

Line 1451: update as_prod_worksheet_lines 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: */
1454:
1455: END AS_INT_TYP_COD_MIGRATION;