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.OKS_AUTO_REMINDER dependencies on OKC_CONTACTS

Line 1364: FROM okc_contacts ct

1360: IS
1361: CURSOR l_billto_contact_csr
1362: IS
1363: SELECT object1_id1
1364: FROM okc_contacts ct
1365: WHERE ct.cro_code = 'BILLING'
1366: AND ct.dnz_chr_id = p_contract_id;
1367:
1368: l_id NUMBER;

Line 1428: FROM okc_contacts ct

1424:
1425: CURSOR l_svc_admin_csr
1426: IS
1427: SELECT object1_id1
1428: FROM okc_contacts ct
1429: WHERE ct.cro_code = 'BILLING'
1430: AND ct.dnz_chr_id = p_contract_id;
1431:
1432: l_id NUMBER;

Line 1477: FROM okc_contacts ct

1473:
1474: CURSOR l_svc_admin_csr
1475: IS
1476: SELECT object1_id1
1477: FROM okc_contacts ct
1478: WHERE ct.cro_code = 'BILLING'
1479: AND ct.dnz_chr_id = p_contract_id;
1480:
1481: l_id NUMBER;

Line 1517: okc_contacts kc

1513: */
1514: CURSOR l_billto_email IS
1515: SELECT hcp.email_address
1516: FROM hz_contact_points hcp,
1517: okc_contacts kc
1518: WHERE hcp.owner_table_id = kc.object1_id1
1519: AND kc.cro_code = 'BILLING'
1520: AND hcp.contact_point_type='EMAIL'
1521: AND hcp.owner_table_name = 'HZ_PARTIES'