APPS.QP_PRICE_BOOK_PVT dependencies on MTL_ITEM_CATEGORIES

Line 1281: FROM mtl_item_categories a, mtl_categories_b b,

1277: '=', category_id, null, 'N',
1278: 'PRODUCT', sysdate, l_user_id, sysdate,
1279: l_user_id, l_login_id
1280: FROM (SELECT DISTINCT a.category_id
1281: FROM mtl_item_categories a, mtl_categories_b b,
1282: mtl_category_sets_b c, mtl_default_category_sets d
1283: WHERE a.inventory_item_id = l_item_number_tbl(i)
1284: AND a.organization_id = l_inv_org_id --inventory org, not OU
1285: AND b.category_id = a.category_id

Line 1555: FROM mtl_item_categories cat

1551:
1552: CURSOR cat_items_cur(a_category_id NUMBER, a_organization_id NUMBER)
1553: IS
1554: SELECT DISTINCT cat.inventory_item_id item_id
1555: FROM mtl_item_categories cat
1556: WHERE cat.organization_id = a_organization_id
1557: AND (cat.category_id = a_category_id
1558: OR
1559: EXISTS (SELECT 'Y'

Line 1573: FROM mtl_item_categories mic

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'
1573: FROM mtl_item_categories mic
1574: WHERE inventory_item_id = msi.inventory_item_id
1575: AND organization_id = msi.organization_id);
1576:
1577: CURSOR item_uom_cur(a_item_id NUMBER, a_organization_id NUMBER,