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 3510: replacement_group_num = valid value in wip_sub_operation_resources.Finally the

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

Line 4079: wip_sub_operation_resources wsor

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
4083: -- and wor1.resource_seq_num = jdi.resource_seq_num