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 371: FROM mtl_system_items_b

367:
368: CURSOR c_get_item_catalog(cp_inventory_item_id NUMBER
369: ,cp_organization_id NUMBER) IS
370: SELECT item_catalog_group_id
371: FROM mtl_system_items_b
372: WHERE organization_id = cp_organization_id
373: AND inventory_item_id = cp_inventory_item_id;
374:
375: CURSOR c_parent_catalogs(cp_catalog_group_id NUMBER) IS

Line 382: l_catalog_group_id mtl_system_items_b.item_catalog_group_id%TYPE;

378: FROM mtl_item_catalog_groups_b
379: CONNECT BY PRIOR parent_catalog_group_id = item_catalog_group_id
380: START WITH item_catalog_group_id = cp_catalog_group_id;
381:
382: l_catalog_group_id mtl_system_items_b.item_catalog_group_id%TYPE;
383: l_parent_catalog VARCHAR2(150):= NULL;
384: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
385: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
386: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;