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

Line 1037: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c

1033: BEGIN
1034: SELECT a.person_last_name, a.person_first_name
1035: INTO l_line_val_tbl(I).ship_to_contact_last_name,
1036: l_line_val_tbl(I).ship_to_contact_first_name
1037: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c
1038: WHERE c.cust_account_role_id = l_header_rec.sold_to_contact_id
1039: AND c.party_id=b.party_id
1040: AND b.subject_id=a.party_id
1041: AND c.CUST_ACCOUNT_ID = l_header_rec.sold_to_org_id

Line 1621: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c

1617:
1618: BEGIN
1619: SELECT a.person_last_name, a.person_first_name
1620: INTO l_header_val_rec.sold_to_contact_last_name, l_header_val_rec.sold_to_contact_first_name
1621: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c
1622: WHERE c.cust_account_role_id = l_header_rec.sold_to_contact_id
1623: AND c.party_id=b.party_id
1624: AND b.subject_id=a.party_id
1625: AND c.CUST_ACCOUNT_ID = l_header_rec.sold_to_org_id

Line 1644: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c

1640: BEGIN
1641:
1642: SELECT a.person_last_name, a.person_first_name
1643: INTO l_header_val_rec.ship_to_contact_last_name, l_header_val_rec.ship_to_contact_first_name
1644: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c
1645: WHERE c.cust_account_role_id = l_header_rec.ship_to_contact_id
1646: AND c.party_id=b.party_id
1647: AND b.subject_id=a.party_id
1648: AND c.CUST_ACCOUNT_ID = l_header_rec.sold_to_org_id

Line 1768: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c

1764:
1765: BEGIN
1766: SELECT a.person_last_name, a.person_first_name
1767: INTO l_header_val_rec.invoice_to_contact_last_name, l_header_val_rec.invoice_to_contact_first_name
1768: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c
1769: WHERE c.cust_account_role_id = l_header_rec.invoice_to_contact_id
1770: AND c.party_id=b.party_id
1771: AND b.subject_id=a.party_id
1772: AND c.CUST_ACCOUNT_ID = l_header_rec.sold_to_org_id