APPS.INV_ITEM_REVISION_PUB dependencies on MTL_SYSTEM_ITEMS_B

Line 37: FROM mtl_system_items_b

33: ( p_inventory_item_id NUMBER
34: , p_organization_id NUMBER
35: ) IS
36: SELECT 'x'
37: FROM mtl_system_items_b
38: WHERE
39: inventory_item_id = p_inventory_item_id
40: AND organization_id = p_organization_id;
41:

Line 354: FROM mtl_system_items_b

350:
351: CURSOR c_get_item_catalog(cp_inventory_item_id NUMBER
352: ,cp_organization_id NUMBER) IS
353: SELECT item_catalog_group_id
354: FROM mtl_system_items_b
355: WHERE organization_id = cp_organization_id
356: AND inventory_item_id = cp_inventory_item_id;
357:
358: CURSOR c_parent_catalogs(cp_catalog_group_id NUMBER) IS

Line 365: l_catalog_group_id mtl_system_items_b.item_catalog_group_id%TYPE;

361: FROM mtl_item_catalog_groups_b
362: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
363: START WITH item_catalog_group_id = cp_catalog_group_id;
364:
365: l_catalog_group_id mtl_system_items_b.item_catalog_group_id%TYPE;
366: l_parent_catalog VARCHAR2(150):= NULL;
367: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
368: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
369: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;