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 BOM_DEPARTMENT_RESOURCES

Line 505: from bom_department_resources dept_res,

501: cursor dept_res is
502: select dept_res.department_id,
503: dept_res.resource_id,
504: NVL(dept_res.available_24_hours_flag, 2)
505: from bom_department_resources dept_res,
506: bom_departments dept
507: where dept_res.department_id = dept.department_id
508: AND dept_res.share_from_dept_id is null
509: AND dept.organization_id = p_organization_id;

Line 515: from bom_department_resources dept_res,

511: cursor wip_res is
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

Line 529: from bom_department_resources dept_res,

525: union
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

Line 545: bom_department_resources bdr,

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
549: AND wor.wip_entity_id = p_wip_entity_id

Line 561: from bom_department_resources dept_res,

557: union
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

Line 651: bom_department_resources dept_res,

647: dept_ins.resource_id,
648: dept_ins.instance_id,
649: dept_ins.serial_number
650: from bom_dept_res_instances dept_ins,
651: bom_department_resources dept_res,
652: bom_departments dept
653: where dept_res.department_id = dept.department_id
654: AND dept_res.share_from_dept_id is null
655: AND dept_ins.resource_id = dept_res.resource_id

Line 666: from bom_department_resources dept_res,

662: NVL(dept_res.available_24_hours_flag, 2),
663: dept_res.resource_id,
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

Line 685: from bom_department_resources dept_res,

681: NVL(dept_res.available_24_hours_flag, 2),
682: dept_res.resource_id,
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

Line 711: from bom_department_resources dept_res,

707: NVL(dept_res.available_24_hours_flag, 2),
708: dept_res.resource_id,
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

Line 730: from bom_department_resources dept_res,

726: NVL(dept_res.available_24_hours_flag, 2),
727: dept_res.resource_id,
728: dept_ins.instance_id,
729: dept_ins.serial_number
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,

Line 753: from bom_department_resources dept_res,

749: NVL(dept_res.available_24_hours_flag, 2),
750: dept_res.resource_id,
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,

Line 850: from bom_department_resources dept_res,

846:
847: cursor dept_res is
848: select dept_res.department_id,
849: NVL(dept_res.available_24_hours_flag, 2)
850: from bom_department_resources dept_res,
851: bom_departments dept
852: where dept_res.department_id = dept.department_id
853: AND dept_res.resource_id = p_resource_id
854: AND dept_res.share_from_dept_id is null

Line 904: bom_department_resources dept_res,

900: cursor dept_ins is
901: select dept_ins.department_id,
902: NVL(dept_res.available_24_hours_flag, 2)
903: from bom_dept_res_instances dept_ins,
904: bom_department_resources dept_res,
905: bom_departments dept
906: where dept_ins.department_id = dept.department_id
907: AND dept_res.department_id = dept_ins.department_id
908: and dept_res.resource_id = p_resource_id