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_K_HEADERS_B

Line 981: okc_k_headers_b b

977: FUNCTION GET_CHR_SALESREP_ID (p_resource_id Number,p_chr_id Number ) RETURN NUMBER IS
978: Cursor l_salesrep_csr IS
979: SELECT a.salesrep_id
980: From jtf_rs_salesreps a,
981: okc_k_headers_b b
982: Where b.id = p_chr_id
983: and a.resource_id = p_resource_id
984: and a.org_id = b.authoring_org_id;
985: l_salesrep_id NUMBER;

Line 1097: FROM OKC_K_HEADERS_B hdr,

1093: ,hdr.contract_number_modifier
1094: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1095: ,Party2.id,hz.party_name, hzl.country, hzl.state
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,

Line 1132: FROM OKC_K_HEADERS_B hdr,

1128: ,hdr.contract_number_modifier
1129: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1130: ,Party2.id,hz.party_name, hzl.country, hzl.state
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,

Line 1166: FROM OKC_K_HEADERS_B hdr,

1162: ,hdr.contract_number_modifier
1163: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1164: ,Party2.id,hz.party_name, hzl.country, hzl.state
1165: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
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,

Line 1203: FROM OKC_K_HEADERS_B hdr,

1199: ,hdr.contract_number_modifier
1200: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1201: ,Party2.id,hz.party_name, hzl.country, hzl.state
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,

Line 1237: FROM OKC_K_HEADERS_B hdr,

1233: ,hdr.contract_number_modifier
1234: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1235: ,Party2.id,hz.party_name, hzl.country, hzl.state
1236: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
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,

Line 1273: FROM OKC_K_HEADERS_B hdr,

1269: ,hdr.contract_number_modifier
1270: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1271: ,Party2.id,hz.party_name, hzl.country, hzl.state
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,

Line 1306: FROM OKC_K_HEADERS_B hdr,

1302: ,hdr.contract_number_modifier
1303: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1304: ,Party2.id,hz.party_name, hzl.country, hzl.state
1305: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
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,

Line 1343: FROM OKC_K_HEADERS_B hdr,

1339: ,hdr.contract_number_modifier
1340: ,hdr.authoring_org_id,hdr.inv_organization_id, party1.object1_id1
1341: ,Party2.id,hz.party_name, hzl.country, hzl.state
1342: ,cont.id,cont.object1_id1,cont.start_date,hdr.sts_code
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,

Line 1391: FROM okc_k_headers_b hdr,

1387: cont.ID,
1388: cont.object1_id1,
1389: cont.start_date,
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,

Line 1436: FROM okc_k_headers_b hdr,

1432: cont.ID,
1433: cont.object1_id1,
1434: cont.start_date,
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,

Line 1480: FROM okc_k_headers_b hdr,

1476: cont.ID,
1477: cont.object1_id1,
1478: cont.start_date,
1479: hdr.sts_code
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,

Line 1527: FROM okc_k_headers_b hdr,

1523: cont.ID,
1524: cont.object1_id1,
1525: cont.start_date,
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,

Line 1570: FROM okc_k_headers_b hdr,

1566: cont.ID,
1567: cont.object1_id1,
1568: cont.start_date,
1569: hdr.sts_code
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,

Line 1616: FROM okc_k_headers_b hdr,

1612: cont.ID,
1613: cont.object1_id1,
1614: cont.start_date,
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,

Line 1658: FROM okc_k_headers_b hdr,

1654: cont.ID,
1655: cont.object1_id1,
1656: cont.start_date,
1657: hdr.sts_code
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,

Line 1703: FROM okc_k_headers_b hdr,

1699: cont.ID,
1700: cont.object1_id1,
1701: cont.start_date,
1702: hdr.sts_code
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,

Line 1778: FROM okc_k_headers_b

1774: WHERE id not in (SELECT chr_id FROM OKS_JTF_RES_TEMP);
1775:
1776: CURSOR get_contract_num_mod(p_chr_id NUMBER) IS
1777: SELECT contract_number, contract_number_modifier
1778: FROM okc_k_headers_b
1779: WHERE id = p_chr_id;
1780:
1781: l_ctcv_tbl_in okc_contract_party_pub.ctcv_tbl_type;
1782: l_ctcv_tbl_in_del okc_contract_party_pub.ctcv_tbl_type;

Line 1799: FROM okc_k_headers_b

1795:
1796: FUNCTION GET_CONTRACT_NUMBER (p_chr_id Number ) RETURN VARCHAR2 IS
1797: CURSOR l_contract_csr IS
1798: SELECT contract_number
1799: FROM okc_k_headers_b
1800: WHERE id = p_chr_id;
1801: l_contract_number VARCHAR2(120);
1802: BEGIN
1803: FOR c_l_contract_csr in l_contract_csr LOOP

Line 1832: FROM okc_k_headers_b

1828: FUNCTION GET_ORG_ID (p_chr_id Number ) RETURN NUMBER IS
1829:
1830: CURSOR get_org_id(p_chr_id number) IS
1831: SELECT authoring_org_id
1832: FROM okc_k_headers_b
1833: WHERE id = p_chr_id;
1834:
1835: l_org_id NUMBER;
1836: BEGIN