APPS.WIP_WPS_COMMON dependencies on BOM_DEPT_RES_INSTANCES

Line 650: from bom_dept_res_instances dept_ins,

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

Line 667: bom_dept_res_instances dept_ins,

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
671: AND wo.organization_id = p_organization_id

Line 700: from bom_dept_res_instances dept_ins

696: AND ins_changes.department_id = dept_res.department_id
697: AND ins_changes.resource_id = dept_res.resource_id
698: AND not exists
699: ( select 1
700: from bom_dept_res_instances dept_ins
701: where dept_ins.department_id = ins_changes.department_id
702: and dept_ins.resource_id = ins_changes.resource_id
703: and dept_ins.instance_id = ins_changes.instance_id
704: and nvl(dept_ins.serial_number, -1) = nvl(ins_changes.serial_number, -1))

Line 712: bom_dept_res_instances dept_ins,

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
716: AND wo.organization_id = p_organization_id

Line 731: bom_dept_res_instances dept_ins,

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,
735: bom_std_op_resources bsor

Line 754: bom_dept_res_instances dept_ins,

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,
758: bom_std_op_resources bsor

Line 903: from bom_dept_res_instances dept_ins,

899:
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