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 7100: mtl_units_of_measure u,

7096: qld.config_delta
7097: FROM Aso_quote_lines_all q,
7098: mtl_system_items_vl m,
7099: aso_tax_details t,
7100: mtl_units_of_measure u,
7101: Aso_quote_line_details qld,
7102: oe_transaction_types_tl tran,
7103: mtl_units_of_measure_tl uom
7104: WHERE q.inventory_item_id = m.inventory_item_id

Line 7103: mtl_units_of_measure_tl uom

7099: aso_tax_details t,
7100: mtl_units_of_measure u,
7101: Aso_quote_line_details qld,
7102: oe_transaction_types_tl tran,
7103: mtl_units_of_measure_tl uom
7104: WHERE q.inventory_item_id = m.inventory_item_id
7105: and q.organization_id = m.organization_id
7106: and t.quote_line_id(+) = q.quote_line_id
7107: and u.uom_code = q.uom_code

Line 7155: mtl_units_of_measure u,

7151: PRIOR related_quote_line_id ) ALR,
7152: Aso_quote_lines_all q,
7153: mtl_system_items_vl m,
7154: aso_tax_details t,
7155: mtl_units_of_measure u,
7156: Aso_quote_line_details qld,
7157: oe_transaction_types_tl tran,
7158: mtl_units_of_measure_tl uom
7159: WHERE q.quote_line_id = ALR.related_quote_line_id and

Line 7158: mtl_units_of_measure_tl uom

7154: aso_tax_details t,
7155: mtl_units_of_measure u,
7156: Aso_quote_line_details qld,
7157: oe_transaction_types_tl tran,
7158: mtl_units_of_measure_tl uom
7159: WHERE q.quote_line_id = ALR.related_quote_line_id and
7160: q.inventory_item_id = m.inventory_item_id
7161: and q.organization_id = m.organization_id
7162: and t.quote_line_id(+) = q.quote_line_id

Line 7206: mtl_units_of_measure_tl msit1,

7202: cfgdtl.config_delta config_delta_flag
7203: FROM oe_order_lines_all ol,
7204: mtl_system_items_vl msi,
7205: CZ_CONFIG_ITEMS cfgdtl,
7206: mtl_units_of_measure_tl msit1,
7207: oe_transaction_types_tl linetyp
7208: WHERE ol.header_id = p_order_id
7209: 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'
7210: and ol.inventory_item_id = msi.inventory_item_Id

Line 7244: mtl_units_of_measure_tl msit1,

7240: cfgdtl.config_delta config_delta_flag
7241: FROM oe_order_lines_all ol,
7242: mtl_system_items_vl msi,
7243: CZ_CONFIG_ITEMS cfgdtl,
7244: mtl_units_of_measure_tl msit1,
7245: oe_transaction_types_tl linetyp
7246: WHERE ol.header_id = p_order_id
7247: and link_to_line_id is not null
7248: and ( top_model_line_id = p_mdl_top_line_id)

Line 9202: from aso_quote_lines_all ql,mtl_units_of_measure_tl uom

9198: l_reccharge VARCHAR2(1);
9199:
9200: Cursor c_reccur_quote_footer(c_quote_id NUMBER) IS
9201: select uom.unit_of_measure_tl charge_periodicity_desc,nvl(sum(ql.line_quote_price*ql.quantity),'0.00') rec_subtotal
9202: from aso_quote_lines_all ql,mtl_units_of_measure_tl uom
9203: where ql.quote_header_id = c_quote_id
9204: and ql.charge_periodicity_code is not null
9205: and uom.uom_code(+) = ql.charge_periodicity_code
9206: and uom.language(+) = userenv('lang')