APPS.QP_PRICE_BOOK_PVT dependencies on MTL_ITEM_CATEGORIES

Line 1262: FROM mtl_item_categories a, mtl_categories_b b,

1258: '=', category_id, null, 'N',
1259: 'PRODUCT', sysdate, l_user_id, sysdate,
1260: l_user_id, l_login_id
1261: FROM (SELECT DISTINCT a.category_id
1262: FROM mtl_item_categories a, mtl_categories_b b,
1263: mtl_category_sets_b c, mtl_default_category_sets d
1264: WHERE a.inventory_item_id = l_item_number_tbl(i)
1265: AND a.organization_id = l_inv_org_id --inventory org, not OU
1266: AND b.category_id = a.category_id

Line 1536: FROM mtl_item_categories cat

1532:
1533: CURSOR cat_items_cur(a_category_id NUMBER, a_organization_id NUMBER)
1534: IS
1535: SELECT DISTINCT cat.inventory_item_id item_id
1536: FROM mtl_item_categories cat
1537: WHERE cat.organization_id = a_organization_id
1538: AND (cat.category_id = a_category_id
1539: OR
1540: EXISTS (SELECT 'Y'

Line 1554: FROM mtl_item_categories mic

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'
1554: FROM mtl_item_categories mic
1555: WHERE inventory_item_id = msi.inventory_item_id
1556: AND organization_id = msi.organization_id);
1557:
1558: /*