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_LOCATIONS

Line 1103: hz_locations hzl

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

Line 1138: hz_locations hzl

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

Line 1173: hz_locations hzl

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

Line 1209: hz_locations hzl

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')
1213: AND hdr.template_yn = 'N'

Line 1244: hz_locations hzl

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

Line 1279: hz_locations hzl

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')
1283: AND hdr.template_yn = 'N'

Line 1313: hz_locations hzl

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

Line 1350: hz_locations hzl

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