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_ATA_TOTAL_PUB dependencies on AS_CHANGED_ACCOUNTS_ALL

Line 519: FROM AS_CHANGED_ACCOUNTS_ALL

515: l_entity_id entity_id_list;
516:
517: CURSOR del_acct_changed IS
518: SELECT distinct customer_id
519: FROM AS_CHANGED_ACCOUNTS_ALL
520: WHERE lead_id IS NULL
521: AND sales_lead_id IS NULL;
522:
523: CURSOR del_lead_changed IS

Line 525: FROM AS_CHANGED_ACCOUNTS_ALL

521: AND sales_lead_id IS NULL;
522:
523: CURSOR del_lead_changed IS
524: SELECT distinct sales_lead_id
525: FROM AS_CHANGED_ACCOUNTS_ALL
526: WHERE lead_id IS NULL
527: AND sales_lead_id IS NOT NULL;
528:
529: CURSOR del_oppty_changed IS

Line 531: FROM AS_CHANGED_ACCOUNTS_ALL

527: AND sales_lead_id IS NOT NULL;
528:
529: CURSOR del_oppty_changed IS
530: SELECT distinct lead_id
531: FROM AS_CHANGED_ACCOUNTS_ALL
532: WHERE lead_id IS NOT NULL
533: AND sales_lead_id IS NULL;
534:
535: CURSOR del_proposal_changed IS

Line 610: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

606:
607: BEGIN
608: IF p_entity = 'ACCOUNT' THEN
609: FORALL i in l_first..l_last
610: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
611: WHERE ACC.customer_id=l_entity_id(i)
612: AND ACC.lead_id IS NULL
613: AND ACC.sales_lead_id IS NULL;
614:

Line 617: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

613: AND ACC.sales_lead_id IS NULL;
614:
615: ELSIF p_entity = 'LEAD' THEN
616: FORALL i in l_first..l_last
617: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
618: WHERE ACC.sales_lead_id=l_entity_id(i)
619: AND ACC.lead_id IS NULL;
620:
621: ELSIF p_entity = 'OPPTY' THEN

Line 623: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

619: AND ACC.lead_id IS NULL;
620:
621: ELSIF p_entity = 'OPPTY' THEN
622: FORALL i in l_first..l_last
623: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
624: WHERE ACC.lead_id=l_entity_id(i)
625: AND ACC.change_type = 'OPPORTUNITY';
626:
627: --Fix for #4891555

Line 652: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

648: FOR i IN l_first .. l_last LOOP --{L5
649: BEGIN
650: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_CC || AS_GAR.G_UPD_ACCESSES || AS_GAR.G_IND_DEL || AS_GAR.G_START);
651: IF p_entity = 'ACCOUNT' THEN
652: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
653: WHERE ACC.customer_id=l_entity_id(i)
654: AND ACC.lead_id IS NULL
655: AND ACC.sales_lead_id IS NULL;
656: ELSIF p_entity = 'LEAD' THEN

Line 657: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

653: WHERE ACC.customer_id=l_entity_id(i)
654: AND ACC.lead_id IS NULL
655: AND ACC.sales_lead_id IS NULL;
656: ELSIF p_entity = 'LEAD' THEN
657: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
658: WHERE ACC.sales_lead_id=l_entity_id(i)
659: AND ACC.lead_id IS NULL;
660: ELSIF p_entity = 'OPPTY' THEN
661: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

Line 661: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC

657: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
658: WHERE ACC.sales_lead_id=l_entity_id(i)
659: AND ACC.lead_id IS NULL;
660: ELSIF p_entity = 'OPPTY' THEN
661: DELETE FROM AS_CHANGED_ACCOUNTS_ALL ACC
662: WHERE ACC.lead_id=l_entity_id(i)
663: AND ACC.change_type = 'OPPORTUNITY';
664: --Fix for #4891555
665: