[Home] [Help]
604: 24* bdr.capacity_units/m2.conversion_rate avail_qty,
605: 24* bdr.capacity_units avail_qty_g,
606: 24* bdr.capacity_units/m2.conversion_rate * crc.resource_rate avail_val_b,
607: OPI_SOURCE source
608: FROM bom_resources br,
609: bom_departments bd,
610: bom_department_resources bdr,
611: bom_calendar_dates bcd,
612: mtl_parameters mp,
677: else ( ( 86400 - bst.from_time + bst.to_time)/3600*bdr.capacity_units
678: /m2.conversion_rate * m.conversion_rate * crc.resource_rate )
679: end ) avail_val_b,
680: OPI_SOURCE source
681: FROM bom_resources br,
682: bom_departments bd,
683: bom_department_resources bdr,
684: bom_resource_shifts brs,
685: bom_shift_dates bsd,
915: 24* bdr.capacity_units/m2.conversion_rate avail_qty,
916: 24* bdr.capacity_units avail_qty_g,
917: 24* bdr.capacity_units/m2.conversion_rate * crc.resource_rate avail_val_b,
918: OPI_SOURCE source
919: FROM bom_resources br,
920: bom_departments bd,
921: bom_department_resources bdr,
922: bom_calendar_dates bcd,
923: mtl_parameters mp,
986: else ( ( 86400 - bst.from_time + bst.to_time)/3600*bdr.capacity_units
987: /m2.conversion_rate * m.conversion_rate * crc.resource_rate )
988: end ) avail_val_b,
989: OPI_SOURCE source
990: FROM bom_resources br,
991: bom_departments bd,
992: bom_department_resources bdr,
993: bom_resource_shifts brs,
994: bom_shift_dates bsd,
2806: g_request_id
2807: FROM wip_operation_resources wor,
2808: wip_operations wo,
2809: opi_dbi_jobs_f job,
2810: bom_resources br,
2811: mtl_parameters mp,
2812: mtl_uom_conversions m,
2813: mtl_uom_conversions m2,
2814: cst_resource_costs crc,
3701: g_request_id
3702: FROM wip_operation_resources wor,
3703: wip_operations wo,
3704: opi_dbi_jobs_f job,
3705: bom_resources br,
3706: mtl_parameters mp,
3707: mtl_uom_conversions m,
3708: mtl_uom_conversions m2,
3709: cst_resource_costs crc,