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.ONT_OEXCEXP_XMLP_PKG dependencies on HZ_RELATIONSHIPS

Line 349: HZ_RELATIONSHIPS

345: OBJECT_ID,
346: SUBJECT_ID,
347: LEVEL
348: FROM
349: HZ_RELATIONSHIPS
350: WHERE RELATIONSHIP_TYPE = L_REL_TYPE
351: START WITH SUBJECT_ID = L_TOP_PARENT
352: CONNECT BY PRIOR OBJECT_ID = SUBJECT_ID
353: AND DIRECTION_CODE = 'P';

Line 594: FROM HZ_RELATIONSHIPS

590: IF P_SPECIFIC_PARTY_ID IS NOT NULL
591: THEN
592: SELECT COUNT(1)
593: INTO L_COUNT
594: FROM HZ_RELATIONSHIPS
595: WHERE RELATIONSHIP_TYPE=L_PROFILE
596: AND (SUBJECT_ID=P_SPECIFIC_PARTY_ID
597: OR OBJECT_ID=P_SPECIFIC_PARTY_ID);
598:

Line 603: FROM HZ_RELATIONSHIPS

599: ELSIF P_SPEC_PARTY_NUM_ID IS NOT NULL
600: THEN
601: SELECT COUNT(1)
602: INTO L_COUNT
603: FROM HZ_RELATIONSHIPS
604: WHERE RELATIONSHIP_TYPE=L_PROFILE
605: AND (SUBJECT_ID=P_SPEC_PARTY_NUM_ID
606: OR OBJECT_ID=P_SPEC_PARTY_NUM_ID);
607: