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 1918: FROM HZ_PARTIES HPC,

1914:
1915: /* Below query checks for the duplicate contacts */
1916:
1917: SELECT Count(*) INTO l_duplicateRow
1918: FROM HZ_PARTIES HPC,
1919: HZ_CONTACT_POINTS HCPP,
1920: HZ_CONTACT_POINTS HCPE,
1921: HZ_RELATIONSHIPS HR
1922: WHERE HR.SUBJECT_ID = l_suppPartyId

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

1919: HZ_CONTACT_POINTS HCPP,
1920: HZ_CONTACT_POINTS HCPE,
1921: HZ_RELATIONSHIPS HR
1922: WHERE HR.SUBJECT_ID = l_suppPartyId
1923: AND HCPP.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
1924: AND HCPP.OWNER_TABLE_ID (+) = HR.PARTY_ID
1925: AND HCPP.PHONE_LINE_TYPE (+) = 'GEN'
1926: AND HCPP.CONTACT_POINT_TYPE (+) = 'PHONE'
1927: AND HCPE.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'

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

1923: AND HCPP.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
1924: AND HCPP.OWNER_TABLE_ID (+) = HR.PARTY_ID
1925: AND HCPP.PHONE_LINE_TYPE (+) = 'GEN'
1926: AND HCPP.CONTACT_POINT_TYPE (+) = 'PHONE'
1927: AND HCPE.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
1928: AND HCPE.OWNER_TABLE_ID (+) = HR.PARTY_ID
1929: AND HCPE.CONTACT_POINT_TYPE (+) = 'EMAIL'
1930: AND HR.OBJECT_ID = HPC.PARTY_ID
1931: AND HR.SUBJECT_TYPE = 'ORGANIZATION'

Line 1932: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1928: AND HCPE.OWNER_TABLE_ID (+) = HR.PARTY_ID
1929: AND HCPE.CONTACT_POINT_TYPE (+) = 'EMAIL'
1930: AND HR.OBJECT_ID = HPC.PARTY_ID
1931: AND HR.SUBJECT_TYPE = 'ORGANIZATION'
1932: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1933: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1934: AND HR.OBJECT_TYPE = 'PERSON'
1935: AND HR.RELATIONSHIP_CODE = 'CONTACT'
1936: AND HR.DIRECTIONAL_FLAG = 'B'

Line 1933: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'

1929: AND HCPE.CONTACT_POINT_TYPE (+) = 'EMAIL'
1930: AND HR.OBJECT_ID = HPC.PARTY_ID
1931: AND HR.SUBJECT_TYPE = 'ORGANIZATION'
1932: AND HR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1933: AND HR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1934: AND HR.OBJECT_TYPE = 'PERSON'
1935: AND HR.RELATIONSHIP_CODE = 'CONTACT'
1936: AND HR.DIRECTIONAL_FLAG = 'B'
1937: AND HR.RELATIONSHIP_TYPE = 'CONTACT'