DBA Data[Home] [Help]

APPS.MRP_AP_REL_PLAN_PUB dependencies on BOM_RESOURCES

Line 3334: BOM_RESOURCES br

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

Line 3416: BOM_RESOURCES br,

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)
3419: AND bor.operation_sequence_id= os.operation_sequence_id
3420: AND os.effectivity_date <= lv_start_date(n)