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

Line 13350: HZ_PARTIES P,

13346: CURSOR get_line_contact(p_attr_code IN Varchar2) IS
13347: SELECT SUBSTRB(P.PERSON_LAST_NAME,1,50) || ', ' ||
13348: SUBSTRB(P.PERSON_FIRST_NAME,1,40) NAME
13349: FROM HZ_CUST_ACCOUNT_ROLES CAR,
13350: HZ_PARTIES P,
13351: --NPALEPU
13352: --29-JUN-2005
13353: --TCA Project
13354: --Replaced hz_party_relationships table with hz_relationships table

Line 13368: AND PR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

13364: --TCA Project
13365: --Replaced pr.party_relationship_id column with pr.relationship_id column and added new conditions
13366: /* AND OC.PARTY_RELATIONSHIP_ID = PR.PARTY_RELATIONSHIP_ID */
13367: AND OC.PARTY_RELATIONSHIP_ID = PR.RELATIONSHIP_ID
13368: AND PR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
13369: AND PR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
13370: AND PR.DIRECTIONAL_FLAG = 'F'
13371: --END NPALEPU
13372: AND P.PARTY_ID = PR.SUBJECT_ID

Line 13369: AND PR.OBJECT_TABLE_NAME = 'HZ_PARTIES'

13365: --Replaced pr.party_relationship_id column with pr.relationship_id column and added new conditions
13366: /* AND OC.PARTY_RELATIONSHIP_ID = PR.PARTY_RELATIONSHIP_ID */
13367: AND OC.PARTY_RELATIONSHIP_ID = PR.RELATIONSHIP_ID
13368: AND PR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
13369: AND PR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
13370: AND PR.DIRECTIONAL_FLAG = 'F'
13371: --END NPALEPU
13372: AND P.PARTY_ID = PR.SUBJECT_ID
13373: --NPALEPU