APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ITEM_CATEGORIES

Line 7532: Insert into mtl_item_categories

7528: END IF;
7529:
7530:
7531: /*--------------------------------------+
7532: Insert into mtl_item_categories
7533: +--------------------------------------*/
7534:
7535: lStmtNumber := 260;
7536:

Line 7540: insert into MTL_ITEM_CATEGORIES

7536:
7537: --bugfix 4861996
7538: --added ic1.category_set_id = ic.category_set_id condition
7539:
7540: insert into MTL_ITEM_CATEGORIES
7541: (inventory_item_id,
7542: category_set_id,
7543: category_id,
7544: last_update_date,

Line 7570: mtl_item_categories ic,

7566: NULL, -- program_id
7567: SYSDATE, -- program_update_date
7568: ic.organization_id
7569: from
7570: mtl_item_categories ic,
7571: bom_cto_src_orgs bcso
7572: where ic.inventory_item_id = pModelId --bugfix 2706981: swapped the positions
7573: and ic.organization_id = bcso.organization_id
7574: and bcso.model_item_id = ic.inventory_item_id --bugfix 2706981: replaced pModelId with col join

Line 7589: from MTL_ITEM_CATEGORIES ic1 -- bugfix 2706981: added alias

7585: -- end bugfix 2619501:
7586: --
7587: and NOT EXISTS
7588: (select NULL
7589: from MTL_ITEM_CATEGORIES ic1 -- bugfix 2706981: added alias
7590: where ic1.inventory_item_id = pConfigId
7591: and ic1.organization_id = bcso.organization_id
7592: and ic1.category_set_id = ic.category_set_id
7593: );

Line 7602: oe_debug_pub.add('Create_Item: ' || 'after insert: MTL_ITEM_CATEGORIES',2);

7598:
7599:
7600:
7601: IF PG_DEBUG <> 0 THEN
7602: oe_debug_pub.add('Create_Item: ' || 'after insert: MTL_ITEM_CATEGORIES',2);
7603: END IF;
7604:
7605: -- Start Bugfix 2197842
7606:

Line 7609: insert into MTL_ITEM_CATEGORIES

7605: -- Start Bugfix 2197842
7606:
7607: lStmtNumber := 261;
7608:
7609: insert into MTL_ITEM_CATEGORIES
7610: (inventory_item_id,
7611: category_set_id,
7612: category_id,
7613: last_update_date,

Line 7639: mtl_item_categories ic,

7635: NULL, -- program_id
7636: SYSDATE, -- program_update_date
7637: ic.organization_id
7638: from
7639: mtl_item_categories ic,
7640: mtl_category_sets_b mcsb,
7641: mtl_default_category_sets mdcs,
7642: bom_cto_src_orgs bcso
7643: where pModelId = ic.inventory_item_id

Line 7652: from MTL_ITEM_CATEGORIES

7648: and mdcs.functional_area_id = 2
7649: and NOT EXISTS
7650: (
7651: select NULL
7652: from MTL_ITEM_CATEGORIES
7653: where inventory_item_id = pConfigId
7654: and organization_id = bcso.organization_id
7655: and category_set_id = mcsb.category_set_id
7656: );

Line 7663: oe_debug_pub.add('Create_Item: ' || 'after insert: MTL_ITEM_CATEGORIES FOR DEFAULT CATEGORIES',2);

7659:
7660:
7661:
7662: IF PG_DEBUG <> 0 THEN
7663: oe_debug_pub.add('Create_Item: ' || 'after insert: MTL_ITEM_CATEGORIES FOR DEFAULT CATEGORIES',2);
7664: END IF;
7665:
7666: -- End Bugfix 2197842
7667: