APPS.MRP_AP_REL_PLAN_PUB dependencies on WSM_COPY_OP_RESOURCES

Line 867: WSM_COPY_OP_RESOURCES wcor

863: lv_res_seq_num,
864: lv_sub_grp_num,
865: lv_schd_seq_num
866: From WSM_LOT_JOB_DTL_INTERFACE jdi,
867: WSM_COPY_OP_RESOURCES wcor
868: Where jdi.group_id = G_WIP_GROUP_ID
869: and jdi.parent_header_id = lv_header_id(n)
870: -- and jdi.load_type in (1,4)
871: and jdi.load_type in (1,4, RESOURCE_INSTANCES_OSFM, RESOURCE_INSTANCE_USAGE_OSFM)

Line 1125: from wsm_copy_op_resources wcor,

1121: lv_unschd_schd_seq_num,
1122: lv_unschd_rep_grp_num,
1123: lv_unschd_subs_grp_num,
1124: lv_unschd_load_type
1125: from wsm_copy_op_resources wcor,
1126: wsm_lot_job_dtl_interface jdi
1127: Where wcor.schedule_flag = 2
1128: and wcor.schedule_seq_num = jdi.schedule_seq_num
1129: and jdi.replacement_group_num = wcor.replacement_group_num

Line 1146: from wsm_copy_op_resources wcor,

1142: wcor.schedule_seq_num,
1143: nvl(wcor.replacement_group_num,0),
1144: wcor.substitute_group_num,
1145: jdi.load_type
1146: from wsm_copy_op_resources wcor,
1147: wsm_lot_job_dtl_interface jdi
1148: Where wcor.schedule_flag = 2
1149: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1
1150: where jdi1.group_id = G_WIP_GROUP_ID

Line 1463: From WSM_COPY_OP_RESOURCES wcor

1459: lv_unres_schd_seq_num,
1460: lv_unres_sub_grp_num,
1461: lv_unres_rep_grp_num,
1462: lv_unres_res_id
1463: From WSM_COPY_OP_RESOURCES wcor
1464: Where wcor.operation_seq_num = lv_nwk_op_seq_num(k)
1465: and wcor.wip_entity_id = lv_wip_entity_id(n)
1466: and lv_nwk_job_op_seq_num(k) is null;
1467:

Line 1605: From WSM_COPY_OP_RESOURCES wcor

1601: lv_unres_schd_seq_num,
1602: lv_unres_sub_grp_num,
1603: lv_unres_rep_grp_num,
1604: lv_unres_res_id
1605: From WSM_COPY_OP_RESOURCES wcor
1606: Where wcor.operation_seq_num = lv_nwk_op_seq_num(k)
1607: and wcor.wip_entity_id = lv_wip_entity_id(n)
1608: and lv_nwk_job_op_seq_num(k) is null;
1609: