[Home] [Help]
906: lv_cur_op_res_seq_num,
907: lv_cur_op_sub_grp_num,
908: lv_cur_op_schd_seq_num
909: From WSM_LOT_JOB_DTL_INTERFACE jdi,
910: wip_operation_resources wor
911: Where jdi.group_id = G_WIP_GROUP_ID
912: and jdi.parent_header_id = lv_header_id(n)
913: -- and jdi.load_type in (1,4)
914: and jdi.load_type in (1,4, RESOURCE_INSTANCES_OSFM, RESOURCE_INSTANCE_USAGE_OSFM)
969: lv_unschd_rep_grp_num,
970: lv_unschd_subs_grp_num,
971: lv_unschd_rtng_op_seq_num,
972: lv_unschd_load_type
973: from wip_operation_resources wor,
974: wsm_lot_job_dtl_interface jdi
975: where wor.scheduled_flag = 2
976: and wor.schedule_seq_num = jdi.schedule_seq_num
977: and jdi.replacement_group_num = nvl(wor.replacement_group_num,0)
1010: nvl(wor.replacement_group_num,0),
1011: wor.substitute_group_num,
1012: jdi.routing_op_seq_num,
1013: jdi.load_type
1014: from wip_operation_resources wor,
1015: wsm_lot_job_dtl_interface jdi
1016: Where wor.scheduled_flag = 2
1017: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1
1018: where jdi1.group_id = G_WIP_GROUP_ID
1237: lv_unres_schd_seq_num,
1238: lv_unres_sub_grp_num,
1239: lv_unres_rep_grp_num,
1240: lv_unres_res_id
1241: From WIP_OPERATION_RESOURCES wor
1242: Where wor.operation_seq_num = lv_nwk_job_op_seq_num(k)
1243: and wor.wip_entity_id = lv_wip_entity_id(n);
1244:
1245: lv_unres_cnt := SQL%ROWCOUNT;
1380: lv_unres_schd_seq_num,
1381: lv_unres_sub_grp_num,
1382: lv_unres_rep_grp_num,
1383: lv_unres_res_id
1384: From WIP_OPERATION_RESOURCES wor
1385: Where wor.operation_seq_num = lv_nwk_job_op_seq_num(k)
1386: and wor.wip_entity_id = lv_wip_entity_id(n);
1387:
1388: lv_unres_cnt := SQL%ROWCOUNT;
3505: load_type = 1
3506: substitution_type = 3
3507: opearation_seq_num, resource_seq_num, resource_id_old, resource_id_new,
3508: and substitute_group_num should be set to the current(or primary) resource in
3509: wip_operation_resources
3510: replacement_group_num = valid value in wip_sub_operation_resources.Finally the
3511: alternate resource record will be deleted from wip_job_dtls_interface*/
3512:
3513: FOR j IN 1..lsud_res_req_count
4002: elsud_res_seq,
4003: elsud_jdi_rowid,
4004: elsud_sub_grp,
4005: elsud_rep_grp
4006: FROM WIP_OPERATION_RESOURCES wor,
4007: WIP_JOB_DTLS_INTERFACE JDI
4008: WHERE wor.operation_seq_num = jdi.operation_seq_num
4009: and nvl(wor.schedule_seq_num,wor.resource_seq_num) = jdi.schedule_seq_num
4010: -- and wor.resource_seq_num = jdi.resource_seq_num
4074: lv_res_alt_completion_date,
4075: lv_res_alt_usage_rate,
4076: lv_res_alt_basis_type
4077: from wip_job_dtls_interface jdi,
4078: wip_operation_resources wor,
4079: wip_sub_operation_resources wsor
4080: where not exists(select 1 from wip_operation_resources wor1
4081: where wor1.operation_seq_num = jdi.operation_seq_num
4082: and nvl(wor1.schedule_seq_num,wor1.resource_seq_num) = jdi.schedule_seq_num
4076: lv_res_alt_basis_type
4077: from wip_job_dtls_interface jdi,
4078: wip_operation_resources wor,
4079: wip_sub_operation_resources wsor
4080: where not exists(select 1 from wip_operation_resources wor1
4081: where wor1.operation_seq_num = jdi.operation_seq_num
4082: and nvl(wor1.schedule_seq_num,wor1.resource_seq_num) = jdi.schedule_seq_num
4083: -- and wor1.resource_seq_num = jdi.resource_seq_num
4084: and nvl(wor1.replacement_group_num,0) = nvl(jdi.replacement_group_num,0)
4781:
4782: cursor cres_upd is
4783: select wor.schedule_seq_num
4784: , wor.substitute_group_num
4785: FROM WIP_OPERATION_RESOURCES wor
4786: , EAM_RESOURCE_IMPORT eir
4787: WHERE wor.operation_seq_num = eir.operation_seq_num
4788: and wor.resource_seq_num = eir.resource_seq_num
4789: and nvl(wor.replacement_group_num,0) = nvl(eir.replacement_group_num,0)