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_SUB_OPERATION_RESOURCES

Line 531: wip_sub_operation_resources wsor

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
535: AND wsor.organization_id = wo.organization_id

Line 562: wip_sub_operation_resources wsor,

558: select distinct nvl(dept_res.share_from_dept_id, dept_res.department_id),
559: dept_res.resource_id,
560: NVL(dept_res.available_24_hours_flag, 2)
561: from bom_department_resources dept_res,
562: wip_sub_operation_resources wsor,
563: bom_setup_transitions bst,
564: bom_standard_operations bso,
565: bom_std_op_resources bsor
566: where wsor.wip_entity_id = p_wip_entity_id

Line 714: wip_sub_operation_resources wsor

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
718: AND wsor.organization_id = wo.organization_id

Line 755: wip_sub_operation_resources wsor,

751: dept_ins.instance_id,
752: dept_ins.serial_number
753: from bom_department_resources dept_res,
754: bom_dept_res_instances dept_ins,
755: wip_sub_operation_resources wsor,
756: bom_setup_transitions bst,
757: bom_standard_operations bso,
758: bom_std_op_resources bsor
759: where wsor.wip_entity_id = p_wip_entity_id