[Home] [Help]
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
1283: wt.transaction_date BETWEEN x_date_from AND
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
1996: wor.wip_entity_id = wit.wip_entity_id
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
2194: wt.transaction_date between trunc(p_date_from)
4564: p_resource_id IN NUMBER,
4565: p_uom_code IN VARCHAR2
4566: ) IS
4567: select distinct organization_id, department_id, resource_id
4568: from bom_department_resources_v bdrv,
4569: mtl_units_of_measure muom
4570: where bdrv.organization_id = nvl(p_organization_id, organization_id)
4571: and bdrv.department_id = nvl(p_department_id, department_id)
4572: and bdrv.resource_id = nvl(p_resource_id, resource_id)
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
4809: where