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 325: FROM WIP_OPERATIONS WOP,

321: AND p_source_code = 'RCV';
322:
323: SELECT COUNT(1)
324: INTO x_no_move_count
325: FROM WIP_OPERATIONS WOP,
326: WIP_OPERATION_RESOURCES WOR,
327: WIP_PARAMETERS WP,
328: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
329: WIP_SHOP_FLOOR_STATUSES WSFS

Line 451: wip_operations wo1

447: SELECT count(*)
448: INTO l_no_move_count
449: FROM wip_shop_floor_status_codes wsc,
450: wip_shop_floor_statuses ws,
451: wip_operations wo1
452: WHERE ws.organization_id = p_org_id
453: AND ws.wip_entity_id = p_wip_id
454: AND wsc.organization_id = ws.organization_id
455: AND wo1.operation_seq_num = ws.operation_seq_num

Line 460: FROM wip_operations wo2

456: AND wo1.organization_id = ws.organization_id
457: AND wo1.wip_entity_id = ws.wip_entity_id
458: AND wo1.operation_seq_num =
459: (SELECT max(wo2.operation_seq_num)
460: FROM wip_operations wo2
461: WHERE wo2.organization_id = wo1.organization_id
462: AND wo2.wip_entity_id = wo1.wip_entity_id)
463: AND ws.intraoperation_step_type = WIP_CONSTANTS.TOMOVE
464: AND ws.shop_floor_status_code = wsc.shop_floor_status_code

Line 501: FROM WIP_OPERATIONS WOP,

497:
498: begin
499: SELECT WSFS.SHOP_FLOOR_STATUS_CODE
500: INTO x_sf_status
501: FROM WIP_OPERATIONS WOP,
502: WIP_OPERATION_RESOURCES WOR,
503: WIP_PARAMETERS WP,
504: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
505: WIP_SHOP_FLOOR_STATUSES WSFS