DBA Data[Home] [Help]

APPS.WIP_WPS_COMMON dependencies on BOM_SETUP_TRANSITIONS

Line 546: bom_setup_transitions bst,

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
550: AND wor.setup_id is not null

Line 563: bom_setup_transitions bst,

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
566: where wsor.wip_entity_id = p_wip_entity_id
567: and wsor.organization_id = p_organization_id

Line 733: bom_setup_transitions bst,

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
737: and wor.organization_id = p_organization_id

Line 756: bom_setup_transitions bst,

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
759: where wsor.wip_entity_id = p_wip_entity_id
760: and wsor.organization_id = p_organization_id