DBA Data[Home] [Help]

APPS.MRP_AP_REL_PLAN_PUB dependencies on BOM_RESOURCES

Line 3622: BOM_RESOURCES br

3618: lun_usage,
3619: lun_res_required
3620: FROM BOM_OPERATION_RESOURCES bor,
3621: BOM_OPERATION_SEQUENCES os,
3622: BOM_RESOURCES br
3623: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3624: AND bor.operation_sequence_id= os.operation_sequence_id
3625: AND os.effectivity_date <= lv_start_date(n)
3626: -- AND NVL(os.disable_date, lv_start_date(n)) >= lv_start_date(n)

Line 3705: BOM_RESOURCES br,

3701: -- , lsud_schedule_seq_num
3702: FROM BOM_SUB_OPERATION_RESOURCES bor,
3703: bom_operation_resources bor1,
3704: BOM_OPERATION_SEQUENCES os,
3705: BOM_RESOURCES br,
3706: WIP_JOB_DTLS_INTERFACE JDI
3707: WHERE os.routing_sequence_id= lv_routing_seq_id(n)
3708: AND bor.operation_sequence_id= os.operation_sequence_id
3709: AND os.effectivity_date <= lv_start_date(n)