[Home] [Help]
268: lv_routing_seq_id,
269: lv_job_schedule_type,
270: lv_start_date,
271: lv_wip_entity_id
272: FROM BOM_OPERATIONAL_ROUTINGS rtng,
273: WSM_LOT_JOB_INTERFACE jsi
274: WHERE jsi.group_id = G_WIP_GROUP_ID
275: AND jsi.load_type in (5,6) /* standard job */
276: AND rtng.assembly_item_id(+)= jsi.primary_item_id
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
1699: and a.load_type = 5
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
3188: and a.primary_item_id = bor.assembly_item_id
3296: /* dsr jsi.primary_item_id and jsi.organization_id can be null */
3297: /* dsr: added outer join in the following cursor*/
3298: cursor cres_upd is select jdi.rowid,jdi.operation_seq_num,
3299: jdi.parent_header_id,rtng.common_routing_Sequence_id
3300: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3301: wip_job_dtls_interface jdi,
3302: wip_job_schedule_interface jsi
3303: where rtng.assembly_item_id (+) = jsi.primary_item_id -- dsr
3304: and jsi.group_id = G_WIP_GROUP_ID
3459: lv_end_date,
3460: lv_routing_seq_id,
3461: lv_job_schedule_type,
3462: lv_wip_entity_id
3463: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3464: wip_job_schedule_interface jsi
3465: WHERE jsi.group_id = G_WIP_GROUP_ID
3466: AND jsi.load_type in(1,3) /* create standard job */
3467: AND rtng.assembly_item_id(+)= jsi.primary_item_id
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
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
3627: AND NVL(os.disable_date, nvl(br.disable_date, lv_start_date(n))) >= lv_start_date(n) -- bug# 4290120
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
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
4957: and a.REBUILD_ITEM_ID = bor.assembly_item_id