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_SYSTEM_ITEMS

Line 1568: FROM mtl_system_items_b msi

1564:
1565: CURSOR items_cur(a_organization_id NUMBER, a_pricing_perspective VARCHAR2)
1566: IS
1567: SELECT msi.inventory_item_id item_id
1568: FROM mtl_system_items_b msi
1569: WHERE msi.organization_id = a_organization_id
1570: AND msi.purchasing_enabled_flag = decode(a_pricing_perspective,
1571: 'PO', 'Y', msi.purchasing_enabled_flag)
1572: AND EXISTS (SELECT 'X'

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 1589: FROM mtl_system_items msi2,

1585: AND nvl(muom.disable_date, trunc(a_effective_date) + 1) >
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