APPS.MRP_AP_REL_PLAN_PUB dependencies on WIP_SUB_OPERATION_RESOURCES

Line 926: wip_sub_operation_resources wsor

922: wsor.resource_seq_num,
923: wsor.substitute_group_num,
924: wsor.schedule_seq_num
925: From WSM_LOT_JOB_DTL_INTERFACE jdi,
926: wip_sub_operation_resources wsor
927: Where jdi.group_id = G_WIP_GROUP_ID
928: and jdi.parent_header_id = lv_header_id(n)
929: -- and jdi.load_type in (1,4)
930: and jdi.load_type in (1,4, RESOURCE_INSTANCES_OSFM, RESOURCE_INSTANCE_USAGE_OSFM)

Line 993: from wip_sub_operation_resources wsor,

989: wsor.replacement_group_num,
990: wsor.substitute_group_num,
991: jdi.routing_op_seq_num,
992: jdi.load_type
993: from wip_sub_operation_resources wsor,
994: wsm_lot_job_dtl_interface jdi
995: where wsor.scheduled_flag = 2
996: and wsor.schedule_seq_num = jdi.schedule_seq_num
997: and jdi.replacement_group_num = nvl(wsor.replacement_group_num,0)

Line 3799: replacement_group_num = valid value in wip_sub_operation_resources.Finally the

3795: substitution_type = 3
3796: opearation_seq_num, resource_seq_num, resource_id_old, resource_id_new,
3797: and substitute_group_num should be set to the current(or primary) resource in
3798: wip_operation_resources
3799: replacement_group_num = valid value in wip_sub_operation_resources.Finally the
3800: alternate resource record will be deleted from wip_job_dtls_interface*/
3801:
3802: FOR j IN 1..lsud_res_req_count
3803:

Line 4381: wip_sub_operation_resources wsor

4377: lv_res_alt_usage_rate,
4378: lv_res_alt_basis_type
4379: from wip_job_dtls_interface jdi,
4380: wip_operation_resources wor,
4381: wip_sub_operation_resources wsor
4382: where not exists(select 1 from wip_operation_resources wor1
4383: where wor1.operation_seq_num = jdi.operation_seq_num
4384: and nvl(wor1.schedule_seq_num,wor1.resource_seq_num) = jdi.schedule_seq_num
4385: -- and wor1.resource_seq_num = jdi.resource_seq_num