[Home] [Help]
6074:
6075: -- Creating item category assignments for the default category sets
6076: -- for the functional areas having the defining attribute enabled.
6077:
6078: insert into mtl_item_categories
6079: (
6080: inventory_item_id,
6081: category_set_id,
6082: category_id,
6144: )
6145: )
6146: and not exists
6147: ( select 'already_exists'
6148: from mtl_item_categories mic
6149: where mic.inventory_item_id = rec.inventory_item_id
6150: and mic.organization_id = rec.organization_id
6151: and mic.category_set_id = s.category_set_id
6152: );
6172: IF (l_co_control_level = 1 OR l_io_control_level = 1) THEN
6173: /*Inserts for all the child Orgs if either IO or CO is master controlled and their value is 'Y'*/
6174: /*Modified for Bug 9833451 */
6175: /*Inserts for all the child Orgs if either IO or CO is master controlled and their value is 'Y'*/
6176: insert into mtl_item_categories
6177: (
6178: inventory_item_id,
6179: category_set_id,
6180: category_id,
6226: )
6227: -- Check if the item already has any category assignment
6228: and not exists
6229: ( select 'already_exists'
6230: from mtl_item_categories mic
6231: where mic.inventory_item_id = rec.inventory_item_id
6232: --Bug 4089984. Modified following 'and' condition to
6233: -- pick up rows from mtl_parameters table
6234: and mic.organization_id = mp.organization_id
6248: and rec.INTERNAL_ORDER_FLAG = 'Y')
6249: );
6250: END IF;
6251: /*Inserts for specific orgs including master orgs*/
6252: insert into mtl_item_categories
6253: (
6254: inventory_item_id,
6255: category_set_id,
6256: category_id,
6297: )
6298: -- Check if the item already has any category assignment
6299: and not exists
6300: ( select 'already_exists'
6301: from mtl_item_categories mic
6302: where mic.inventory_item_id = rec.inventory_item_id
6303: --Bug 4089984. Modified following 'and' condition to
6304: -- pick up rows from mtl_parameters table
6305: and mic.organization_id = rec.organization_id