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.WPS_COMMON dependencies on WIP_OPERATIONS

Line 516: wip_operations wo,

512: select distinct nvl(dept_res.share_from_dept_id, dept_res.department_id),
513: dept_res.resource_id,
514: NVL(dept_res.available_24_hours_flag, 2)
515: from bom_department_resources dept_res,
516: wip_operations wo,
517: wip_operation_resources wor
518: WHERE wo.wip_entity_id = p_wip_entity_id
519: AND wo.organization_id = p_organization_id
520: AND wor.wip_entity_id = wo.wip_entity_id

Line 530: wip_operations wo,

526: select distinct nvl(dept_res.share_from_dept_id, dept_res.department_id),
527: dept_res.resource_id,
528: NVL(dept_res.available_24_hours_flag, 2)
529: from bom_department_resources dept_res,
530: wip_operations wo,
531: wip_sub_operation_resources wsor
532: WHERE wo.wip_entity_id = p_wip_entity_id
533: AND wo.organization_id = p_organization_id
534: AND wsor.wip_entity_id = wo.wip_entity_id

Line 668: wip_operations wo,

664: dept_ins.instance_id,
665: dept_ins.serial_number
666: from bom_department_resources dept_res,
667: bom_dept_res_instances dept_ins,
668: wip_operations wo,
669: wip_operation_resources wor
670: WHERE wo.wip_entity_id = p_wip_entity_id
671: AND wo.organization_id = p_organization_id
672: AND wor.wip_entity_id = wo.wip_entity_id

Line 687: wip_operations wo,

683: ins_changes.instance_id,
684: ins_changes.serial_number
685: from bom_department_resources dept_res,
686: bom_res_instance_changes ins_changes,
687: wip_operations wo,
688: wip_operation_resources wor
689: WHERE wo.wip_entity_id = p_wip_entity_id
690: AND wo.organization_id = p_organization_id
691: AND wor.wip_entity_id = wo.wip_entity_id

Line 713: wip_operations wo,

709: dept_ins.instance_id,
710: dept_ins.serial_number
711: from bom_department_resources dept_res,
712: bom_dept_res_instances dept_ins,
713: wip_operations wo,
714: wip_sub_operation_resources wsor
715: WHERE wo.wip_entity_id = p_wip_entity_id
716: AND wo.organization_id = p_organization_id
717: AND wsor.wip_entity_id = wo.wip_entity_id

Line 1602: from wip_operations wo,

1598: BEGIN
1599:
1600: SELECT SUM(((WO.QUANTITY_COMPLETED+wo.QUANTITY_SCRAPPED)/wo.SCHEDULED_QUANTITY)*(wo.LAST_UNIT_COMPLETION_DATE - wo.FIRST_UNIT_START_DATE)),
1601: SUM(wo.LAST_UNIT_COMPLETION_DATE - wo.FIRST_UNIT_START_DATE) into completed, total
1602: from wip_operations wo,
1603: wip_discrete_jobs wdj
1604: where wdj.wip_entity_id = p_wip_entity_id
1605: and wo.wip_entity_id = wdj.wip_entity_id
1606: and wo.organization_id = wdj.organization_id;