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 2907: FROM hz_relationships hzr,

2903:
2904: IF x_source_line_rec.ship_to_contact_id is not null THEN
2905: SELECT hzr.subject_id
2906: INTO x_source_line_rec.ship_to_contact_party_id
2907: FROM hz_relationships hzr,
2908: hz_cust_account_roles hzar
2909: WHERE hzar.cust_account_role_id = x_source_line_rec.ship_to_contact_id
2910: AND hzr.party_id = hzar.party_id
2911: AND hzr.subject_table_name = 'HZ_PARTIES'

Line 2919: FROM hz_relationships hzr,

2915:
2916: IF x_source_line_rec.bill_to_contact_id is not null THEN
2917: SELECT hzr.subject_id
2918: INTO x_source_line_rec.bill_to_contact_party_id
2919: FROM hz_relationships hzr,
2920: hz_cust_account_roles hzar
2921: WHERE hzar.cust_account_role_id = x_source_line_rec.bill_to_contact_id
2922: AND hzr.party_id = hzar.party_id
2923: AND hzr.subject_table_name = 'HZ_PARTIES'

Line 3022: FROM hz_relationships hzr,

3018:
3019: IF x_source_line_rec.ship_to_contact_id is not null THEN
3020: SELECT hzr.subject_id
3021: INTO x_source_line_rec.ship_to_contact_party_id
3022: FROM hz_relationships hzr,
3023: hz_cust_account_roles hzar
3024: WHERE hzar.cust_account_role_id = x_source_line_rec.ship_to_contact_id
3025: AND hzr.party_id = hzar.party_id
3026: AND hzr.subject_table_name = 'HZ_PARTIES'