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

Line 1581: FROM mtl_system_items msi, mtl_units_of_measure muom

1577: CURSOR item_uom_cur(a_item_id NUMBER, a_organization_id NUMBER,
1578: a_effective_date DATE)
1579: IS
1580: SELECT msi.inventory_item_id item_id, msi.primary_uom_code uom_code
1581: FROM mtl_system_items msi, mtl_units_of_measure muom
1582: WHERE msi.organization_id = a_organization_id
1583: AND msi.inventory_item_id = a_item_id
1584: AND muom.uom_code = msi.primary_uom_code
1585: AND nvl(muom.disable_date, trunc(a_effective_date) + 1) >

Line 1590: mtl_units_of_measure muom2,

1586: trunc(a_effective_date)
1587: UNION
1588: SELECT a_item_id item_id, muom.uom_code uom_code
1589: FROM mtl_system_items msi2,
1590: mtl_units_of_measure muom2,
1591: mtl_uom_conversions mcon,
1592: mtl_units_of_measure muom,
1593: mtl_uom_classes mcl
1594: WHERE muom2.uom_code = msi2.primary_uom_code

Line 1592: mtl_units_of_measure muom,

1588: SELECT a_item_id item_id, muom.uom_code uom_code
1589: FROM mtl_system_items msi2,
1590: mtl_units_of_measure muom2,
1591: mtl_uom_conversions mcon,
1592: mtl_units_of_measure muom,
1593: mtl_uom_classes mcl
1594: WHERE muom2.uom_code = msi2.primary_uom_code
1595: and msi2.organization_id = a_organization_id
1596: and msi2.inventory_item_id = a_item_id

Line 1623: FROM mtl_units_of_measure muom,

1619: AND pa.pricing_phase_id = 1
1620: )
1621: UNION
1622: SELECT a_item_id item_id, muom.uom_code uom_code
1623: FROM mtl_units_of_measure muom,
1624: mtl_uom_conversions mcon,
1625: mtl_uom_classes mcl
1626: WHERE mcon.uom_code = muom.uom_code
1627: AND mcon.inventory_item_id = a_item_id