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_ACCOUNTS_PUB dependencies on DUAL

Line 457: AND tm.resource_type = 'INDIVIDUAL'

453: AND tu.team_id = t.team_id
454: AND tu.usage IN ('SALES','PRM')
455: AND tm.team_member_id = trr.role_resource_id
456: AND tm.delete_flag <> 'Y'
457: AND tm.resource_type = 'INDIVIDUAL'
458: AND trr.role_resource_type = 'RS_TEAM_MEMBER'
459: AND trr.delete_flag <> 'Y'
460: AND SYSDATE BETWEEN trr.start_date_active AND
461: NVL(trr.end_date_active,SYSDATE)

Line 895: END LOOP; -- for each record individually

891: WHEN OTHERS THEN
892: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || AS_GAR.G_IND_UPD || AS_GAR.G_GENERAL_EXCEPTION);
893: AS_GAR.LOG('CUSTOMER_ID/SALESFORCE_ID/SALESGROUP_ID/ORG_ID - ' || l_customer_id(i) || '/' || l_salesforce_id(i) || '/' || l_sales_group_id(i));
894: END;
895: END LOOP; -- for each record individually
896: COMMIT;
897: END IF;
898: END; -- end of deadlock exception
899: WHEN OTHERS THEN

Line 1011: from dual

1007: ATR.RESOURCE_TYPE;
1008:
1009: CURSOR c_src IS
1010: select 'Y'
1011: from dual
1012: where exists ( SELECT 'Y'
1013: FROM FND_PROFILE_OPTION_VALUES VAL,
1014: FND_PROFILE_OPTIONS OPTIONS,
1015: FND_USER USERS

Line 1165: FROM DUAL

1161: ,p_terr_globals.prog_id
1162: ,SYSDATE
1163: ,'Y'
1164: ,l_org_id(i)
1165: FROM DUAL
1166: WHERE NOT EXISTS ( SELECT 'X'
1167: FROM AS_ACCESSES_ALL_ALL AA
1168: WHERE AA.sales_lead_id IS NULL
1169: AND AA.lead_id IS NULL

Line 1231: from dual

1227: ,p_terr_globals.prog_id
1228: ,SYSDATE
1229: ,'Y'
1230: ,l_org_id(i)
1231: from dual
1232: where not exists ( SELECT 'X'
1233: FROM AS_ACCESSES_ALL_ALL AA
1234: WHERE AA.sales_lead_id IS NULL
1235: AND AA.lead_id IS NULL

Line 1246: END LOOP; /* loop for DUP_VAL_ON_INDEX individual insert */

1242: EXCEPTION
1243: WHEN OTHERS THEN
1244: NULL;
1245: END;
1246: END LOOP; /* loop for DUP_VAL_ON_INDEX individual insert */
1247: COMMIT;
1248: WHEN OTHERS THEN
1249: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1250: x_errbuf := SQLERRM;

Line 1579: AND REL.role_resource_type='RS_INDIVIDUAL'

1575: AND WIN.resource_type in ('RS_PARTNER','RS_PARTY')
1576: AND WIN.resource_id=REL.role_resource_id
1577: AND REL.role_id=ROL.role_id
1578: AND ROL.role_type_code='PRM'
1579: AND REL.role_resource_type='RS_INDIVIDUAL'
1580: AND REL.delete_flag <> 'Y'
1581: AND SYSDATE between REL.start_date_active
1582: AND NVL(REL.end_date_active,SYSDATE)
1583: AND WIN.trans_object_id = A.customer_id

Line 1700: END LOOP; -- for each record individually

1696: WHEN OTHERS THEN
1697: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_STLEAD || 'PRM::' || AS_GAR.G_IND_UPD || AS_GAR.G_GENERAL_EXCEPTION);
1698: AS_GAR.LOG('CUSTOMER_ID/SALESFORCE_ID/SALESGROUP_ID/ORG_ID/PRM_CUST_ID/PRM_CUST_CONT_ID - ' || l_customer_id(i) || '/' || l_salesforce_id(i) || '/' || l_sales_group_id(i) || '/' || '/' || l_part_cust_id(i) || '/' || l_part_cont_party_id(i));
1699: END;
1700: END LOOP; -- for each record individually
1701: COMMIT;
1702: END IF;
1703: END; -- end of deadlock exception
1704: WHEN OTHERS THEN

Line 1797: AND REL.role_resource_type='RS_INDIVIDUAL'

1793: AND W.worker_id = c_worker_id
1794: AND W.resource_type in ('RS_PARTY','RS_PARTNER')
1795: AND REL.role_id=ROL.role_id
1796: AND ROL.role_type_code='PRM'
1797: AND REL.role_resource_type='RS_INDIVIDUAL'
1798: AND REL.delete_flag <> 'Y'
1799: AND SYSDATE between REL.start_date_active
1800: AND NVL(REL.end_date_active,SYSDATE)
1801: AND W.resource_id=RES.resource_id

Line 1923: FROM DUAL

1919: ,'Y'
1920: ,l_org_id(i)
1921: ,DECODE(l_resource_type(i),'RS_PARTNER',l_src(i),NULL)
1922: ,DECODE(l_resource_type(i),'RS_PARTY',l_src(i),NULL)
1923: FROM DUAL
1924: );
1925: AS_GAR.LOG(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || 'PRM::' || AS_GAR.G_BULK_INS || AS_GAR.G_N_ROWS_PROCESSED || SQL%ROWCOUNT);
1926: COMMIT;
1927: EXCEPTION

Line 1981: FROM DUAL

1977: ,'Y'
1978: ,l_org_id(i)
1979: ,DECODE(l_resource_type(i),'RS_PARTNER',l_src(i),NULL)
1980: ,DECODE(l_resource_type(i),'RS_PARTY',l_src(i),NULL)
1981: FROM DUAL
1982: );
1983: EXCEPTION
1984: WHEN OTHERS THEN
1985: NULL;

Line 1987: END LOOP; /* loop for DUP_VAL_ON_INDEX individual insert */

1983: EXCEPTION
1984: WHEN OTHERS THEN
1985: NULL;
1986: END;
1987: END LOOP; /* loop for DUP_VAL_ON_INDEX individual insert */
1988: COMMIT;
1989: WHEN OTHERS THEN
1990: AS_GAR.LOG_EXCEPTION(G_ENTITY || AS_GAR.G_PROCESS || AS_GAR.G_INSACC || 'PRM::' || AS_GAR.G_BULK_INS, SQLERRM, TO_CHAR(SQLCODE));
1991: x_errbuf := SQLERRM;

Line 2062: AND REL.role_resource_type='RS_INDIVIDUAL'

2058: AND W.resource_type in ('RS_PARTNER','RS_PARTY')
2059: AND W.resource_id=REL.role_resource_id
2060: AND REL.role_id=ROL.role_id
2061: AND ROL.role_type_code='PRM'
2062: AND REL.role_resource_type='RS_INDIVIDUAL'
2063: AND REL.delete_flag <> 'Y'
2064: AND SYSDATE between REL.start_date_active
2065: AND NVL(REL.end_date_active,SYSDATE)
2066: GROUP BY W.terr_id,