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

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

Line 1043: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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

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

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
1626: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1627: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1628: AND b.DIRECTIONAL_FLAG = 'F';
1629: IF l_debug_level > 0 THEN
1630: oe_debug_pub.add( 'SOLD TO CONTACT = '||L_HEADER_VAL_REC.SOLD_TO_CONTACT_LAST_NAME ) ;

Line 1627: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1626: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1627: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1628: AND b.DIRECTIONAL_FLAG = 'F';
1629: IF l_debug_level > 0 THEN
1630: oe_debug_pub.add( 'SOLD TO CONTACT = '||L_HEADER_VAL_REC.SOLD_TO_CONTACT_LAST_NAME ) ;
1631: END IF;

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

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
1649: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1650: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1651: AND b.DIRECTIONAL_FLAG = 'F';
1652: IF l_debug_level > 0 THEN
1653: oe_debug_pub.add( 'SHIP TO CONTACT = '||L_HEADER_VAL_REC.SHIP_TO_CONTACT_LAST_NAME ) ;

Line 1650: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1649: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1650: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1651: AND b.DIRECTIONAL_FLAG = 'F';
1652: IF l_debug_level > 0 THEN
1653: oe_debug_pub.add( 'SHIP TO CONTACT = '||L_HEADER_VAL_REC.SHIP_TO_CONTACT_LAST_NAME ) ;
1654: END IF;

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

Line 1773: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1773: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1774: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1775: AND b.DIRECTIONAL_FLAG = 'F';
1776: IF l_debug_level > 0 THEN
1777: oe_debug_pub.add( 'INVOICE TO CONTACT = '||L_HEADER_VAL_REC.INVOICE_TO_CONTACT_LAST_NAME ) ;

Line 1774: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'

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
1773: AND b.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1774: AND b.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1775: AND b.DIRECTIONAL_FLAG = 'F';
1776: IF l_debug_level > 0 THEN
1777: oe_debug_pub.add( 'INVOICE TO CONTACT = '||L_HEADER_VAL_REC.INVOICE_TO_CONTACT_LAST_NAME ) ;
1778: END IF;