eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MRP_AP_REL_PLAN_PUB dependencies on WIP_JOB_DTLS_INTERFACE

Line 63: FROM WIP_JOB_DTLS_INTERFACE jdi

59: UPDATE wip_job_schedule_interface i
60: SET i.scheduling_method=1
61: WHERE
62: EXISTS(SELECT 1
63: FROM WIP_JOB_DTLS_INTERFACE jdi
64: WHERE jdi.group_id=G_OPM_WIP_GROUP_ID
65: AND jdi.parent_header_id = i.header_id
66: AND ROWNUM=1)
67: AND i.group_id = G_OPM_WIP_GROUP_ID

Line 2055: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink

2051: ||' Maximum_Assigned_Units,'
2052: ||' USAGE_RATE_OR_AMOUNT,'
2053: ||' SCHEDULED_FLAG ,'
2054: ||' PARENT_SEQ_NUM '
2055: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink
2056: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2057: ||' AND GROUP_ID = :G_WIP_GROUP_ID'
2058: ||' AND nvl(CFM_ROUTING_FLAG,0) = 3';
2059:

Line 2245: 'INSERT INTO WIP_JOB_DTLS_INTERFACE'

2241:
2242: EXECUTE IMMEDIATE lv_sqlstmt USING lv_instance_id,G_WIP_GROUP_ID;
2243:
2244: lv_sqlstmt:=
2245: 'INSERT INTO WIP_JOB_DTLS_INTERFACE'
2246: ||' ( INTERFACE_ID,'
2247: ||' GROUP_ID,'
2248: ||' OPERATION_SEQ_NUM,'
2249: ||' RESOURCE_SEQ_NUM,'

Line 2394: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink

2390: ||' , maximum_assigned_units '
2391: ||' , parent_seq_num '
2392: ||' , firm_flag '
2393: ||' , schedule_seq_num '
2394: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink
2395: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2396: ||' AND nvl(CFM_ROUTING_FLAG,0) <> 3 '
2397: ||' AND GROUP_ID = :G_WIP_GROUP_ID'
2398: ||' AND nvl(operation_seq_num,-1) <> -1'

Line 2895: wip_job_dtls_interface b,

2891:
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

Line 2923: wip_job_dtls_interface b

2919: b.INVENTORY_ITEM_ID_OLD,
2920: b.ORGANIZATION_ID,
2921: b.OPERATION_SEQ_NUM
2922: from wip_job_schedule_interface a,
2923: wip_job_dtls_interface b
2924: where a.source_code = 'MSC'
2925: and a.group_id = G_WIP_GROUP_ID
2926: and a.group_id = b.group_id
2927: and a.header_id = b.parent_header_id

Line 2941: wip_job_dtls_interface b

2937:
2938: Cursor C3 is
2939: select b.rowid
2940: from wip_job_schedule_interface a,
2941: wip_job_dtls_interface b
2942: where a.source_code = 'MSC'
2943: and a.group_id = G_WIP_GROUP_ID
2944: and a.group_id = b.group_id
2945: and a.header_id = b.parent_header_id

Line 2951: from wip_job_dtls_interface c

2947: and b.substitution_type = 3
2948: and b.process_phase = 2
2949: and b.process_status = 1
2950: and b.rowid not in (select min(c.rowid)
2951: from wip_job_dtls_interface c
2952: where b.group_id = c.group_id
2953: and b.parent_header_id = c.parent_header_id
2954: and b.ORGANIZATION_ID = c.ORGANIZATION_ID
2955: and b.INVENTORY_ITEM_ID_OLD = c.INVENTORY_ITEM_ID_OLD

Line 2967: update wip_job_dtls_interface

2963:
2964: For I in C1
2965:
2966: loop
2967: update wip_job_dtls_interface
2968: set operation_Seq_num = I.new_op_seq
2969: where parent_header_id = I.header_id
2970: and operation_seq_num = 1
2971: and load_type = 2

Line 2979: update wip_job_dtls_interface

2975:
2976: For J in C2
2977:
2978: loop
2979: update wip_job_dtls_interface
2980: set QUANTITY_PER_ASSEMBLY = J.qty_per_assy,
2981: REQUIRED_QUANTITY = J.reqd_qty
2982: where group_id = J.group_id
2983: and parent_header_id = J.parent_header_id

Line 2998: delete wip_job_dtls_interface

2994: For K in C3
2995:
2996: loop
2997:
2998: delete wip_job_dtls_interface
2999: where rowid = K.rowid;
3000:
3001: End loop;
3002:

Line 3014: wip_job_dtls_interface jdi,

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
3018: AND rtng.organization_id (+) = jsi.organization_id -- dsr

Line 3216: FROM WIP_JOB_DTLS_INTERFACE jdi

3212: lv_resource_id_old,
3213: lv_ld_type,
3214: lv_scheduled_flag,
3215: lv_parent_id
3216: FROM WIP_JOB_DTLS_INTERFACE jdi
3217: WHERE jdi.group_id= G_WIP_GROUP_ID
3218: AND jdi.parent_header_id= lv_header_id(n)
3219: -- dsr AND jdi.load_type=LT_RESOURCE
3220: AND jdi.load_type IN (LT_RESOURCE, LT_RESOURCE_USAGE

Line 3292: wip_job_dtls_interface jdi,

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
3296: and nvl(rtng.common_routing_sequence_id,rtng.routing_sequence_id) = os.routing_Sequence_id

Line 3345: wip_job_dtls_interface jdi,

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
3349: AND nvl(rtng.common_routing_sequence_id,rtng.routing_sequence_id) = seqs.routing_sequence_id

Line 3417: WIP_JOB_DTLS_INTERFACE JDI

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
3420: AND os.effectivity_date <= lv_start_date(n)
3421: -- AND NVL(os.disable_date, lv_start_date(n)) >= lv_start_date(n)

Line 3485: UPDATE WIP_JOB_DTLS_INTERFACE

3481: Loop
3482:
3483:
3484:
3485: UPDATE WIP_JOB_DTLS_INTERFACE
3486: SET resource_seq_num= lv_res_seq(j),
3487: resource_id_old = lv_resource_id(j),
3488: schedule_seq_num = lv_sim_res_seq(j),
3489: scheduled_flag = lv_scheduled_flag(j)

Line 3503: substitution, the record in wip_job_dtls_interface should have the

3499: loop through all Resource records where we are implementing alternate and delete the primaries
3500: for that alternate -- this was old logic*/
3501: /* Now if we communicating to WIP that we are passing alternate resource to WIP,
3502: for a resource
3503: substitution, the record in wip_job_dtls_interface should have the
3504: following columns filled in:
3505: load_type = 1
3506: substitution_type = 3
3507: opearation_seq_num, resource_seq_num, resource_id_old, resource_id_new,

Line 3511: alternate resource record will be deleted from wip_job_dtls_interface*/

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
3514:
3515: Loop

Line 3518: INSERT INTO WIP_JOB_DTLS_INTERFACE

3514:
3515: Loop
3516: Begin
3517:
3518: INSERT INTO WIP_JOB_DTLS_INTERFACE
3519: ( last_update_date,
3520: last_updated_by,
3521: last_update_login,
3522: creation_date,

Line 3585: delete from WIP_JOB_DTLS_INTERFACE

3581: FROM DUAL;
3582:
3583:
3584: /*Delete the Alternate that we provided */
3585: delete from WIP_JOB_DTLS_INTERFACE
3586: WHERE ROWID= lsud_jdi_rowid(j);
3587: Exception
3588: when others then raise;
3589: End;

Line 3607: from wip_job_dtls_interface

3603:
3604: BEGIN
3605: select nvl(max(operation_seq_num),-1)
3606: into v_previous_op
3607: from wip_job_dtls_interface
3608: where parent_header_id = lv_header_id(n)
3609: and group_id = G_WIP_GROUP_ID
3610: and load_type = 3
3611: and substitution_type <> 1

Line 3616: from wip_job_dtls_interface

3612: and operation_seq_num < luno_op_seq_num(m);
3613:
3614: select nvl(min(operation_seq_num),-1)
3615: into v_next_op
3616: from wip_job_dtls_interface
3617: where parent_header_id = lv_header_id(n)
3618: and group_id = G_WIP_GROUP_ID
3619: and substitution_type <> 1
3620: and load_type = 3

Line 3631: from wip_job_dtls_interface

3627: if (v_previous_op = -1 and v_next_op <> -1) then
3628:
3629: Select first_unit_start_date
3630: into v_last_end
3631: from wip_job_dtls_interface
3632: where parent_header_id = lv_header_id(n)
3633: and group_id = G_WIP_GROUP_ID
3634: and load_type = 3
3635: and operation_seq_num = v_next_op;

Line 3645: from wip_job_dtls_interface

3641: elsif (v_next_op = -1 and v_previous_op <> -1) then
3642:
3643: Select last_unit_completion_date
3644: into v_frst_start
3645: from wip_job_dtls_interface
3646: where parent_header_id = lv_header_id(n)
3647: and group_id = G_WIP_GROUP_ID
3648: and load_type = 3
3649: and operation_seq_num = v_previous_op;

Line 3659: from wip_job_dtls_interface

3655: else
3656:
3657: Select first_unit_start_date
3658: into v_last_end
3659: from wip_job_dtls_interface
3660: where parent_header_id = lv_header_id(n)
3661: and group_id = G_WIP_GROUP_ID
3662: and load_type = 3
3663: and operation_seq_num = v_next_op;

Line 3669: from wip_job_dtls_interface

3665: v_last_start := v_last_end;
3666:
3667: Select last_unit_completion_date
3668: into v_frst_start
3669: from wip_job_dtls_interface
3670: where parent_header_id = lv_header_id(n)
3671: and group_id = G_WIP_GROUP_ID
3672: and load_type = 3
3673: and operation_seq_num = v_previous_op;

Line 3683: INSERT INTO WIP_JOB_DTLS_INTERFACE

3679: EXCEPTION WHEN OTHERS THEN
3680: RAISE;
3681: END;
3682:
3683: INSERT INTO WIP_JOB_DTLS_INTERFACE
3684: ( last_update_date,
3685: last_updated_by,
3686: last_update_login,
3687: creation_date,

Line 3734: from wip_job_dtls_interface

3730:
3731: BEGIN
3732: select max(operation_seq_num)
3733: into v_previous_op
3734: from wip_job_dtls_interface
3735: where parent_header_id = lv_header_id(n)
3736: and group_id = G_WIP_GROUP_ID
3737: and load_type = 3
3738: and substitution_type <> 1

Line 3743: from wip_job_dtls_interface

3739: and operation_seq_num <= lun_op_seq_num(j);
3740:
3741: select min(operation_seq_num)
3742: into v_next_op
3743: from wip_job_dtls_interface
3744: where parent_header_id = lv_header_id(n)
3745: and group_id = G_WIP_GROUP_ID
3746: and substitution_type <> 1
3747: and load_type = 3

Line 3752: from wip_job_dtls_interface s

3748: and operation_seq_num >= lun_op_seq_num(j);
3749:
3750: select nvl(max(resource_seq_num),-1)
3751: into v_previous_res
3752: from wip_job_dtls_interface s
3753: where s.parent_header_id = lv_header_id(n)
3754: and s.group_id = G_WIP_GROUP_ID
3755: and s.load_type = 1
3756: and s.substitution_type <> 1

Line 3763: from wip_job_dtls_interface s

3759:
3760:
3761: select nvl(max(schedule_seq_num),-1)
3762: into v_previous_res1
3763: from wip_job_dtls_interface s
3764: where s.parent_header_id = lv_header_id(n)
3765: and s.group_id = G_WIP_GROUP_ID
3766: and s.load_type = 1
3767: and s.substitution_type <> 1

Line 3774: from wip_job_dtls_interface s

3770:
3771: if (v_previous_res1 > v_previous_res) then
3772: select nvl(max(resource_seq_num),-1)
3773: into v_previous_res
3774: from wip_job_dtls_interface s
3775: where s.parent_header_id = lv_header_id(n)
3776: and s.group_id = G_WIP_GROUP_ID
3777: and s.load_type = 1
3778: and s.substitution_type <> 1

Line 3787: from wip_job_dtls_interface s

3783: end if ;
3784:
3785: select nvl(min(resource_seq_num),-1)
3786: into v_next_res
3787: from wip_job_dtls_interface s
3788: where s.parent_header_id = lv_header_id(n)
3789: and s.group_id = G_WIP_GROUP_ID
3790: and s.substitution_type <> 1
3791: and s.load_type = 1

Line 3797: from wip_job_dtls_interface s

3793: and nvl(s.schedule_seq_num,s.resource_seq_num) > lun_res_seq(j);
3794:
3795: select nvl(min(schedule_seq_num),-1)
3796: into v_next_res1
3797: from wip_job_dtls_interface s
3798: where s.parent_header_id = lv_header_id(n)
3799: and s.group_id = G_WIP_GROUP_ID
3800: and s.substitution_type <> 1
3801: and s.load_type = 1

Line 3808: from wip_job_dtls_interface s

3804:
3805: if (v_next_res1 < v_next_res) then
3806: select nvl(resource_seq_num,-1)
3807: into v_next_res
3808: from wip_job_dtls_interface s
3809: where s.parent_header_id = lv_header_id(n)
3810: and s.group_id = G_WIP_GROUP_ID
3811: and s.substitution_type <> 1
3812: and s.load_type = 1

Line 3829: from wip_job_dtls_interface

3825:
3826:
3827: Select first_unit_start_date
3828: into v_last_end
3829: from wip_job_dtls_interface
3830: where parent_header_id = lv_header_id(n)
3831: and group_id = G_WIP_GROUP_ID
3832: and load_type = 3
3833: and operation_seq_num = v_next_op;

Line 3839: from wip_job_dtls_interface

3835: v_last_start := v_last_end;
3836:
3837: Select last_unit_completion_date
3838: into v_frst_start
3839: from wip_job_dtls_interface
3840: where parent_header_id = lv_header_id(n)
3841: and group_id = G_WIP_GROUP_ID
3842: and load_type = 3
3843: and operation_seq_num = v_previous_op;

Line 3855: from wip_job_dtls_interface

3851: then
3852:
3853: Select start_date
3854: into v_last_end
3855: from wip_job_dtls_interface
3856: where parent_header_id = lv_header_id(n)
3857: and group_id = G_WIP_GROUP_ID
3858: and load_type = 1
3859: and operation_seq_num = v_next_op

Line 3867: from wip_job_dtls_interface

3863: v_last_start := v_last_end;
3864:
3865: Select start_date
3866: into v_frst_start
3867: from wip_job_dtls_interface
3868: where parent_header_id = lv_header_id(n)
3869: and group_id = G_WIP_GROUP_ID
3870: and load_type = 1
3871: and operation_seq_num = v_previous_op

Line 3883: from wip_job_dtls_interface

3879: then
3880:
3881: Select completion_date
3882: into v_last_end
3883: from wip_job_dtls_interface
3884: where parent_header_id = lv_header_id(n)
3885: and group_id = G_WIP_GROUP_ID
3886: and load_type = 1
3887: and operation_seq_num = v_next_op

Line 3895: from wip_job_dtls_interface

3891: v_last_start := v_last_end;
3892:
3893: Select completion_date
3894: into v_frst_start
3895: from wip_job_dtls_interface
3896: where parent_header_id = lv_header_id(n)
3897: and group_id = G_WIP_GROUP_ID
3898: and load_type = 1
3899: and operation_seq_num = v_previous_op

Line 3909: from wip_job_dtls_interface

3905: else
3906:
3907: Select start_date
3908: into v_last_end
3909: from wip_job_dtls_interface
3910: where parent_header_id = lv_header_id(n)
3911: and group_id = G_WIP_GROUP_ID
3912: and load_type = 1
3913: and operation_seq_num = v_next_op

Line 3921: from wip_job_dtls_interface

3917: v_last_start := v_last_end;
3918:
3919: Select completion_date
3920: into v_frst_start
3921: from wip_job_dtls_interface
3922: where parent_header_id = lv_header_id(n)
3923: and group_id = G_WIP_GROUP_ID
3924: and load_type = 1
3925: and operation_seq_num = v_previous_op

Line 3939: INSERT INTO WIP_JOB_DTLS_INTERFACE

3935: END;
3936:
3937: /*insert record for the resource with schedule = no with start and end time
3938: as that of the opertaion*/
3939: INSERT INTO WIP_JOB_DTLS_INTERFACE
3940: ( last_update_date,
3941: last_updated_by,
3942: last_update_login,
3943: creation_date,

Line 4007: WIP_JOB_DTLS_INTERFACE JDI

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
4011: and nvl(wor.replacement_group_num,0) = nvl(jdi.replacement_group_num,0)

Line 4029: UPDATE WIP_JOB_DTLS_INTERFACE

4025: FOR x IN 1..lv_elsud_cnt
4026:
4027: Loop
4028:
4029: UPDATE WIP_JOB_DTLS_INTERFACE
4030: SET
4031: -- resource_seq_num= elsud_res_seq(x),
4032: schedule_seq_num = elsud_sim_res_seq(x),
4033: substitute_group_num = elsud_sub_grp(x)

Line 4077: from wip_job_dtls_interface jdi,

4073: lv_res_alt_start_date,
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

Line 4110: INSERT INTO WIP_JOB_DTLS_INTERFACE

4106:
4107: Loop
4108: Begin
4109:
4110: INSERT INTO WIP_JOB_DTLS_INTERFACE
4111: ( last_update_date,
4112: last_updated_by,
4113: last_update_login,
4114: creation_date,

Line 4155: delete from WIP_JOB_DTLS_INTERFACE

4151: 1,
4152: 1 --lv_scheduled_flag(j)
4153: FROM DUAL;
4154:
4155: delete from WIP_JOB_DTLS_INTERFACE
4156: WHERE ROWID= lv_res_alt_rowid(j);
4157:
4158: Exception
4159: when others then raise;

Line 4173: UPDATE WIP_JOB_DTLS_INTERFACE set REPLACEMENT_GROUP_NUM = null

4169:
4170: end if;
4171:
4172: --Bug 3333343
4173: UPDATE WIP_JOB_DTLS_INTERFACE set REPLACEMENT_GROUP_NUM = null
4174: where REPLACEMENT_GROUP_NUM = 0
4175: AND GROUP_ID= G_WIP_GROUP_ID
4176: AND PARENT_HEADER_ID= lv_header_id(n)
4177: AND LOAD_TYPE = LT_RESOURCE;

Line 4209: update wip_job_dtls_interface

4205:
4206: v_max_resource_seq := v_max_resource_Seq + 1;
4207:
4208:
4209: update wip_job_dtls_interface
4210: set resource_Seq_num = v_max_resource_Seq
4211: where rowid = i.rowid;
4212: End loop;
4213: */

Line 4369: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink

4365: ||' operation_seq_id,'
4366: ||' department_id,'
4367: ||' first_unit_start_date,'
4368: ||' last_unit_completion_date '
4369: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink
4370: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
4371: ||' AND nvl(CFM_ROUTING_FLAG,0) <> 3 '
4372: ||' AND GROUP_ID = :G_WIP_GROUP_ID'
4373: ||' AND nvl(operation_seq_num,-1) <> -1'

Line 4430: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink

4426: ||' scheduled_flag, '
4427: ||' basis_type, '
4428: ||' department_id, '
4429: ||' FIRM_FLAG '
4430: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink
4431: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
4432: ||' AND nvl(CFM_ROUTING_FLAG,0) <> 3 '
4433: ||' AND GROUP_ID = :G_WIP_GROUP_ID'
4434: ||' AND nvl(operation_seq_num,-1) <> -1'

Line 4479: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink

4475: ||' operation_seq_num,'
4476: ||' inventory_item_id_old,'
4477: ||' date_required,'
4478: ||' Required_quantity '
4479: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink
4480: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
4481: ||' AND nvl(CFM_ROUTING_FLAG,0) <> 3 '
4482: ||' AND GROUP_ID = :G_WIP_GROUP_ID'
4483: ||' AND nvl(operation_seq_num,-1) <> -1'

Line 4532: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink

4528: ||' RESOURCE_INSTANCE_ID,'
4529: ||' start_date,'
4530: ||' completion_date, '
4531: ||' SERIAL_NUMBER '
4532: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink
4533: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
4534: ||' AND nvl(CFM_ROUTING_FLAG,0) <> 3 '
4535: ||' AND GROUP_ID = :G_WIP_GROUP_ID'
4536: ||' AND nvl(operation_seq_num,-1) <> -1'

Line 4585: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink

4581: ||' RESOURCE_INSTANCE_ID,'
4582: ||' start_date,'
4583: ||' completion_date, '
4584: ||' SERIAL_NUMBER '
4585: ||' FROM MSC_WIP_JOB_DTLS_INTERFACE'||lv_dblink
4586: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
4587: ||' AND nvl(CFM_ROUTING_FLAG,0) <> 3 '
4588: ||' AND GROUP_ID = :G_WIP_GROUP_ID'
4589: ||' AND nvl(operation_seq_num,-1) <> -1'

Line 4649: eam_material_import b, -- wip_job_dtls_interface b,

4645:
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

Line 4677: eam_material_import b -- wip_job_dtls_interface b

4673: b.INVENTORY_ITEM_ID, -- b.INVENTORY_ITEM_ID_OLD,
4674: b.ORGANIZATION_ID,
4675: b.OPERATION_SEQ_NUM
4676: from eam_work_order_import a, -- wip_job_schedule_interface a,
4677: eam_material_import b -- wip_job_dtls_interface b
4678: where a.source_code = 'MSC'
4679: and a.group_id = G_WIP_GROUP_ID
4680: and a.group_id = b.group_id
4681: -- and a.header_id = b.parent_header_id

Line 4696: eam_material_import b -- wip_job_dtls_interface b

4692:
4693: Cursor C3 is
4694: select b.rowid
4695: from eam_work_order_import a, -- wip_job_schedule_interface a,
4696: eam_material_import b -- wip_job_dtls_interface b
4697: where a.source_code = 'MSC'
4698: and a.group_id = G_WIP_GROUP_ID
4699: and a.group_id = b.group_id
4700: -- and a.header_id = b.parent_header_id

Line 4707: from eam_material_import c -- wip_job_dtls_interface c

4703: -- and b.substitution_type = 3
4704: -- and b.process_phase = 2
4705: -- and b.process_status = 1
4706: and b.rowid not in (select min(c.rowid)
4707: from eam_material_import c -- wip_job_dtls_interface c
4708: where b.group_id = c.group_id
4709: -- and b.parent_header_id = c.parent_header_id
4710: and b.wip_entity_id = c.wip_entity_id
4711: and b.ORGANIZATION_ID = c.ORGANIZATION_ID

Line 4729: update eam_material_import -- wip_job_dtls_interface

4725:
4726: For I in C1
4727:
4728: loop
4729: update eam_material_import -- wip_job_dtls_interface
4730: set operation_Seq_num = I.new_op_seq
4731: -- where parent_header_id = I.header_id
4732: where wip_entity_id = I.header_id
4733: and operation_seq_num = 1

Line 4744: update eam_material_import -- wip_job_dtls_interface

4740:
4741: For J in C2
4742:
4743: loop
4744: update eam_material_import -- wip_job_dtls_interface
4745: set QUANTITY_PER_ASSEMBLY = J.qty_per_assy,
4746: REQUIRED_QUANTITY = J.reqd_qty
4747: where group_id = J.group_id
4748: -- and parent_header_id = J.parent_header_id

Line 4767: -- delete wip_job_dtls_interface

4763:
4764: loop
4765:
4766: --jguo
4767: -- delete wip_job_dtls_interface
4768: -- where rowid = K.rowid;
4769:
4770: null;
4771: