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_APPROVAL_PKG dependencies on AMW_NONSTANDARD_VARIATIONS_B

Line 1022: from AMW_NONSTANDARD_VARIATIONS_B

1018: and up_down_ind = 'D'
1019: and hierarchy_type = 'L'
1020: and parent_child_id not in
1021: (select NON_STD_CHILD_ID
1022: from AMW_NONSTANDARD_VARIATIONS_B
1023: where NON_STD_PROCESS_ID = process_list_rec.parent_child_id
1024: and NON_STD_PROCESS_REV_NUM = (select revision_number
1025: from amw_process
1026: where process_id = process_list_rec.parent_child_id

Line 1049: from AMW_NONSTANDARD_VARIATIONS_B

1045:
1046: begin
1047: select NON_STD_CHILD_ID
1048: into l_dummy
1049: from AMW_NONSTANDARD_VARIATIONS_B
1050: where NON_STD_PROCESS_ID = process_list_rec.parent_child_id
1051: and NON_STD_PROCESS_REV_NUM = (select revision_number
1052: from amw_process
1053: where process_id = process_list_rec.parent_child_id

Line 1100: from AMW_NONSTANDARD_VARIATIONS_B

1096: and up_down_ind = 'D'
1097: and hierarchy_type = 'L'
1098: and parent_child_id not in
1099: (select NON_STD_CHILD_ID
1100: from AMW_NONSTANDARD_VARIATIONS_B
1101: where NON_STD_PROCESS_ID = p_process_id
1102: and NON_STD_PROCESS_REV_NUM = (select revision_number
1103: from amw_process
1104: where process_id = p_process_id

Line 1127: from AMW_NONSTANDARD_VARIATIONS_B

1123:
1124: begin
1125: select NON_STD_CHILD_ID
1126: into l_dummy
1127: from AMW_NONSTANDARD_VARIATIONS_B
1128: where NON_STD_PROCESS_ID = p_process_id
1129: and NON_STD_PROCESS_REV_NUM = (select revision_number
1130: from amw_process
1131: where process_id = p_process_id