[Home] [Help]
434: lv_pri_sub_grp_num,
435: lv_pri_schd_seq_num
436: From WSM_LOT_JOB_DTL_INTERFACE jdi,
437: bom_operation_resources bor,
438: bom_operation_sequences bos
439: Where jdi.group_id = G_WIP_GROUP_ID
440: and jdi.parent_header_id = lv_header_id(n)
441: -- ds and jdi.load_type in (1,4)
442: and jdi.load_type in (1,4, RESOURCE_INSTANCES_OSFM, RESOURCE_INSTANCE_USAGE_OSFM)
480: lv_alt_sub_grp_num,
481: lv_alt_schd_seq_num
482: From WSM_LOT_JOB_DTL_INTERFACE jdi,
483: bom_operation_resources bor,
484: bom_operation_sequences bos,
485: bom_sub_operation_resources bsor
486: Where jdi.group_id = G_WIP_GROUP_ID
487: and jdi.parent_header_id = lv_header_id(n)
488: -- and jdi.load_type in (1,4)
552: , LV_UNSCHD_MAX_ASSIGNED_UNITS
553: , lv_unschd_parent_seq_num
554: -- , lv_unschd_schedule_seq_num
555: from bom_operation_resources bor,
556: bom_operation_sequences bos,
557: wsm_lot_job_dtl_interface jdi
558: Where bor.schedule_flag = 2
559: and bor.schedule_seq_num = jdi.schedule_seq_num
560: and nvl(jdi.replacement_group_num,0) = 0
583: , jdi.batch_id
584: , jdi.max_assigned_units --- sbala
585: , jdi.parent_resource_seq_num
586: from bom_sub_operation_resources bsor,
587: bom_operation_sequences bos,
588: wsm_lot_job_dtl_interface jdi
589: Where bsor.schedule_flag = 2
590: and bsor.schedule_seq_num = jdi.schedule_seq_num
591: and jdi.replacement_group_num = bsor.replacement_group_num
615: , jdi.batch_id
616: , jdi.max_assigned_units --- sbala
617: , jdi.parent_resource_seq_num --- sbala
618: from bom_operation_resources bor,
619: bom_operation_sequences bos,
620: wsm_lot_job_dtl_interface jdi
621: Where bor.schedule_flag = 2
622: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1
623: where jdi1.group_id = G_WIP_GROUP_ID
727: lv_unres_res_seq_num,
728: lv_unres_schd_seq_num,
729: lv_unres_res_id,
730: lv_unres_sub_grp_num
731: From BOM_OPERATION_SEQUENCES bos,
732: BOM_OPERATION_RESOURCES bor
733: Where bos.routing_sequence_id = lv_routing_seq_id(n)
734: and bos.operation_seq_num = lv_nwk_op_seq_num(k)
735: and bos.effectivity_date <= lv_start_date(n)
1690: Cursor C1 is
1691: Select a.header_id,min(bos.operation_seq_num) new_op_seq
1692: from WSM_LOT_JOB_INTERFACE a,
1693: WSM_LOT_JOB_DTL_INTERFACE b,
1694: bom_operation_Sequences bos,
1695: bom_operational_routings bor
1696: where a.group_id = b.group_id
1697: and a.group_id = G_WIP_GROUP_ID
1698: and a.header_id = b.parent_header_id
3179: Cursor C1 is
3180: Select a.header_id,min(bos.operation_seq_num) new_op_seq
3181: from wip_job_schedule_interface a,
3182: wip_job_dtls_interface b,
3183: bom_operation_Sequences bos,
3184: bom_operational_routings bor
3185: where a.group_id = b.group_id
3186: and a.header_id = b.parent_header_id --added for the bug#3538800
3187: and a.group_id = G_WIP_GROUP_ID
3550: lu_schedule_seq_num,
3551: lu_resource_id,
3552: lu_res_required
3553: FROM BOM_OPERATION_RESOURCES bor,
3554: BOM_OPERATION_SEQUENCES os
3555: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3556: AND bor.operation_sequence_id= os.operation_sequence_id
3557: AND os.effectivity_date <= lv_start_date(n)
3558: AND NVL(os.disable_date, lv_start_date(n)) >= lv_start_date(n)
3568:
3569: SELECT os.operation_seq_num,os.standard_operation_id
3570: BULK COLLECT
3571: INTO luno_op_seq_num,luno_std_op_Seq_id
3572: FROM BOM_OPERATION_SEQUENCES os
3573: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3574: AND os.effectivity_date <= lv_start_date(n)
3575: AND NVL(os.disable_date, lv_start_date(n)) >= lv_start_date(n)
3576: AND not exists(select jdi.operation_seq_num
3574: AND os.effectivity_date <= lv_start_date(n)
3575: AND NVL(os.disable_date, lv_start_date(n)) >= lv_start_date(n)
3576: AND not exists(select jdi.operation_seq_num
3577: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3578: BOM_OPERATION_SEQUEnCES seqs,
3579: wip_job_dtls_interface jdi,
3580: wip_job_schedule_interface jsi
3581: where rtng.assembly_item_id= jsi.primary_item_id
3582: AND rtng.organization_id= jsi.organization_id
3617: lun_basis_type,
3618: lun_usage,
3619: lun_res_required
3620: FROM BOM_OPERATION_RESOURCES bor,
3621: BOM_OPERATION_SEQUENCES os,
3622: BOM_RESOURCES br
3623: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3624: AND bor.operation_sequence_id= os.operation_sequence_id
3625: AND os.effectivity_date <= lv_start_date(n)
3628: AND br.resource_id = bor.resource_id
3629: and schedule_flag = 2
3630: AND not exists(select jdi.resource_id_new
3631: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3632: BOM_OPERATION_SEQUENCES seqs,
3633: wip_job_dtls_interface jdi,
3634: wip_job_schedule_interface jsi
3635: where rtng.assembly_item_id= jsi.primary_item_id
3636: AND rtng.organization_id= jsi.organization_id
3700: , lsud_parent_seq_num
3701: -- , lsud_schedule_seq_num
3702: FROM BOM_SUB_OPERATION_RESOURCES bor,
3703: bom_operation_resources bor1,
3704: BOM_OPERATION_SEQUENCES os,
3705: BOM_RESOURCES br,
3706: WIP_JOB_DTLS_INTERFACE JDI
3707: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3708: AND bor.operation_sequence_id= os.operation_sequence_id
4495:
4496: Select max(bor1.resource_seq_num)
4497: into v_max_resource_Seq
4498: FROM bom_operation_resources bor1,
4499: BOM_OPERATION_SEQUENCES os
4500: WHERE bor1.operation_sequence_id= os.operation_sequence_id
4501: and os.routing_sequence_id= i.common_routing_Sequence_id
4502: and os.operation_seq_num = i.operation_seq_num;
4503:
4948: Cursor C1 is
4949: Select a.header_id,min(bos.operation_seq_num) new_op_seq
4950: from eam_work_order_import a, -- wip_job_schedule_interface a,
4951: eam_material_import b, -- wip_job_dtls_interface b,
4952: bom_operation_Sequences bos,
4953: bom_operational_routings bor
4954: where a.group_id = b.group_id
4955: and a.group_id = G_WIP_GROUP_ID
4956: -- and a.primary_item_id = bor.assembly_item_id