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_PROC_ORG_APPROVAL_PKG dependencies on AMW_LATEST_HIERARCHY_ORG_V

Line 119: from amw_latest_hierarchy_ORG_V

115: CREATED_BY,
116: object_version_number
117: )
118: (select p_org_id, p_process_id, child_process_id, sysdate, G_USER_ID, G_LOGIN_ID, sysdate, G_USER_ID, 1
119: from amw_latest_hierarchy_ORG_V
120: where parent_process_id = p_process_id
121: and child_organization_id = p_org_id);
122:
123: elsif (approv_choice = 'C') then

Line 607: from (select * from amw_latest_hierarchy_ORG_V where child_organization_id = p_org_id and parent_approval_status = 'A' and child_approval_status = 'A')

603: -- executed when step = 1
604: /*ksr commenting
605: CURSOR c1 is
606: (select parent_process_id, child_process_id, child_order_number
607: from (select * from amw_latest_hierarchy_ORG_V where child_organization_id = p_org_id and parent_approval_status = 'A' and child_approval_status = 'A')
608: start with parent_process_id = -2
609: connect by prior child_process_id = parent_process_id)
610: MINUS
611: (select parent_process_id, child_process_id, child_order_number

Line 623: (select parent_process_id, child_process_id from amw_latest_hierarchy_ORG_V

619: (select parent_process_id, child_process_id from AMW_CURR_APP_HIERARCHY_ORG_V
620: where parent_process_id = p_process_id
621: and child_organization_id = p_org_id)
622: MINUS
623: (select parent_process_id, child_process_id from amw_latest_hierarchy_ORG_V
624: where parent_process_id = p_process_id
625: and child_organization_id = p_org_id);
626:
627: -- as a result of the children being removed in c2 some links may become