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 HZ_PARTIES

Line 273: CURSOR l_party_name_csr Is select party_Name from hz_parties where party_id = p_party_id;

269: WHERE jrd.resource_id=p_resource_id
270: AND fu.user_id = jrd.user_id;
271:
272:
273: CURSOR l_party_name_csr Is select party_Name from hz_parties where party_id = p_party_id;
274: l_party_name Varchar2(2000);
275:
276:
277: BEGIN

Line 425: select party_Name from hz_parties

421:
422:
423: FUNCTION GET_PARTY_NAME (p_party_id Number) RETURN VARCHAR2 IS
424: CURSOR cur_party_name IS
425: select party_Name from hz_parties
426: where party_id = p_party_id;
427: l_party_Name VARCHAR2(200);
428: BEGIN
429: FOR c_cur_party_name IN cur_party_name LOOP

Line 1101: hz_parties hz,

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
1105: AND hdr.authoring_org_id=nvl(p_org_id,hdr.authoring_org_id)

Line 1136: hz_parties hz,

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
1140: AND hdr.authoring_org_id=nvl(p_org_id,hdr.authoring_org_id)

Line 1171: hz_parties hz,

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
1175: AND hdr.authoring_org_id=nvl(p_org_id,hdr.authoring_org_id)

Line 1207: hz_parties hz,

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)
1211: AND hdr.sts_code = p_status_code

Line 1242: hz_parties hz,

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
1246: AND hdr.authoring_org_id=nvl(p_org_id,hdr.authoring_org_id)

Line 1277: hz_parties hz,

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)
1281: AND hdr.sts_code = p_status_code

Line 1311: hz_parties hz,

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)
1315: AND stat.STE_CODE IN ('ENTERED','ACTIVE','SIGNED','HOLD')

Line 1348: hz_parties hz,

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)
1352: AND stat.STE_CODE IN ('ENTERED','ACTIVE','SIGNED','HOLD')

Line 1395: hz_parties hz,

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
1399: AND hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )

Line 1440: hz_parties hz,

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
1444: AND hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )

Line 1485: hz_parties hz,

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
1489: AND hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )

Line 1531: hz_parties hz,

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 )
1535: AND hdr.sts_code = p_status_code

Line 1575: hz_parties hz,

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
1579: AND hdr.authoring_org_id = NVL( p_org_id, hdr.authoring_org_id )

Line 1620: hz_parties hz,

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 )
1624: AND hdr.sts_code = p_status_code

Line 1663: hz_parties hz,

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 )
1667: AND hdr.sts_code = stat.code

Line 1708: hz_parties hz,

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 )
1712: AND hdr.sts_code = stat.code