APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_ITEM_SUB_DEFAULTS

Line 8070: insert into mtl_item_sub_defaults

8066: +--------------------------------------*/
8067:
8068: lStmtNumber := 301;
8069:
8070: insert into mtl_item_sub_defaults
8071: (
8072: inventory_item_id,
8073: organization_id,
8074: subinventory_code,

Line 8101: mtl_item_sub_defaults sd,

8097: NULL, -- program_application_id
8098: NULL, -- program_id
8099: SYSDATE -- program_update_date
8100: from
8101: mtl_item_sub_defaults sd,
8102: bom_cto_src_orgs bcso
8103: where sd.organization_id = bcso.organization_id
8104: and sd.inventory_item_id = pModelId
8105: and bcso.model_item_id = pModelId

Line 8109: from mtl_item_sub_defaults

8105: and bcso.model_item_id = pModelId
8106: and bcso.line_id = pLineId
8107: and NOT EXISTS
8108: (select NULL
8109: from mtl_item_sub_defaults
8110: where inventory_item_id = pConfigId
8111: and organization_id = bcso.organization_id);
8112:
8113:

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

8111: and organization_id = bcso.organization_id);
8112:
8113:
8114: IF PG_DEBUG <> 0 THEN
8115: oe_debug_pub.add('Create_Item: ' || 'after insert: mtl_item_sub_defaults',2);
8116: END IF;
8117:
8118: -- end 2461574
8119: -- start 2786934