[Home] [Help]
1274: wt.primary_uom,g_uom_code,
1275: NULL,NULL)) applied_units_utz
1276: FROM
1277: bom_resources br,
1278: bom_departments bd,
1279: bom_department_resources bdr,
1280: wip_transactions wt,
1281: mtl_units_of_measure muom
1282: WHERE
1755: g_applicationid
1756: from
1757: wip_move_transactions wmt,
1758: wip_operations wo,
1759: bom_departments bd
1760: where
1761: trunc(wmt.transaction_date) between trunc(nvl(p_date_from,wmt.transaction_date))
1762: and trunc(nvl(p_date_to,wmt.transaction_date))
1763: and wo.operation_seq_num <= decode(sign(wmt.FM_OPERATION_SEQ_NUM-wmt.TO_OPERATION_SEQ_NUM),
1987: wit.created_by,
1988: wit.program_application_id
1989: from wip_indicators_temp wit,
1990: bom_resources br,
1991: bom_departments bd,
1992: bom_department_resources bdr,
1993: wip_operation_resources wor,
1994: mtl_units_of_measure muom
1995: where
2185: g_userid,
2186: g_applicationid
2187: from
2188: bom_resources br,
2189: bom_departments bd,
2190: bom_department_resources bdr,
2191: wip_transactions wt,
2192: mtl_units_of_measure muom
2193: where
2349: g_applicationid
2350: from
2351: wip_move_transactions wmt,
2352: wip_operations wo,
2353: bom_departments bd
2354: where trunc(wmt.transaction_date) between trunc(nvl(p_date_from,wmt.transaction_date))
2355: and trunc(nvl(p_date_to,wmt.transaction_date))
2356: -- below statement is equavivalent to between only. Dont know why such a complex condition.
2357: -- and wo.operation_seq_num between wmt.FM_OPERATION_SEQ_NUM and wmt.TO_OPERATION_SEQ_NUM
3404: department_id,
3405: resource_id,
3406: transaction_date) wit,
3407: bom_resources br,
3408: bom_departments bd,
3409: wip_bis_mnra_temp mnra,
3410: mtl_units_of_measure muom
3411: where mnra.shift_date BETWEEN trunc(g_date_from)
3412: AND trunc (g_date_to) + 0.99999
3536: 1, ( mnra.to_time - mnra.from_time ) , 0 ))/3600)*mnra.capacity_units)) available_hours,
3537: trunc(mnra.shift_date) shift_date
3538: FROM
3539: bom_resources br,
3540: bom_departments bd,
3541: mrp_net_resource_avail mnra,
3542: mtl_units_of_measure muom
3543: where
3544: trunc(mnra.shift_date) between trunc(g_date_from) and trunc(g_date_to)
4459: g_userid,
4460: g_applicationid
4461: from
4462: bom_resources br,
4463: bom_departments bd,
4464: mrp_net_resource_avail mnra,
4465: mtl_units_of_measure muom
4466: where
4467: mnra.shift_date between trunc(x_date_from) and
4800: g_userid,
4801: g_applicationid
4802: from
4803: mrp_net_resource_avail mnra,
4804: bom_departments bd,
4805: bom_department_resources bdr,
4806: wip_operations_v wo,
4807: wip_operation_resources_v wor,
4808: wip_discrete_jobs wdj
4942: g_userid,
4943: g_applicationid
4944: from
4945: bom_resources br,
4946: bom_departments bd,
4947: mrp_net_resource_avail mnra,
4948: mtl_units_of_measure muom
4949: where
4950: mnra.shift_date between trunc(x_date_from) and
5119: g_userid,
5120: g_applicationid
5121: from
5122: bom_resources br,
5123: bom_departments bd,
5124: mrp_net_resource_avail mnra,
5125: mtl_units_of_measure muom
5126: where
5127: mnra.shift_date between trunc(p_date_from) and