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_PARTIES

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 1041: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1041: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1042: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1043: AND b.DIRECTIONAL_FLAG = 'F';
1044: IF l_debug_level > 0 THEN
1045: oe_debug_pub.add( 'SHIP TO CONTACT = '||L_LINE_VAL_TBL ( I ) .SHIP_TO_CONTACT_LAST_NAME ) ;

Line 1042: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1041: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1042: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1043: AND b.DIRECTIONAL_FLAG = 'F';
1044: IF l_debug_level > 0 THEN
1045: oe_debug_pub.add( 'SHIP TO CONTACT = '||L_LINE_VAL_TBL ( I ) .SHIP_TO_CONTACT_LAST_NAME ) ;
1046: END IF;

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 1599: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1599: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1600: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1601: AND b.DIRECTIONAL_FLAG = 'F';
1602: IF l_debug_level > 0 THEN
1603: oe_debug_pub.add( 'SOLD TO CONTACT = '||L_HEADER_VAL_REC.SOLD_TO_CONTACT_LAST_NAME ) ;

Line 1600: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1599: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1600: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1601: AND b.DIRECTIONAL_FLAG = 'F';
1602: IF l_debug_level > 0 THEN
1603: oe_debug_pub.add( 'SOLD TO CONTACT = '||L_HEADER_VAL_REC.SOLD_TO_CONTACT_LAST_NAME ) ;
1604: END IF;

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 1622: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1622: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1623: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1624: AND b.DIRECTIONAL_FLAG = 'F';
1625: IF l_debug_level > 0 THEN
1626: oe_debug_pub.add( 'SHIP TO CONTACT = '||L_HEADER_VAL_REC.SHIP_TO_CONTACT_LAST_NAME ) ;

Line 1623: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1622: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1623: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1624: AND b.DIRECTIONAL_FLAG = 'F';
1625: IF l_debug_level > 0 THEN
1626: oe_debug_pub.add( 'SHIP TO CONTACT = '||L_HEADER_VAL_REC.SHIP_TO_CONTACT_LAST_NAME ) ;
1627: END IF;

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

Line 1746: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1746: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1747: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1748: AND b.DIRECTIONAL_FLAG = 'F';
1749: IF l_debug_level > 0 THEN
1750: oe_debug_pub.add( 'INVOICE TO CONTACT = '||L_HEADER_VAL_REC.INVOICE_TO_CONTACT_LAST_NAME ) ;

Line 1747: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1746: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1747: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1748: AND b.DIRECTIONAL_FLAG = 'F';
1749: IF l_debug_level > 0 THEN
1750: oe_debug_pub.add( 'INVOICE TO CONTACT = '||L_HEADER_VAL_REC.INVOICE_TO_CONTACT_LAST_NAME ) ;
1751: END IF;