DBA Data[Home] [Help]

APPS.WPS_COMMON dependencies on BOM_STD_OP_RESOURCES

Line 543: from bom_std_op_resources bsor,

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

Line 565: bom_std_op_resources bsor

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
569: and bst.resource_id = wsor.resource_id

Line 735: bom_std_op_resources bsor

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
739: and bst.resource_id = wor.resource_id

Line 758: bom_std_op_resources bsor

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
762: and bst.resource_id = wsor.resource_id