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_PARTY_ROLES_B

Line 377: from okc_k_party_roles_b

373:
374: FUNCTION GET_PARTY_ID (p_contract_id IN NUMBER) RETURN NUMBER IS
375: CURSOR cur_get_party_id IS
376: select object1_id1
377: from okc_k_party_roles_b
378: where dnz_chr_id = p_contract_id
379: and cle_id is null
380: and RLE_CODE = 'CUSTOMER';
381: l_party_id NUMBER;

Line 464: select id from okc_k_party_roles_b

460: WHERE CRO_CODE = p_cro_code
461: AND dnz_chr_id = p_contract_header_id;
462:
463: CURSOR GET_CPL_ID IS
464: select id from okc_k_party_roles_b
465: where dnz_chr_id = p_contract_header_id
466: and cle_id is null
467: and RLE_CODE = 'VENDOR';
468:

Line 1098: okc_k_party_roles_b party1,

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,
1102: hz_party_sites hzs,

Line 1099: okc_k_party_roles_b party2,

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,
1102: hz_party_sites hzs,
1103: hz_locations hzl

Line 1133: okc_k_party_roles_b party1,

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,
1137: hz_party_sites hzs,

Line 1134: okc_k_party_roles_b party2,

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,
1137: hz_party_sites hzs,
1138: hz_locations hzl

Line 1168: okc_k_party_roles_b party1,

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,
1171: hz_parties hz,
1172: hz_party_sites hzs,

Line 1169: okc_k_party_roles_b party2,

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,
1171: hz_parties hz,
1172: hz_party_sites hzs,
1173: hz_locations hzl

Line 1204: okc_k_party_roles_b party1,

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,
1208: hz_party_sites hzs,

Line 1205: okc_k_party_roles_b party2,

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,
1208: hz_party_sites hzs,
1209: hz_locations hzl

Line 1239: okc_k_party_roles_b party1,

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,
1242: hz_parties hz,
1243: hz_party_sites hzs,

Line 1240: okc_k_party_roles_b party2,

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,
1242: hz_parties hz,
1243: hz_party_sites hzs,
1244: hz_locations hzl

Line 1274: okc_k_party_roles_b party1,

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,
1278: hz_party_sites hzs,

Line 1275: okc_k_party_roles_b party2,

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,
1278: hz_party_sites hzs,
1279: hz_locations hzl

Line 1308: okc_k_party_roles_b party1,

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,
1311: hz_parties hz,
1312: hz_party_sites hzs,

Line 1309: okc_k_party_roles_b party2,

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,
1311: hz_parties hz,
1312: hz_party_sites hzs,
1313: hz_locations hzl

Line 1345: okc_k_party_roles_b party1,

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,
1348: hz_parties hz,
1349: hz_party_sites hzs,

Line 1346: okc_k_party_roles_b party2,

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,
1348: hz_parties hz,
1349: hz_party_sites hzs,
1350: hz_locations hzl

Line 1392: okc_k_party_roles_b party1,

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,
1396: hr_all_organization_units b,

Line 1393: okc_k_party_roles_b party2,

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,
1396: hr_all_organization_units b,
1397: hr_locations_all c

Line 1437: okc_k_party_roles_b party1,

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,
1441: hr_all_organization_units b,

Line 1438: okc_k_party_roles_b party2,

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,
1441: hr_all_organization_units b,
1442: hr_locations_all c

Line 1482: okc_k_party_roles_b party1,

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,
1485: hz_parties hz,
1486: hr_all_organization_units b,

Line 1483: okc_k_party_roles_b party2,

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,
1485: hz_parties hz,
1486: hr_all_organization_units b,
1487: hr_locations_all c

Line 1528: okc_k_party_roles_b party1,

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,
1532: hr_all_organization_units b,

Line 1529: okc_k_party_roles_b party2,

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,
1532: hr_all_organization_units b,
1533: hr_locations_all c

Line 1572: okc_k_party_roles_b party1,

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,
1575: hz_parties hz,
1576: hr_all_organization_units b,

Line 1573: okc_k_party_roles_b party2,

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,
1575: hz_parties hz,
1576: hr_all_organization_units b,
1577: hr_locations_all c

Line 1617: okc_k_party_roles_b party1,

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,
1621: hr_all_organization_units b,

Line 1618: okc_k_party_roles_b party2,

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,
1621: hr_all_organization_units b,
1622: hr_locations_all c

Line 1660: okc_k_party_roles_b party1,

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,
1663: hz_parties hz,
1664: hr_all_organization_units b,

Line 1661: okc_k_party_roles_b party2,

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,
1663: hz_parties hz,
1664: hr_all_organization_units b,
1665: hr_locations_all c

Line 1705: okc_k_party_roles_b party1,

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,
1708: hz_parties hz,
1709: hr_all_organization_units b,

Line 1706: okc_k_party_roles_b party2,

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,
1708: hz_parties hz,
1709: hr_all_organization_units b,
1710: hr_locations_all c

Line 1814: FROM okc_k_party_roles_b

1810: FUNCTION GET_CPL_ID (p_chr_id Number ) RETURN NUMBER IS
1811:
1812: CURSOR get_cpl_id_csr(p_chr_id number) IS
1813: SELECT id
1814: FROM okc_k_party_roles_b
1815: WHERE dnz_chr_id = p_chr_id
1816: AND rle_code IN ('VENDOR','MERCHANT')
1817: AND cle_id is null;
1818: