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

Line 1972: FROM HZ_PARTIES HPC,

1968:
1969: /* Below query checks for the duplicate contacts */
1970:
1971: SELECT Count(*) INTO l_duplicateRow
1972: FROM HZ_PARTIES HPC,
1973: HZ_CONTACT_POINTS HCPP,
1974: HZ_CONTACT_POINTS HCPE,
1975: HZ_RELATIONSHIPS HR
1976: WHERE HR.SUBJECT_ID = l_suppPartyId

Line 1977: AND HCPP.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'

1973: HZ_CONTACT_POINTS HCPP,
1974: HZ_CONTACT_POINTS HCPE,
1975: HZ_RELATIONSHIPS HR
1976: WHERE HR.SUBJECT_ID = l_suppPartyId
1977: AND HCPP.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
1978: AND HCPP.OWNER_TABLE_ID (+) = HR.PARTY_ID
1979: AND HCPP.PHONE_LINE_TYPE (+) = 'GEN'
1980: AND HCPP.CONTACT_POINT_TYPE (+) = 'PHONE'
1981: AND HCPE.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'

Line 1981: AND HCPE.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'

1977: AND HCPP.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
1978: AND HCPP.OWNER_TABLE_ID (+) = HR.PARTY_ID
1979: AND HCPP.PHONE_LINE_TYPE (+) = 'GEN'
1980: AND HCPP.CONTACT_POINT_TYPE (+) = 'PHONE'
1981: AND HCPE.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
1982: AND HCPE.OWNER_TABLE_ID (+) = HR.PARTY_ID
1983: AND HCPE.CONTACT_POINT_TYPE (+) = 'EMAIL'
1984: AND HR.OBJECT_ID = HPC.PARTY_ID
1985: AND HR.SUBJECT_TYPE = 'ORGANIZATION'

Line 1986: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1982: AND HCPE.OWNER_TABLE_ID (+) = HR.PARTY_ID
1983: AND HCPE.CONTACT_POINT_TYPE (+) = 'EMAIL'
1984: AND HR.OBJECT_ID = HPC.PARTY_ID
1985: AND HR.SUBJECT_TYPE = 'ORGANIZATION'
1986: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1987: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1988: AND HR.OBJECT_TYPE = 'PERSON'
1989: AND HR.RELATIONSHIP_CODE = 'CONTACT'
1990: AND HR.DIRECTIONAL_FLAG = 'B'

Line 1987: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1983: AND HCPE.CONTACT_POINT_TYPE (+) = 'EMAIL'
1984: AND HR.OBJECT_ID = HPC.PARTY_ID
1985: AND HR.SUBJECT_TYPE = 'ORGANIZATION'
1986: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1987: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1988: AND HR.OBJECT_TYPE = 'PERSON'
1989: AND HR.RELATIONSHIP_CODE = 'CONTACT'
1990: AND HR.DIRECTIONAL_FLAG = 'B'
1991: AND HR.RELATIONSHIP_TYPE = 'CONTACT'