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.WIP_WS_DL_UTIL dependencies on WIP_EXCEPTIONS

Line 468: from wip_exceptions we

464: is
465: cursor c_num_exceptions(p_wip_entity_id number, p_op_seq number)
466: Is
467: select count(we.exception_id)
468: from wip_exceptions we
469: where we.wip_entity_id = p_wip_entity_id and
470: we.operation_seq_num = p_op_seq and
471: we.status_type = 1;
472:

Line 476: from wip_exceptions we, mfg_lookups ml

472:
473: cursor c_exceptions(p_wip_entity_id number, p_op_seq number)
474: Is
475: select ml.MEANING
476: from wip_exceptions we, mfg_lookups ml
477: where we.wip_entity_id = p_wip_entity_id and
478: we.operation_seq_num = p_op_seq and
479: we.status_type = 1 and
480: ml.LOOKUP_CODE = we.exception_type and

Line 877: from wip_exceptions we

873: l_num_exceptions number;
874: Begin
875: select count(*)
876: into l_num_exceptions
877: from wip_exceptions we
878: where we.wip_entity_id = p_wip_entity_id and
879: we.operation_seq_num = p_op_seq_num and
880: we.status_type = 1;
881: return l_num_exceptions;