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 1441: FROM okc_contacts ct

1437: IS
1438: CURSOR l_billto_contact_csr
1439: IS
1440: SELECT object1_id1
1441: FROM okc_contacts ct
1442: WHERE ct.cro_code = 'BILLING'
1443: AND ct.dnz_chr_id = p_contract_id;
1444:
1445: l_id NUMBER;

Line 1505: FROM okc_contacts ct

1501:
1502: CURSOR l_svc_admin_csr
1503: IS
1504: SELECT object1_id1
1505: FROM okc_contacts ct
1506: WHERE ct.cro_code = 'BILLING'
1507: AND ct.dnz_chr_id = p_contract_id;
1508:
1509: l_id NUMBER;

Line 1554: FROM okc_contacts ct

1550:
1551: CURSOR l_svc_admin_csr
1552: IS
1553: SELECT object1_id1
1554: FROM okc_contacts ct
1555: WHERE ct.cro_code = 'BILLING'
1556: AND ct.dnz_chr_id = p_contract_id;
1557:
1558: l_id NUMBER;

Line 1594: okc_contacts kc

1590: */
1591: CURSOR l_billto_email IS
1592: SELECT hcp.email_address
1593: FROM hz_contact_points hcp,
1594: okc_contacts kc
1595: WHERE hcp.owner_table_id = kc.object1_id1
1596: AND kc.cro_code = 'BILLING'
1597: AND hcp.contact_point_type='EMAIL'
1598: AND hcp.owner_table_name = 'HZ_PARTIES'