[Home] [Help]
3764: l_stmt_num := 130;
3765:
3766: -- This sql checks if there are any resources that the user intends to issue
3767: -- manually. This pl/sql block looks for resources in WOR that are not
3768: -- present in bom_operation_resources. It does not matter whether or not the user
3769: -- has already issued these resources to job yet, what matters is recording the
3770: -- user's intention to issue these resources manually.
3771:
3772: BEGIN
3778: and wor.operation_seq_num = p_op_seq_num
3779: and wor.repetitive_schedule_id is NULL
3780: and wor.applied_resource_units <> 0
3781: and NOT EXISTS (select 1
3782: From bom_operation_resources bor, wip_operations wo
3783: Where bor.operation_sequence_id = wo.operation_sequence_id
3784: and bor.resource_seq_num = wor.resource_seq_num
3785: and wo.wip_entity_id = wor.wip_entity_id
3786: and wo.operation_seq_num = wor.operation_seq_num);
3923:
3924: SELECT count(*)
3925: INTO x_rowcount
3926: FROM bom_operational_routings bor,
3927: bom_operation_resources bres,
3928: bom_operation_sequences bos
3929: WHERE bor.routing_sequence_id = p_sequence_id
3930: AND bor.common_routing_sequence_id = bos.routing_sequence_id
3931: AND bos.operation_sequence_id = bres.operation_sequence_id
3946: elsif p_sequence_id_type = 'O' then
3947:
3948: SELECT count(*)
3949: INTO x_rowcount
3950: FROM bom_operation_resources bres,
3951: bom_operation_sequences bos
3952: WHERE bos.operation_sequence_id = p_sequence_id
3953: AND bos.operation_sequence_id = bres.operation_sequence_id
3954: /*BD HH24MISS */ /*