DBA Data[Home] [Help]

APPS.QP_PRICE_BOOK_PVT dependencies on MTL_SYSTEM_ITEMS_B

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'