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 ASO_CHANGED_QUOTES

Line 541: FROM ASO_CHANGED_QUOTES;

537: FROM PRP_CHANGED_PROPOSALS;
538:
539: CURSOR del_quote_changed IS
540: SELECT distinct quote_number
541: FROM ASO_CHANGED_QUOTES;
542:
543: l_flag BOOLEAN;
544: l_first NUMBER;
545: l_last NUMBER;

Line 630: DELETE FROM ASO_CHANGED_QUOTES ACC

626:
627: --Fix for #4891555
628: ELSIF p_entity = 'QUOTE' THEN
629: FORALL i in l_first..l_last
630: DELETE FROM ASO_CHANGED_QUOTES ACC
631: WHERE ACC.quote_number=l_entity_id(i);
632:
633: ELSIF p_entity = 'PROPOSAL' THEN
634: FORALL i in l_first..l_last

Line 667: DELETE FROM ASO_CHANGED_QUOTES ACC

663: AND ACC.change_type = 'OPPORTUNITY';
664: --Fix for #4891555
665:
666: ELSIF p_entity = 'QUOTE' THEN
667: DELETE FROM ASO_CHANGED_QUOTES ACC
668: WHERE ACC.quote_number=l_entity_id(i);
669: ELSIF p_entity = 'PROPOSAL' THEN
670: DELETE FROM PRP_CHANGED_PROPOSALS ACC
671: WHERE ACC.proposal_id=l_entity_id(i);