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.CSI_INTERFACE_PKG dependencies on HZ_RELATIONSHIPS

Line 2941: FROM hz_relationships hzr,

2937:
2938: IF x_source_line_rec.ship_to_contact_id is not null THEN
2939: SELECT hzr.subject_id
2940: INTO x_source_line_rec.ship_to_contact_party_id
2941: FROM hz_relationships hzr,
2942: hz_cust_account_roles hzar
2943: WHERE hzar.cust_account_role_id = x_source_line_rec.ship_to_contact_id
2944: AND hzr.party_id = hzar.party_id
2945: AND hzr.subject_table_name = 'HZ_PARTIES'

Line 2953: FROM hz_relationships hzr,

2949:
2950: IF x_source_line_rec.bill_to_contact_id is not null THEN
2951: SELECT hzr.subject_id
2952: INTO x_source_line_rec.bill_to_contact_party_id
2953: FROM hz_relationships hzr,
2954: hz_cust_account_roles hzar
2955: WHERE hzar.cust_account_role_id = x_source_line_rec.bill_to_contact_id
2956: AND hzr.party_id = hzar.party_id
2957: AND hzr.subject_table_name = 'HZ_PARTIES'

Line 3056: FROM hz_relationships hzr,

3052:
3053: IF x_source_line_rec.ship_to_contact_id is not null THEN
3054: SELECT hzr.subject_id
3055: INTO x_source_line_rec.ship_to_contact_party_id
3056: FROM hz_relationships hzr,
3057: hz_cust_account_roles hzar
3058: WHERE hzar.cust_account_role_id = x_source_line_rec.ship_to_contact_id
3059: AND hzr.party_id = hzar.party_id
3060: AND hzr.subject_table_name = 'HZ_PARTIES'