DBA Data[Home] [Help]

APPS.INV_ITEM_DATA_SCRIPTS dependencies on MTL_CATEGORY_SETS_B

Line 84: FROM mtl_category_sets_b

80: category_set_id,
81: category_id
82: FROM mtl_item_categories a
83: WHERE EXISTS (SELECT 'X'
84: FROM mtl_category_sets_b
85: WHERE control_level = 1
86: AND category_set_id = a.category_set_id)
87: AND a.organization_id = master_org_id;
88: /*Retrieves all the child Organizations for the the specific item and master org combination */

Line 113: FROM mtl_category_sets_b

109: FROM mtl_parameters m
110: WHERE m.master_organization_id = rec_cur.master_organization_id
111: AND m.organization_id <> m.master_organization_id)
112: AND EXISTS (SELECT 'X'
113: FROM mtl_category_sets_b
114: WHERE control_level = 1
115: AND category_set_id = a.category_set_id)
116: AND NOT EXISTS (SELECT 'x'
117: FROM mtl_item_categories b