APPS.QP_PRICE_BOOK_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1549: FROM mtl_system_items_b msi

1545:
1546: CURSOR items_cur(a_organization_id NUMBER, a_pricing_perspective VARCHAR2)
1547: IS
1548: SELECT msi.inventory_item_id item_id
1549: FROM mtl_system_items_b msi
1550: WHERE msi.organization_id = a_organization_id
1551: AND msi.purchasing_enabled_flag = decode(a_pricing_perspective,
1552: 'PO', 'Y', msi.purchasing_enabled_flag)
1553: AND EXISTS (SELECT 'X'

Line 1578: FROM mtl_system_items msi, mtl_units_of_measure muom

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

Line 1586: FROM mtl_system_items msi2,

1582: AND nvl(muom.disable_date, trunc(a_effective_date) + 1) >
1583: trunc(a_effective_date)
1584: UNION
1585: SELECT a_item_id item_id, muom.uom_code uom_code
1586: FROM mtl_system_items msi2,
1587: mtl_units_of_measure muom2,
1588: mtl_uom_conversions mcon,
1589: mtl_units_of_measure muom,
1590: mtl_uom_classes mcl

Line 1635: mtl_system_items msi,

1631: --bug 8970504
1632: UNION
1633: SELECT a_item_id item_id, a.product_uom_code
1634: FROM qp_list_lines_v a,
1635: mtl_system_items msi,
1636: mtl_units_of_measure muom,
1637: mtl_uom_classes mcl
1638: WHERE a.product_attribute_context = 'ITEM'
1639: and a.product_attribute = 'PRICING_ATTRIBUTE1'