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_GAR_OPPTYS_PUB dependencies on AS_STATUSES_B

Line 1041: FROM DUAL, AS_LEADS_ALL L, AS_STATUSES_B STS

1037: ,SYSDATE
1038: ,'Y'
1039: ,l_org_id(i)
1040: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1041: FROM DUAL, AS_LEADS_ALL L, AS_STATUSES_B STS
1042: WHERE L.lead_id = l_lead_id(i)
1043: AND L.status = STS.status_code
1044: AND NOT EXISTS ( SELECT 'X'
1045: FROM AS_ACCESSES_ALL_ALL AA

Line 1112: FROM DUAL,AS_LEADS_ALL L, AS_STATUSES_B STS

1108: ,SYSDATE
1109: ,'Y'
1110: ,l_org_id(i)
1111: ,DECODE(STS.opp_open_status_flag, 'Y', 'Y', NULL)
1112: FROM DUAL,AS_LEADS_ALL L, AS_STATUSES_B STS
1113: WHERE L.lead_id = l_lead_id(i)
1114: AND L.status = STS.status_code
1115: AND NOT EXISTS ( SELECT 'X'
1116: FROM AS_ACCESSES_ALL_ALL AA