[Home] [Help]
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
521: AND wor.organization_id = wo.organization_id
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
550: AND wor.setup_id is not null
551: AND bst.resource_id = wor.resource_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
673: AND wor.organization_id = wo.organization_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
692: AND wor.organization_id = wo.organization_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
736: where wor.wip_entity_id = p_wip_entity_id