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.IBE_WORKFLOW_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 7195: mtl_units_of_measure u,

7191: qld.config_delta
7192: FROM Aso_quote_lines_all q,
7193: mtl_system_items_vl m,
7194: aso_tax_details t,
7195: mtl_units_of_measure u,
7196: Aso_quote_line_details qld,
7197: oe_transaction_types_tl tran,
7198: mtl_units_of_measure_tl uom
7199: WHERE q.inventory_item_id = m.inventory_item_id

Line 7198: mtl_units_of_measure_tl uom

7194: aso_tax_details t,
7195: mtl_units_of_measure u,
7196: Aso_quote_line_details qld,
7197: oe_transaction_types_tl tran,
7198: mtl_units_of_measure_tl uom
7199: WHERE q.inventory_item_id = m.inventory_item_id
7200: and q.organization_id = m.organization_id
7201: and t.quote_line_id(+) = q.quote_line_id
7202: and u.uom_code = q.uom_code

Line 7250: mtl_units_of_measure u,

7246: PRIOR related_quote_line_id ) ALR,
7247: Aso_quote_lines_all q,
7248: mtl_system_items_vl m,
7249: aso_tax_details t,
7250: mtl_units_of_measure u,
7251: Aso_quote_line_details qld,
7252: oe_transaction_types_tl tran,
7253: mtl_units_of_measure_tl uom
7254: WHERE q.quote_line_id = ALR.related_quote_line_id and

Line 7253: mtl_units_of_measure_tl uom

7249: aso_tax_details t,
7250: mtl_units_of_measure u,
7251: Aso_quote_line_details qld,
7252: oe_transaction_types_tl tran,
7253: mtl_units_of_measure_tl uom
7254: WHERE q.quote_line_id = ALR.related_quote_line_id and
7255: q.inventory_item_id = m.inventory_item_id
7256: and q.organization_id = m.organization_id
7257: and t.quote_line_id(+) = q.quote_line_id

Line 7301: mtl_units_of_measure_tl msit1,

7297: cfgdtl.config_delta config_delta_flag
7298: FROM oe_order_lines_all ol,
7299: mtl_system_items_vl msi,
7300: CZ_CONFIG_ITEMS cfgdtl,
7301: mtl_units_of_measure_tl msit1,
7302: oe_transaction_types_tl linetyp
7303: WHERE ol.header_id = p_order_id
7304: AND decode(ol.top_model_line_id,null,'1',decode(ol.top_model_line_id,ol.line_id,decode(ol.link_to_line_id,null,'1','2'),'2'))= '1'
7305: and ol.inventory_item_id = msi.inventory_item_Id

Line 7339: mtl_units_of_measure_tl msit1,

7335: cfgdtl.config_delta config_delta_flag
7336: FROM oe_order_lines_all ol,
7337: mtl_system_items_vl msi,
7338: CZ_CONFIG_ITEMS cfgdtl,
7339: mtl_units_of_measure_tl msit1,
7340: oe_transaction_types_tl linetyp
7341: WHERE ol.header_id = p_order_id
7342: and link_to_line_id is not null
7343: and ( top_model_line_id = p_mdl_top_line_id)

Line 9297: from aso_quote_lines_all ql,mtl_units_of_measure_tl uom

9293: l_reccharge VARCHAR2(1);
9294:
9295: Cursor c_reccur_quote_footer(c_quote_id NUMBER) IS
9296: select uom.unit_of_measure_tl charge_periodicity_desc,nvl(sum(ql.line_quote_price*ql.quantity),'0.00') rec_subtotal
9297: from aso_quote_lines_all ql,mtl_units_of_measure_tl uom
9298: where ql.quote_header_id = c_quote_id
9299: and ql.charge_periodicity_code is not null
9300: and uom.uom_code(+) = ql.charge_periodicity_code
9301: and uom.language(+) = userenv('lang')