DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on MTL_SYSTEM_ITEMS_B

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'