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_SF_STATUS dependencies on WIP_OPERATIONS

Line 306: FROM WIP_OPERATIONS WOP,

302:
303: begin
304: SELECT COUNT(1)
305: INTO x_no_move_count
306: FROM WIP_OPERATIONS WOP,
307: WIP_OPERATION_RESOURCES WOR,
308: WIP_PARAMETERS WP,
309: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
310: WIP_SHOP_FLOOR_STATUSES WSFS

Line 439: wip_operations wo1

435: SELECT count(*)
436: INTO l_no_move_count
437: FROM wip_shop_floor_status_codes wsc,
438: wip_shop_floor_statuses ws,
439: wip_operations wo1
440: WHERE ws.organization_id = p_org_id
441: AND ws.wip_entity_id = p_wip_id
442: AND wsc.organization_id = ws.organization_id
443: AND wo1.operation_seq_num = ws.operation_seq_num

Line 448: FROM wip_operations wo2

444: AND wo1.organization_id = ws.organization_id
445: AND wo1.wip_entity_id = ws.wip_entity_id
446: AND wo1.operation_seq_num =
447: (SELECT max(wo2.operation_seq_num)
448: FROM wip_operations wo2
449: WHERE wo2.organization_id = wo1.organization_id
450: AND wo2.wip_entity_id = wo1.wip_entity_id)
451: AND ws.intraoperation_step_type = WIP_CONSTANTS.TOMOVE
452: AND ws.shop_floor_status_code = wsc.shop_floor_status_code