APPS.AS_VALIDATE_SETUP dependencies on ASO_I_SALES_CHANNELS_V

Line 805: FROM ASO_I_SALES_CHANNELS_V

801: ||l_prod_org||'> at site level.');
802: END IF;*/
803: BEGIN
804: SELECT count(*) INTO l_count
805: FROM ASO_I_SALES_CHANNELS_V
806: WHERE ENABLED_FLAG='Y'
807: AND NVL(START_DATE_ACTIVE, sysdate) <= sysdate
808: AND NVL(END_DATE_ACTIVE, sysdate) >= sysdate;
809: EXCEPTION

Line 818: ||'): no active Sales Channel in ASO_I_SALES_CHANNELS_V.');

814: l_err_num := l_err_num+1;
815: l_err_total := l_err_total+1;
816: Write_log(l_module, ' ');
817: Write_log(l_module, 'Error('||to_char(l_err_total)
818: ||'): no active Sales Channel in ASO_I_SALES_CHANNELS_V.');
819: ELSE
820: Write_log(l_module, ' ');
821: Write_log(l_module, 'Success: active Sales Channel'||
822: ' found in ASO_I_SALES_CHANNELS_V');

Line 822: ' found in ASO_I_SALES_CHANNELS_V');

818: ||'): no active Sales Channel in ASO_I_SALES_CHANNELS_V.');
819: ELSE
820: Write_log(l_module, ' ');
821: Write_log(l_module, 'Success: active Sales Channel'||
822: ' found in ASO_I_SALES_CHANNELS_V');
823: END IF;
824: END IF;
825: BEGIN
826: BEGIN