APPS.WIP_RESOURCE_VALIDATIONS dependencies on BOM_RESOURCES

Line 224: from wip_cost_txn_interface wcti, bom_resources br

220: and wt.operation_seq_num = p_operation_seq_num
221: and wt.resource_seq_num = p_resource_seq_num
222: and wt.resource_id = p_resource_id_old)
223: or exists (select 1
224: from wip_cost_txn_interface wcti, bom_resources br
225: where wcti.wip_entity_id = p_wip_entity_id
226: and wcti.organization_id = p_organization_id
227: and wcti.operation_seq_num = p_operation_seq_num
228: and wcti.resource_seq_num = p_resource_seq_num

Line 312: from wip_cost_txn_interface wcti, bom_resources br

308: and wt.operation_seq_num = p_operation_seq_num
309: and wt.resource_seq_num = p_resource_seq_num
310: and wt.resource_id = p_resource_id_old)
311: or exists (select 1
312: from wip_cost_txn_interface wcti, bom_resources br
313: where wcti.wip_entity_id = p_wip_entity_id
314: and wcti.organization_id = p_organization_id
315: and wcti.operation_seq_num = p_operation_seq_num
316: and wcti.resource_seq_num = p_resource_seq_num

Line 848: from bom_resources br

844: and wjdi.substitute_group_num is not null
845: and wjdi.replacement_group_num is not null
846: )
847: and ( not exists(select 1
848: from bom_resources br
849: where br.resource_id = p_resource_id_new
850: and ( br.disable_date > sysdate
851: or br.disable_date is null)
852: and br.organization_id = p_organization_id)

Line 863: -- resources to be added must exist in BOM_RESOURCES, not disabled

859: l_error_exists boolean := false;
860: begin
861:
862: -- Validate when adding resources
863: -- resources to be added must exist in BOM_RESOURCES, not disabled
864: for l_inv_row in c_invalid_rows loop
865: l_error_exists := true;
866: fnd_message.set_name('WIP', 'WIP_INVALID_RESOURCE');
867: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));

Line 899: from bom_resources br

895: and wjdi.substitute_group_num is not null
896: and wjdi.replacement_group_num is not null
897: )
898: and ( not exists(select 1
899: from bom_resources br
900: where br.resource_id = p_resource_id_new
901: and ( br.disable_date > sysdate
902: or br.disable_date is null)
903: and br.organization_id = p_organization_id)

Line 1050: from bom_resources br, mtl_units_of_measure_vl uom

1046: l_hour_uom_class := wip_op_resources_utilities.get_uom_class(l_hour_uom);
1047:
1048: select uom.uom_class
1049: into l_uom_class
1050: from bom_resources br, mtl_units_of_measure_vl uom
1051: where br.resource_id = p_resource_id_new
1052: and br.unit_of_measure = uom.uom_code;
1053:
1054: if l_hour_uom_class = l_uom_class then

Line 1062: from bom_resources

1058: end if;
1059:
1060: select autocharge_type
1061: into l_autocharge_type
1062: from bom_resources
1063: where resource_id = p_resource_id_new;
1064:
1065: if(l_autocharge_type is null) then
1066:

Line 1178: from bom_resources br

1174: and wjdi.substitution_type = wip_job_details.wip_add)
1175: or (wjdi.assigned_units is not null and wjdi.assigned_units <> 1
1176: and (wjdi.setup_id is not null or exists
1177: (select 1
1178: from bom_resources br
1179: where br.resource_id = nvl(wjdi.resource_id_new, wjdi.resource_id_old)
1180: and br.batchable = 1
1181: ))
1182: )

Line 1245: from bom_resources br

1241: and wjdi.substitution_type = wip_job_details.wip_add)
1242: or (wjdi.assigned_units is not null and wjdi.assigned_units <> 1
1243: and (wjdi.setup_id is not null or exists
1244: (select 1
1245: from bom_resources br
1246: where br.resource_id = nvl(wjdi.resource_id_new, wjdi.resource_id_old)
1247: ))
1248: )
1249: -- Bug 5172555