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_WPS_COMMON dependencies on STANDARD

Line 544: bom_standard_operations bso,

540: select distinct bdr.department_id department_id,
541: bdr.resource_id,
542: nvl(bdr.available_24_hours_flag, 2)
543: from bom_std_op_resources bsor,
544: bom_standard_operations bso,
545: bom_department_resources bdr,
546: bom_setup_transitions bst,
547: wip_operation_resources wor
548: WHERE wor.organization_id = p_organization_id

Line 553: AND bso.standard_operation_id = bst.operation_id

549: AND wor.wip_entity_id = p_wip_entity_id
550: AND wor.setup_id is not null
551: AND bst.resource_id = wor.resource_id
552: AND bst.to_setup_id = wor.setup_id
553: AND bso.standard_operation_id = bst.operation_id
554: AND bsor.standard_operation_id = bso.standard_operation_id
555: AND bdr.department_id = bso.department_id
556: AND bdr.resource_id = bsor.resource_id
557: union

Line 554: AND bsor.standard_operation_id = bso.standard_operation_id

550: AND wor.setup_id is not null
551: AND bst.resource_id = wor.resource_id
552: AND bst.to_setup_id = wor.setup_id
553: AND bso.standard_operation_id = bst.operation_id
554: AND bsor.standard_operation_id = bso.standard_operation_id
555: AND bdr.department_id = bso.department_id
556: AND bdr.resource_id = bsor.resource_id
557: union
558: select distinct nvl(dept_res.share_from_dept_id, dept_res.department_id),

Line 564: bom_standard_operations bso,

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
567: and wsor.organization_id = p_organization_id
568: and wsor.setup_id is not null

Line 571: and bso.standard_operation_id = bst.operation_id

567: and wsor.organization_id = p_organization_id
568: and wsor.setup_id is not null
569: and bst.resource_id = wsor.resource_id
570: and bst.to_setup_id = wsor.setup_id
571: and bso.standard_operation_id = bst.operation_id
572: and bsor.standard_operation_id = bso.standard_operation_id
573: and dept_res.department_id = bso.department_id
574: and dept_res.resource_id = bsor.resource_id;
575:

Line 572: and bsor.standard_operation_id = bso.standard_operation_id

568: and wsor.setup_id is not null
569: and bst.resource_id = wsor.resource_id
570: and bst.to_setup_id = wsor.setup_id
571: and bso.standard_operation_id = bst.operation_id
572: and bsor.standard_operation_id = bso.standard_operation_id
573: and dept_res.department_id = bso.department_id
574: and dept_res.resource_id = bsor.resource_id;
575:
576:

Line 734: bom_standard_operations bso,

730: from bom_department_resources dept_res,
731: bom_dept_res_instances dept_ins,
732: wip_operation_resources wor,
733: bom_setup_transitions bst,
734: bom_standard_operations bso,
735: bom_std_op_resources bsor
736: where wor.wip_entity_id = p_wip_entity_id
737: and wor.organization_id = p_organization_id
738: and wor.setup_id is not null

Line 741: and bso.standard_operation_id = bst.operation_id

737: and wor.organization_id = p_organization_id
738: and wor.setup_id is not null
739: and bst.resource_id = wor.resource_id
740: and bst.to_setup_id = wor.setup_id
741: and bso.standard_operation_id = bst.operation_id
742: and bsor.standard_operation_id = bso.standard_operation_id
743: and dept_res.department_id = bso.department_id
744: and dept_res.resource_id = bsor.resource_id
745: AND dept_ins.department_id = dept_res.department_id

Line 742: and bsor.standard_operation_id = bso.standard_operation_id

738: and wor.setup_id is not null
739: and bst.resource_id = wor.resource_id
740: and bst.to_setup_id = wor.setup_id
741: and bso.standard_operation_id = bst.operation_id
742: and bsor.standard_operation_id = bso.standard_operation_id
743: and dept_res.department_id = bso.department_id
744: and dept_res.resource_id = bsor.resource_id
745: AND dept_ins.department_id = dept_res.department_id
746: AND dept_ins.resource_id = dept_res.resource_id

Line 757: bom_standard_operations bso,

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
760: and wsor.organization_id = p_organization_id
761: and wsor.setup_id is not null

Line 764: and bso.standard_operation_id = bst.operation_id

760: and wsor.organization_id = p_organization_id
761: and wsor.setup_id is not null
762: and bst.resource_id = wsor.resource_id
763: and bst.to_setup_id = wsor.setup_id
764: and bso.standard_operation_id = bst.operation_id
765: and bsor.standard_operation_id = bso.standard_operation_id
766: and dept_res.department_id = bso.department_id
767: and dept_res.resource_id = bsor.resource_id
768: AND dept_ins.department_id = dept_res.department_id

Line 765: and bsor.standard_operation_id = bso.standard_operation_id

761: and wsor.setup_id is not null
762: and bst.resource_id = wsor.resource_id
763: and bst.to_setup_id = wsor.setup_id
764: and bso.standard_operation_id = bst.operation_id
765: and bsor.standard_operation_id = bso.standard_operation_id
766: and dept_res.department_id = bso.department_id
767: and dept_res.resource_id = bsor.resource_id
768: AND dept_ins.department_id = dept_res.department_id
769: AND dept_ins.resource_id = dept_res.resource_id;