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 BOM_OPERATION_RESOURCES

Line 437: bom_operation_resources bor,

433: lv_pri_res_seq_num,
434: lv_pri_sub_grp_num,
435: lv_pri_schd_seq_num
436: From WSM_LOT_JOB_DTL_INTERFACE jdi,
437: bom_operation_resources bor,
438: bom_operation_sequences bos
439: Where jdi.group_id = G_WIP_GROUP_ID
440: and jdi.parent_header_id = lv_header_id(n)
441: -- ds and jdi.load_type in (1,4)

Line 483: bom_operation_resources bor,

479: BULK COLLECT INTO lv_alt_res_rowid,
480: lv_alt_sub_grp_num,
481: lv_alt_schd_seq_num
482: From WSM_LOT_JOB_DTL_INTERFACE jdi,
483: bom_operation_resources bor,
484: bom_operation_sequences bos,
485: bom_sub_operation_resources bsor
486: Where jdi.group_id = G_WIP_GROUP_ID
487: and jdi.parent_header_id = lv_header_id(n)

Line 555: from bom_operation_resources bor,

551: , lv_unschd_batch_id
552: , LV_UNSCHD_MAX_ASSIGNED_UNITS
553: , lv_unschd_parent_seq_num
554: -- , lv_unschd_schedule_seq_num
555: from bom_operation_resources bor,
556: bom_operation_sequences bos,
557: wsm_lot_job_dtl_interface jdi
558: Where bor.schedule_flag = 2
559: and bor.schedule_seq_num = jdi.schedule_seq_num

Line 618: from bom_operation_resources bor,

614: , jdi.group_sequence_num --- sbala
615: , jdi.batch_id
616: , jdi.max_assigned_units --- sbala
617: , jdi.parent_resource_seq_num --- sbala
618: from bom_operation_resources bor,
619: bom_operation_sequences bos,
620: wsm_lot_job_dtl_interface jdi
621: Where bor.schedule_flag = 2
622: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1

Line 732: BOM_OPERATION_RESOURCES bor

728: lv_unres_schd_seq_num,
729: lv_unres_res_id,
730: lv_unres_sub_grp_num
731: From BOM_OPERATION_SEQUENCES bos,
732: BOM_OPERATION_RESOURCES bor
733: Where bos.routing_sequence_id = lv_routing_seq_id(n)
734: and bos.operation_seq_num = lv_nwk_op_seq_num(k)
735: and bos.effectivity_date <= lv_start_date(n)
736: and NVL(bos.disable_date, lv_start_date(n)) >= lv_start_date(n)

Line 3266: FROM BOM_OPERATION_RESOURCES bor,

3262: lu_res_seq,
3263: lu_schedule_seq_num,
3264: lu_resource_id,
3265: lu_res_required
3266: FROM BOM_OPERATION_RESOURCES bor,
3267: BOM_OPERATION_SEQUENCES os
3268: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3269: AND bor.operation_sequence_id= os.operation_sequence_id
3270: AND os.effectivity_date <= lv_start_date(n)

Line 3332: FROM BOM_OPERATION_RESOURCES bor,

3328: lun_resource_id,
3329: lun_basis_type,
3330: lun_usage,
3331: lun_res_required
3332: FROM BOM_OPERATION_RESOURCES bor,
3333: BOM_OPERATION_SEQUENCES os,
3334: BOM_RESOURCES br
3335: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3336: AND bor.operation_sequence_id= os.operation_sequence_id

Line 3414: bom_operation_resources bor1,

3410: , lsud_maximum_assigned_units
3411: , lsud_parent_seq_num
3412: -- , lsud_schedule_seq_num
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)

Line 4196: FROM bom_operation_resources bor1,

4192: then
4193:
4194: Select max(bor1.resource_seq_num)
4195: into v_max_resource_Seq
4196: FROM bom_operation_resources bor1,
4197: BOM_OPERATION_SEQUENCES os
4198: WHERE bor1.operation_sequence_id= os.operation_sequence_id
4199: and os.routing_sequence_id= i.common_routing_Sequence_id
4200: and os.operation_seq_num = i.operation_seq_num;