DBA Data[Home] [Help]

APPS.WIP_WPS_COMMON dependencies on BOM_STANDARD_OPERATIONS

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