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

Line 714: FROM hz_parties hzp,

710:
711: CURSOR c_get_orgname (p_transaction_id NUMBER,
712: p_contact_type VARCHAR2) IS
713: SELECT hzp.party_name
714: FROM hz_parties hzp,
715: fun_trx_headers trx
716: WHERE hzp.party_id = DECODE(p_contact_type,'I',trx.initiator_id,
717: trx.recipient_id)
718: AND trx.trx_id = p_transaction_id;

Line 986: FROM hz_parties p,

982: AND role.role_name = 'FUN_ADHOC_RECI_'||p_transaction_id;
983: -- Bug No: 5897122
984: CURSOR c_chk_web IS
985: SELECT 'X'
986: FROM hz_parties p,
987: fnd_user fu,
988: fun_trx_headers ftrx,
989: hz_relationships hzr,
990: hz_org_contacts hc,

Line 998: AND hzr.subject_table_name = 'HZ_PARTIES'

994: AND hzr.object_id = ftrx.recipient_id
995: AND hzr.relationship_code = 'CONTACT_OF'
996: AND hzr.relationship_type = 'CONTACT'
997: AND hzr.directional_flag = 'F'
998: AND hzr.subject_table_name = 'HZ_PARTIES'
999: AND hzr.object_table_name = 'HZ_PARTIES'
1000: AND hzr.subject_type = 'PERSON'
1001: AND hc.party_relationship_id = hzr.relationship_id
1002: AND hcr.org_contact_id = hc.org_contact_id

Line 999: AND hzr.object_table_name = 'HZ_PARTIES'

995: AND hzr.relationship_code = 'CONTACT_OF'
996: AND hzr.relationship_type = 'CONTACT'
997: AND hzr.directional_flag = 'F'
998: AND hzr.subject_table_name = 'HZ_PARTIES'
999: AND hzr.object_table_name = 'HZ_PARTIES'
1000: AND hzr.subject_type = 'PERSON'
1001: AND hc.party_relationship_id = hzr.relationship_id
1002: AND hcr.org_contact_id = hc.org_contact_id
1003: AND hcr.role_type = 'INTERCOMPANY_CONTACT_FOR'

Line 1025: AND rel.subject_table_name = 'HZ_PARTIES'

1021: 'I',trx.initiator_id)
1022: AND rel.relationship_code = 'CONTACT_OF'
1023: AND rel.relationship_type = 'CONTACT'
1024: AND rel.directional_flag = 'F'
1025: AND rel.subject_table_name = 'HZ_PARTIES'
1026: AND rel.object_table_name = 'HZ_PARTIES'
1027: AND rel.subject_type = 'PERSON'
1028: AND SYSDATE BETWEEN NVL(rel.start_date, SYSDATE -1)
1029: AND NVL(rel.end_date, SYSDATE + 1)

Line 1026: AND rel.object_table_name = 'HZ_PARTIES'

1022: AND rel.relationship_code = 'CONTACT_OF'
1023: AND rel.relationship_type = 'CONTACT'
1024: AND rel.directional_flag = 'F'
1025: AND rel.subject_table_name = 'HZ_PARTIES'
1026: AND rel.object_table_name = 'HZ_PARTIES'
1027: AND rel.subject_type = 'PERSON'
1028: AND SYSDATE BETWEEN NVL(rel.start_date, SYSDATE -1)
1029: AND NVL(rel.end_date, SYSDATE + 1)
1030: AND c.party_relationship_id = rel.relationship_id