APPS.WIP_PROD_INDICATORS dependencies on MTL_UNITS_OF_MEASURE

Line 10: g_uom_code mtl_units_of_measure.uom_code%type;

6: g_applicationid NUMBER;
7: g_debug NUMBER; -- turning on debug mode
8: g_date_from DATE ;
9: g_date_to DATE;
10: g_uom_code mtl_units_of_measure.uom_code%type;
11: g_uom_class mtl_units_of_measure.uom_class%type;
12:
13: /* Constants for session - including schema name for truncating and
14: collecting stats */

Line 11: g_uom_class mtl_units_of_measure.uom_class%type;

7: g_debug NUMBER; -- turning on debug mode
8: g_date_from DATE ;
9: g_date_to DATE;
10: g_uom_code mtl_units_of_measure.uom_code%type;
11: g_uom_class mtl_units_of_measure.uom_class%type;
12:
13: /* Constants for session - including schema name for truncating and
14: collecting stats */
15: g_wip_schema VARCHAR2(30);

Line 999: from mtl_units_of_measure

995:
996: g_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
997: select uom_class
998: into g_uom_class
999: from mtl_units_of_measure
1000: where uom_code = g_uom_code;
1001:
1002: --dbms_output.put_line(g_uom_code);
1003:

Line 1281: mtl_units_of_measure muom

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
1284: (x_date_to + 0.99999)
1285: AND wt.resource_id = nvl(p_resource_id, wt.resource_id)

Line 1914: from mtl_units_of_measure

1910: -- Get the default UOM Class
1911: g_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
1912: select uom_class
1913: into g_uom_class
1914: from mtl_units_of_measure
1915: where uom_code = g_uom_code;
1916:
1917: -- Step 1 : Calculate the Std. Qty for each
1918: -- wip_entity_id, OP Seq, Dept, Res, Txn Date

Line 1994: mtl_units_of_measure muom

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
1997: and wor.operation_seq_num = wit.operation_seq_num
1998: and wit.indicator_type = p_indicator

Line 2081: from mtl_units_of_measure

2077: proc_name := 'Calc_Eff_Applied_Units';
2078: g_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
2079: select uom_class
2080: into g_uom_class
2081: from mtl_units_of_measure
2082: where uom_code = g_uom_code;
2083:
2084: --- ??? Can this ever happen? The SQL that set the process phase
2085: --- to WIP_EFF_PHASE_THREE in calculate_std_units

Line 2142: from mtl_units_of_measure

2138: proc_name := 'Misc_Applied_Units';
2139: g_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
2140: select uom_class
2141: into g_uom_class
2142: from mtl_units_of_measure
2143: where uom_code = g_uom_code;
2144:
2145: -- ??? What is this SQL doing?
2146: insert into wip_indicators_temp(

Line 2192: mtl_units_of_measure muom

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)
2195: and trunc(p_date_to) + 0.999999
2196: and wt.resource_id = nvl(p_resource_id, wt.resource_id)

Line 3410: mtl_units_of_measure muom

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
3413: and br.resource_id = mnra.resource_id
3414: and br.unit_of_measure = muom.uom_code

Line 3542: mtl_units_of_measure muom

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)
3545: and trunc(mnra.shift_date) >= trunc(br.creation_date)
3546: and br.resource_id = mnra.resource_id

Line 4177: from mtl_units_of_measure

4173: -- Get the UOM code from the profile
4174: g_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
4175: select uom_class
4176: into g_uom_class
4177: from mtl_units_of_measure
4178: where uom_code = g_uom_code;
4179:
4180: -- Set up the date ranges if needed
4181: /* For performance reasons should be just use the

Line 4465: mtl_units_of_measure muom

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
4468: trunc(x_date_to) + 0.99999
4469: and br.resource_id = mnra.resource_id

Line 4569: mtl_units_of_measure muom

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)
4573: AND bdrv.unit_of_measure = muom.uom_code

Line 4646: from mtl_units_of_measure

4642: -- Get the UOM code from the profile
4643: g_uom_code := fnd_profile.value('BOM:HOUR_UOM_CODE');
4644: select uom_class
4645: into g_uom_class
4646: from mtl_units_of_measure
4647: where uom_code = g_uom_code;
4648:
4649: -- Set up the date ranges if needed
4650: /* For performance reasons should be just use the

Line 4948: mtl_units_of_measure muom

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
4951: trunc(x_date_to) + 0.99999
4952: and br.resource_id = mnra.resource_id

Line 5125: mtl_units_of_measure muom

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
5128: trunc(p_date_to) + 0.99999
5129: and br.resource_id = mnra.resource_id