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_PARTY_SITES

Line 1102: hz_party_sites hzs,

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

Line 1137: hz_party_sites hzs,

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

Line 1172: hz_party_sites hzs,

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

Line 1208: hz_party_sites hzs,

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
1212: AND hdr.scs_code IN ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 1243: hz_party_sites hzs,

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

Line 1278: hz_party_sites hzs,

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
1282: AND hdr.scs_code IN ('SERVICE','WARRANTY','SUBSCRIPTION')

Line 1312: hz_party_sites hzs,

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')
1316: AND hdr.sts_code = stat.CODE

Line 1349: hz_party_sites hzs,

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')
1353: AND hdr.sts_code = stat.CODE