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

Line 1975: from hz_parties hp, hz_code_assignments hca

1971: x_shipto_name := '';
1972:
1973: select count(*)
1974: into l_num_enterprises
1975: from hz_parties hp, hz_code_assignments hca
1976: where hca.owner_table_id = hp.party_id
1977: and hca.owner_table_name = 'HZ_PARTIES'
1978: and hca.class_category = 'POS_PARTICIPANT_TYPE'
1979: and hca.class_code = 'ENTERPRISE'

Line 1977: and hca.owner_table_name = 'HZ_PARTIES'

1973: select count(*)
1974: into l_num_enterprises
1975: from hz_parties hp, hz_code_assignments hca
1976: where hca.owner_table_id = hp.party_id
1977: and hca.owner_table_name = 'HZ_PARTIES'
1978: and hca.class_category = 'POS_PARTICIPANT_TYPE'
1979: and hca.class_code = 'ENTERPRISE'
1980: and hca.status= 'A'
1981: and hp.status= 'A'

Line 1987: from hz_parties hp, hz_code_assignments hca

1983:
1984: IF l_num_enterprises = 1 THEN
1985: select hp.party_name
1986: into x_shipto_name
1987: from hz_parties hp, hz_code_assignments hca
1988: where hca.owner_table_id = hp.party_id
1989: and hca.owner_table_name = 'HZ_PARTIES'
1990: and hca.class_category = 'POS_PARTICIPANT_TYPE'
1991: and hca.class_code = 'ENTERPRISE'

Line 1989: and hca.owner_table_name = 'HZ_PARTIES'

1985: select hp.party_name
1986: into x_shipto_name
1987: from hz_parties hp, hz_code_assignments hca
1988: where hca.owner_table_id = hp.party_id
1989: and hca.owner_table_name = 'HZ_PARTIES'
1990: and hca.class_category = 'POS_PARTICIPANT_TYPE'
1991: and hca.class_code = 'ENTERPRISE'
1992: and hca.status= 'A'
1993: and hp.status= 'A'