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.AMW_CREATE_LINES_PKG dependencies on AMW_LATEST_HIERARCHIES

Line 699: from amw_process_organization_vl apo, amw_latest_hierarchies alh

695: apo.display_name display_name,
696: apo.revision_number revision_number,
697: apo.approval_status approval_status,
698: apo.description description
699: from amw_process_organization_vl apo, amw_latest_hierarchies alh
700: where
701: alh.organization_id = p_pk1
702: and alh.parent_id = p_pk2
703: and apo.process_id = alh.child_id

Line 894: amw_latest_hierarchies

890: ,ACAV.DESCRIPTION
891: FROM AMW_CONTROLS_ALL_VL ACAV
892: ,AMW_CONTROL_ASSOCIATIONS ACA
893: ,(select distinct child_id from
894: amw_latest_hierarchies
895: START WITH CHILD_ID = p_pk2 AND ORGANIZATION_ID = p_pk1
896: CONNECT BY PRIOR CHILD_ID = PARENT_ID
897: and organization_id = p_pk1 ) AOHD
898: WHERE ACA.PK1 = p_pk1