APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ITEM_SUB_DEFAULTS

Line 7885: insert into mtl_item_sub_defaults

7881: +--------------------------------------*/
7882:
7883: lStmtNumber := 301;
7884:
7885: insert into mtl_item_sub_defaults
7886: (
7887: inventory_item_id,
7888: organization_id,
7889: subinventory_code,

Line 7916: mtl_item_sub_defaults sd,

7912: NULL, -- program_application_id
7913: NULL, -- program_id
7914: SYSDATE -- program_update_date
7915: from
7916: mtl_item_sub_defaults sd,
7917: bom_cto_src_orgs bcso
7918: where sd.organization_id = bcso.organization_id
7919: and sd.inventory_item_id = pModelId
7920: and bcso.model_item_id = pModelId

Line 7924: from mtl_item_sub_defaults

7920: and bcso.model_item_id = pModelId
7921: and bcso.line_id = pLineId
7922: and NOT EXISTS
7923: (select NULL
7924: from mtl_item_sub_defaults
7925: where inventory_item_id = pConfigId
7926: and organization_id = bcso.organization_id);
7927:
7928:

Line 7930: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_item_sub_defaults',2);

7926: and organization_id = bcso.organization_id);
7927:
7928:
7929: IF PG_DEBUG <> 0 THEN
7930: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_item_sub_defaults',2);
7931: END IF;
7932:
7933: -- end 2461574
7934: -- start 2786934