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.OKL_OPI_PVT dependencies on HZ_PARTIES

Line 773: FROM hz_parties hp

769:
770: CURSOR l_party_csr(cp_party_id IN NUMBER) IS
771: SELECT hp.party_name
772: ,hp.party_type
773: FROM hz_parties hp
774: WHERE hp.party_id = cp_party_id;
775:
776: CURSOR l_pp_csr(cp_party_id IN NUMBER) IS
777: SELECT hpp.date_of_birth

Line 912: ,hz_parties hp

908: ,hl.suite
909: ,hl.room
910: ,hl.postal_plus4_code
911: FROM okc_k_party_roles_b opr
912: ,hz_parties hp
913: ,hz_party_sites hps
914: ,hz_locations hl
915: ,hz_party_site_uses hpsu
916: WHERE opr.dnz_chr_id = cp_contract_id

Line 932: WHERE owner_table_name = 'HZ_PARTIES'

928: ,phone_area_code
929: ,phone_number
930: ,phone_extension
931: FROM hz_contact_points
932: WHERE owner_table_name = 'HZ_PARTIES'
933: AND owner_table_id = cp_party_id
934: AND contact_point_type = 'PHONE'
935: AND primary_flag = 'Y'
936: AND status = 'A';