[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
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
2901: and a.primary_item_id = bor.assembly_item_id
3009: /* dsr jsi.primary_item_id and jsi.organization_id can be null */
3010: /* dsr: added outer join in the following cursor*/
3011: cursor cres_upd is select jdi.rowid,jdi.operation_seq_num,
3012: jdi.parent_header_id,rtng.common_routing_Sequence_id
3013: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3014: wip_job_dtls_interface jdi,
3015: wip_job_schedule_interface jsi
3016: where rtng.assembly_item_id (+) = jsi.primary_item_id -- dsr
3017: and jsi.group_id = G_WIP_GROUP_ID
3172: lv_end_date,
3173: lv_routing_seq_id,
3174: lv_job_schedule_type,
3175: lv_wip_entity_id
3176: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3177: wip_job_schedule_interface jsi
3178: WHERE jsi.group_id = G_WIP_GROUP_ID
3179: AND jsi.load_type in(1,3) /* create standard job */
3180: AND rtng.assembly_item_id(+)= jsi.primary_item_id
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
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
3339: AND NVL(os.disable_date, nvl(br.disable_date, lv_start_date(n))) >= lv_start_date(n) -- bug# 4290120
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
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
4655: and a.REBUILD_ITEM_ID = bor.assembly_item_id