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.

[Home] [Help]

APPS.PON_ATTR_MAPPING dependencies on HZ_CODE_ASSIGNMENTS

Line 91: FROM hz_code_assignments

87: IS
88: SELECT 'HZ:'|| hccr.class_category || ':' || hccr.class_code AS code
89: FROM hz_class_code_relations hccr,
90: ( SELECT class_category, class_code, owner_table_id
91: FROM hz_code_assignments
92: WHERE owner_table_name = 'HZ_PARTIES'
93: AND owner_table_id = x_party_id
94: AND start_date_active <= SYSDATE
95: AND NVL(end_date_active, SYSDATE) >= SYSDATE

Line 104: FROM hz_code_assignments

100: UNION
101: SELECT 'HZ:'|| fnd.lookup_type || ':' || fnd.lookup_code
102: FROM fnd_lookup_values_vl fnd,
103: ( SELECT class_category, class_code, owner_table_id
104: FROM hz_code_assignments
105: WHERE owner_table_name = 'HZ_PARTIES'
106: AND owner_table_id = x_party_id
107: AND start_date_active <= SYSDATE
108: AND nvl(end_date_active, SYSDATE) >= SYSDATE