eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_PROD_INDICATORS dependencies on INV_CONVERT

Line 1273: sum(inv_convert.inv_um_convert(0,NULL,wt.primary_quantity,

1269: br.resource_code resource_code,
1270: wt.wip_entity_id wip_entity_id, -- Bug 3604065
1271: wt.operation_seq_num operation_seq_num, --bug 3662056
1272: trunc(wt.transaction_date) transaction_date,
1273: sum(inv_convert.inv_um_convert(0,NULL,wt.primary_quantity,
1274: wt.primary_uom,g_uom_code,
1275: NULL,NULL)) applied_units_utz
1276: FROM
1277: bom_resources br,

Line 1973: inv_convert.inv_um_convert(0,

1969: wor.basis_type,
1970: wit.indicator_type,
1971: WIP_EFF_PHASE_TWO, /* This is second stage */
1972: transaction_date, -- already trunc'ed
1973: inv_convert.inv_um_convert(0,
1974: NULL,
1975: decode(wor.basis_type,
1976: 1, (wit.standard_quantity*
1977: wor.usage_rate_or_amount),

Line 2177: sum(inv_convert.inv_um_convert(0,NULL,wt.primary_quantity,

2173: wt.resource_id,
2174: br.resource_code,
2175: 0,
2176: 0,
2177: sum(inv_convert.inv_um_convert(0,NULL,wt.primary_quantity,
2178: wt.primary_uom,g_uom_code,NULL,NULL)),
2179: trunc(wt.transaction_date),
2180: WIP_EFFICIENCY,
2181: WIP_EFF_PHASE_THREE, -- this is the third and final phase

Line 4768: decode(sign(sum(inv_convert.inv_um_convert(0,NULL,decode(wor.basis_type,

4764: bdr.department_id,
4765: bd.department_code,
4766: mnra.shift_date,
4767: null,
4768: decode(sign(sum(inv_convert.inv_um_convert(0,NULL,decode(wor.basis_type,
4769: 1,
4770: NVL((wor.usage_rate_or_amount*wo.scheduled_quantity
4771: - nvl(wor.applied_resource_units,0)),0)*
4772: get_Workday_Ratio(wor.resource_id, wor.organization_id,trunc(wor.start_date), trunc(wor.completion_date), trunc(mnra.shift_date)),

Line 4781: ))),1,sum(inv_convert.inv_um_convert(0,NULL,decode(wor.basis_type,

4777: NVL(wor.usage_rate_or_amount,0),
4778: 0),
4779: 0)
4780: ),wor.uom_code,g_uom_code,NULL,NULL
4781: ))),1,sum(inv_convert.inv_um_convert(0,NULL,decode(wor.basis_type,
4782: 1,
4783: NVL((wor.usage_rate_or_amount*wo.scheduled_quantity
4784: - nvl(wor.applied_resource_units,0)),0)*
4785: get_Workday_Ratio(wor.resource_id, wor.organization_id,trunc(wor.start_date), trunc(wor.completion_date), trunc(mnra.shift_date)),