APPS.AS_INT_TYP_COD_MIGRATION dependencies on AS_INTEREST_TYPES_B

Line 266: from AS_INTEREST_TYPES_B

262: and language = userenv('lang');
263:
264: CURSOR C_Get_Product_Cat_Id(c_interest_type_id NUMBER) IS
265: select product_category_id, product_cat_set_id
266: from AS_INTEREST_TYPES_B
267: where interest_type_id = c_interest_type_id;
268:
269: CURSOR C_Get_Product_Cat_Id2(c_interest_code_id NUMBER) IS
270: select product_category_id, product_cat_set_id

Line 591: from as_interest_types_b int

587: -- Update interest type
588: update as_lead_lines_all l
589: set (product_category_id, product_cat_set_id) =
590: (select int.product_category_id, int.product_cat_set_id
591: from as_interest_types_b int
592: where l.interest_type_id = int.interest_type_id)
593: where l.lead_line_id >= l_count
594: and l.lead_line_id < l_count+G_BATCH_SIZE
595: and l.interest_type_id is not null

Line 723: from as_interest_types_b int

719: -- Update interest type
720: update as_fst_sales_categories l
721: set (product_category_id, product_cat_set_id) =
722: (select int.product_category_id, int.product_cat_set_id
723: from as_interest_types_b int
724: where l.interest_type_id = int.interest_type_id)
725: where l.fst_sales_category_id >= l_count
726: and l.fst_sales_category_id < l_count+G_BATCH_SIZE
727: and l.interest_type_id is not null;

Line 826: from as_interest_types_b int

822: -- Update interest type
823: update as_interests_all l
824: set (product_category_id, product_cat_set_id) =
825: (select int.product_category_id, int.product_cat_set_id
826: from as_interest_types_b int
827: where l.interest_type_id = int.interest_type_id)
828: where l.interest_id >= l_count
829: and l.interest_id < l_count+G_BATCH_SIZE
830: and l.interest_type_id is not null

Line 952: from as_interest_types_b int

948: -- Update interest type
949: update as_lead_lines_log l
950: set (product_category_id, product_cat_set_id) =
951: (select int.product_category_id, int.product_cat_set_id
952: from as_interest_types_b int
953: where l.interest_type_id = int.interest_type_id)
954: where l.log_id >= l_count
955: and l.log_id < l_count+G_BATCH_SIZE
956: and l.interest_type_id is not null

Line 1078: from as_interest_types_b int

1074: -- Update interest type
1075: update as_sales_credits_denorm l
1076: set (product_category_id, product_cat_set_id) =
1077: (select int.product_category_id, int.product_cat_set_id
1078: from as_interest_types_b int
1079: where l.interest_type_id = int.interest_type_id)
1080: where l.sales_credit_id >= l_count
1081: and l.sales_credit_id < l_count+G_BATCH_SIZE
1082: and nvl(l.interest_type_id,-1) <> -1

Line 1206: from as_interest_types_b int

1202: -- Update interest type
1203: update AS_PROD_WORKSHEET_LINES pwl
1204: set (product_category_id, product_cat_set_id) =
1205: (select int.product_category_id, int.product_cat_set_id
1206: from as_interest_types_b int
1207: where pwl.interest_type_id = int.interest_type_id)
1208: where pwl.PROD_WORKSHEET_LINE_ID >= l_count
1209: and pwl.PROD_WORKSHEET_LINE_ID < l_count+G_BATCH_SIZE
1210: and pwl.interest_type_id is not null;

Line 1269: from as_interest_types_b int

1265: -- Update interest type
1266: update as_pe_int_categories l
1267: set (product_category_id, product_cat_set_id) =
1268: (select int.product_category_id, int.product_cat_set_id
1269: from as_interest_types_b int
1270: where l.interest_type_id = int.interest_type_id)
1271: where nvl(l.interest_type_id,-1) <> -1
1272: and nvl(l.pri_interest_code_id,-1) = -1
1273: and nvl(l.sec_interest_code_id,-1) = -1;