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.OE_VALIDATE_LINE dependencies on OE_WORKFLOW_ASSIGNMENTS

Line 1146: FROM oe_workflow_assignments a

1142: lline_category_code VARCHAR2(30);
1143:
1144: CURSOR find_LineProcessname IS
1145: SELECT 'EXISTS'
1146: FROM oe_workflow_assignments a
1147: WHERE a.line_type_id = p_line_rec.line_type_id
1148: AND nvl(a.item_type_code,nvl(l_new_wf_item_type,'-99')) = nvl(l_new_wf_item_type,'-99')
1149: AND a.process_name = lprocessname
1150: AND a.order_type_id = lorder_type_id

Line 1162: FROM oe_workflow_assignments a

1158: WHERE header_id = p_line_rec.header_id ;
1159:
1160: Cursor find_config_assign is
1161: SELECT 'EXISTS'
1162: FROM oe_workflow_assignments a
1163: WHERE a.line_type_id = p_line_rec.line_type_id
1164: AND a.item_type_code = l_new_wf_item_type
1165: AND a.order_type_id = lorder_type_id
1166: AND sysdate between A.START_DATE_ACTIVE