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_EXTWAR_UTIL_PUB dependencies on OKC_CONTACTS

Line 459: FROM OKC_CONTACTS

455: l_msg_index_out NUMBER;
456:
457: CURSOR GET_CONTACT IS
458: SELECT object1_id1, cro_code, id
459: FROM OKC_CONTACTS
460: WHERE CRO_CODE = p_cro_code
461: AND dnz_chr_id = p_contract_header_id;
462:
463: CURSOR GET_CPL_ID IS

Line 539: from okc_contacts a

535: ) IS
536: -- Contact Details
537: cursor contact_det is
538: select a.dnz_chr_id,a.object1_id1, a.object1_id2, a.jtot_object1_code
539: from okc_contacts a
540: where a.id = p_contact_id;
541:
542: /*
543: -- Rule group

Line 1100: okc_contacts cont,

1096: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
1097: FROM OKC_K_HEADERS_B hdr,
1098: okc_k_party_roles_b party1,
1099: okc_k_party_roles_b party2,
1100: okc_contacts cont,
1101: hz_parties hz,
1102: hz_party_sites hzs,
1103: hz_locations hzl
1104: WHERE hdr.id = p_contract_hdr_id

Line 1135: okc_contacts cont,

1131: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
1132: FROM OKC_K_HEADERS_B hdr,
1133: okc_k_party_roles_b party1,
1134: okc_k_party_roles_b party2,
1135: okc_contacts cont,
1136: hz_parties hz,
1137: hz_party_sites hzs,
1138: hz_locations hzl
1139: WHERE hdr.id = p_contract_hdr_id

Line 1170: okc_contacts cont,

1166: FROM OKC_K_HEADERS_B hdr,
1167: okc_statuses_b stat,
1168: okc_k_party_roles_b party1,
1169: okc_k_party_roles_b party2,
1170: okc_contacts cont,
1171: hz_parties hz,
1172: hz_party_sites hzs,
1173: hz_locations hzl
1174: WHERE hdr.id = p_contract_hdr_id

Line 1206: okc_contacts cont,

1202: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
1203: FROM OKC_K_HEADERS_B hdr,
1204: okc_k_party_roles_b party1,
1205: okc_k_party_roles_b party2,
1206: okc_contacts cont,
1207: hz_parties hz,
1208: hz_party_sites hzs,
1209: hz_locations hzl
1210: WHERE hdr.authoring_org_id=nvl(p_org_id,hdr.authoring_org_id)

Line 1241: okc_contacts cont,

1237: FROM OKC_K_HEADERS_B hdr,
1238: okc_statuses_b stat,
1239: okc_k_party_roles_b party1,
1240: okc_k_party_roles_b party2,
1241: okc_contacts cont,
1242: hz_parties hz,
1243: hz_party_sites hzs,
1244: hz_locations hzl
1245: WHERE hdr.id = p_contract_hdr_id

Line 1276: okc_contacts cont,

1272: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
1273: FROM OKC_K_HEADERS_B hdr,
1274: okc_k_party_roles_b party1,
1275: okc_k_party_roles_b party2,
1276: okc_contacts cont,
1277: hz_parties hz,
1278: hz_party_sites hzs,
1279: hz_locations hzl
1280: WHERE hdr.authoring_org_id=nvl(p_org_id,hdr.authoring_org_id)

Line 1310: okc_contacts cont,

1306: FROM OKC_K_HEADERS_B hdr,
1307: okc_statuses_b stat,
1308: okc_k_party_roles_b party1,
1309: okc_k_party_roles_b party2,
1310: okc_contacts cont,
1311: hz_parties hz,
1312: hz_party_sites hzs,
1313: hz_locations hzl
1314: WHERE hdr.authoring_org_id=nvl(p_org_id,hdr.authoring_org_id)

Line 1347: okc_contacts cont,

1343: FROM OKC_K_HEADERS_B hdr,
1344: okc_statuses_b stat,
1345: okc_k_party_roles_b party1,
1346: okc_k_party_roles_b party2,
1347: okc_contacts cont,
1348: hz_parties hz,
1349: hz_party_sites hzs,
1350: hz_locations hzl
1351: WHERE hdr.authoring_org_id=nvl(p_org_id,hdr.authoring_org_id)

Line 1394: okc_contacts cont,

1390: hdr.sts_code
1391: FROM okc_k_headers_b hdr,
1392: okc_k_party_roles_b party1,
1393: okc_k_party_roles_b party2,
1394: okc_contacts cont,
1395: hz_parties hz,
1396: hr_all_organization_units b,
1397: hr_locations_all c
1398: WHERE hdr.id = p_contract_hdr_id

Line 1439: okc_contacts cont,

1435: hdr.sts_code
1436: FROM okc_k_headers_b hdr,
1437: okc_k_party_roles_b party1,
1438: okc_k_party_roles_b party2,
1439: okc_contacts cont,
1440: hz_parties hz,
1441: hr_all_organization_units b,
1442: hr_locations_all c
1443: WHERE hdr.id = p_contract_hdr_id

Line 1484: okc_contacts cont,

1480: FROM okc_k_headers_b hdr,
1481: okc_statuses_b stat,
1482: okc_k_party_roles_b party1,
1483: okc_k_party_roles_b party2,
1484: okc_contacts cont,
1485: hz_parties hz,
1486: hr_all_organization_units b,
1487: hr_locations_all c
1488: WHERE hdr.id = p_contract_hdr_id

Line 1530: okc_contacts cont,

1526: hdr.sts_code
1527: FROM okc_k_headers_b hdr,
1528: okc_k_party_roles_b party1,
1529: okc_k_party_roles_b party2,
1530: okc_contacts cont,
1531: hz_parties hz,
1532: hr_all_organization_units b,
1533: hr_locations_all c
1534: WHERE hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )

Line 1574: okc_contacts cont,

1570: FROM okc_k_headers_b hdr,
1571: okc_statuses_b stat,
1572: okc_k_party_roles_b party1,
1573: okc_k_party_roles_b party2,
1574: okc_contacts cont,
1575: hz_parties hz,
1576: hr_all_organization_units b,
1577: hr_locations_all c
1578: WHERE hdr.id = p_contract_hdr_id

Line 1619: okc_contacts cont,

1615: hdr.sts_code
1616: FROM okc_k_headers_b hdr,
1617: okc_k_party_roles_b party1,
1618: okc_k_party_roles_b party2,
1619: okc_contacts cont,
1620: hz_parties hz,
1621: hr_all_organization_units b,
1622: hr_locations_all c
1623: WHERE hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )

Line 1662: okc_contacts cont,

1658: FROM okc_k_headers_b hdr,
1659: okc_statuses_b stat,
1660: okc_k_party_roles_b party1,
1661: okc_k_party_roles_b party2,
1662: okc_contacts cont,
1663: hz_parties hz,
1664: hr_all_organization_units b,
1665: hr_locations_all c
1666: WHERE hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )

Line 1707: okc_contacts cont,

1703: FROM okc_k_headers_b hdr,
1704: okc_statuses_b stat,
1705: okc_k_party_roles_b party1,
1706: okc_k_party_roles_b party2,
1707: okc_contacts cont,
1708: hz_parties hz,
1709: hr_all_organization_units b,
1710: hr_locations_all c
1711: WHERE hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )