[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
2892: Cursor C1 is
2893: Select a.header_id,min(bos.operation_seq_num) new_op_seq
2894: from wip_job_schedule_interface a,
2895: wip_job_dtls_interface b,
2896: bom_operation_Sequences bos,
2897: bom_operational_routings bor
2898: where a.group_id = b.group_id
2899: and a.header_id = b.parent_header_id --added for the bug#3538800
2900: and a.group_id = G_WIP_GROUP_ID
3263: lu_schedule_seq_num,
3264: lu_resource_id,
3265: lu_res_required
3266: FROM BOM_OPERATION_RESOURCES bor,
3267: BOM_OPERATION_SEQUENCES os
3268: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3269: AND bor.operation_sequence_id= os.operation_sequence_id
3270: AND os.effectivity_date <= lv_start_date(n)
3271: AND NVL(os.disable_date, lv_start_date(n)) >= lv_start_date(n)
3281:
3282: SELECT os.operation_seq_num,os.standard_operation_id
3283: BULK COLLECT
3284: INTO luno_op_seq_num,luno_std_op_Seq_id
3285: FROM BOM_OPERATION_SEQUENCES os
3286: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3287: AND os.effectivity_date <= lv_start_date(n)
3288: AND NVL(os.disable_date, lv_start_date(n)) >= lv_start_date(n)
3289: AND not exists(select jdi.operation_seq_num
3287: AND os.effectivity_date <= lv_start_date(n)
3288: AND NVL(os.disable_date, lv_start_date(n)) >= lv_start_date(n)
3289: AND not exists(select jdi.operation_seq_num
3290: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3291: BOM_OPERATION_SEQUEnCES seqs,
3292: wip_job_dtls_interface jdi,
3293: wip_job_schedule_interface jsi
3294: where rtng.assembly_item_id= jsi.primary_item_id
3295: AND rtng.organization_id= jsi.organization_id
3329: lun_basis_type,
3330: lun_usage,
3331: lun_res_required
3332: FROM BOM_OPERATION_RESOURCES bor,
3333: BOM_OPERATION_SEQUENCES os,
3334: BOM_RESOURCES br
3335: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3336: AND bor.operation_sequence_id= os.operation_sequence_id
3337: AND os.effectivity_date <= lv_start_date(n)
3340: AND br.resource_id = bor.resource_id
3341: and schedule_flag = 2
3342: AND not exists(select jdi.resource_id_new
3343: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3344: BOM_OPERATION_SEQUENCES seqs,
3345: wip_job_dtls_interface jdi,
3346: wip_job_schedule_interface jsi
3347: where rtng.assembly_item_id= jsi.primary_item_id
3348: AND rtng.organization_id= jsi.organization_id
3411: , lsud_parent_seq_num
3412: -- , lsud_schedule_seq_num
3413: FROM BOM_SUB_OPERATION_RESOURCES bor,
3414: bom_operation_resources bor1,
3415: BOM_OPERATION_SEQUENCES os,
3416: BOM_RESOURCES br,
3417: WIP_JOB_DTLS_INTERFACE JDI
3418: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3419: AND bor.operation_sequence_id= os.operation_sequence_id
4193:
4194: Select max(bor1.resource_seq_num)
4195: into v_max_resource_Seq
4196: FROM bom_operation_resources bor1,
4197: BOM_OPERATION_SEQUENCES os
4198: WHERE bor1.operation_sequence_id= os.operation_sequence_id
4199: and os.routing_sequence_id= i.common_routing_Sequence_id
4200: and os.operation_seq_num = i.operation_seq_num;
4201:
4646: Cursor C1 is
4647: Select a.header_id,min(bos.operation_seq_num) new_op_seq
4648: from eam_work_order_import a, -- wip_job_schedule_interface a,
4649: eam_material_import b, -- wip_job_dtls_interface b,
4650: bom_operation_Sequences bos,
4651: bom_operational_routings bor
4652: where a.group_id = b.group_id
4653: and a.group_id = G_WIP_GROUP_ID
4654: -- and a.primary_item_id = bor.assembly_item_id