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_CUST_ACCOUNT_ROLES

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

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

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

1590:
1591: BEGIN
1592: SELECT a.person_last_name, a.person_first_name
1593: INTO l_header_val_rec.sold_to_contact_last_name, l_header_val_rec.sold_to_contact_first_name
1594: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c
1595: WHERE c.cust_account_role_id = l_header_rec.sold_to_contact_id
1596: AND c.party_id=b.party_id
1597: AND b.subject_id=a.party_id
1598: AND c.CUST_ACCOUNT_ID = l_header_rec.sold_to_org_id

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

1613: BEGIN
1614:
1615: SELECT a.person_last_name, a.person_first_name
1616: INTO l_header_val_rec.ship_to_contact_last_name, l_header_val_rec.ship_to_contact_first_name
1617: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c
1618: WHERE c.cust_account_role_id = l_header_rec.ship_to_contact_id
1619: AND c.party_id=b.party_id
1620: AND b.subject_id=a.party_id
1621: AND c.CUST_ACCOUNT_ID = l_header_rec.sold_to_org_id

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

1737:
1738: BEGIN
1739: SELECT a.person_last_name, a.person_first_name
1740: INTO l_header_val_rec.invoice_to_contact_last_name, l_header_val_rec.invoice_to_contact_first_name
1741: FROM hz_parties a, hz_relationships b, hz_cust_account_roles c
1742: WHERE c.cust_account_role_id = l_header_rec.invoice_to_contact_id
1743: AND c.party_id=b.party_id
1744: AND b.subject_id=a.party_id
1745: AND c.CUST_ACCOUNT_ID = l_header_rec.sold_to_org_id