eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_VALIDATE_SETUP dependencies on AS_FST_SALES_CATEGORIES

Line 1006: FROM as_fst_sales_categories

1002: Write_log(l_module, ' ');
1003: Write_log(l_module, '**** Checking the setup for Forecast module ****');
1004: BEGIN
1005: SELECT count(*) INTO l_count
1006: FROM as_fst_sales_categories
1007: WHERE product_category_id is not null
1008: and ROWID NOT IN ( SELECT MIN(ROWID)
1009: FROM as_fst_sales_categories
1010: GROUP BY product_category_id);

Line 1009: FROM as_fst_sales_categories

1005: SELECT count(*) INTO l_count
1006: FROM as_fst_sales_categories
1007: WHERE product_category_id is not null
1008: and ROWID NOT IN ( SELECT MIN(ROWID)
1009: FROM as_fst_sales_categories
1010: GROUP BY product_category_id);
1011: EXCEPTION
1012: WHEN OTHERS THEN
1013: l_count := 0;

Line 1020: ||'): duplicate records found in AS_FST_SALES_CATEGORIES');

1016: l_err_num := l_err_num+1;
1017: l_err_total := l_err_total+1;
1018: Write_log(l_module, ' ');
1019: Write_log(l_module, 'Error('||to_char(l_err_total)
1020: ||'): duplicate records found in AS_FST_SALES_CATEGORIES');
1021: ELSE
1022: Write_log(l_module, ' ');
1023: Write_log(l_module, 'Success: no duplicate records'||
1024: ' found in AS_FST_SALES_CATEGORIES');

Line 1024: ' found in AS_FST_SALES_CATEGORIES');

1020: ||'): duplicate records found in AS_FST_SALES_CATEGORIES');
1021: ELSE
1022: Write_log(l_module, ' ');
1023: Write_log(l_module, 'Success: no duplicate records'||
1024: ' found in AS_FST_SALES_CATEGORIES');
1025: END IF;
1026: BEGIN
1027: SELECT count(*) INTO l_count
1028: FROM as_pe_int_categories