APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_ITEM_SUB_DEFAULTS

Line 2881: insert into mtl_item_sub_defaults

2877: +--------------------------------------*/
2878:
2879: lStmtNumber := 180;
2880:
2881: insert into mtl_item_sub_defaults
2882: (
2883: inventory_item_id,
2884: organization_id,
2885: subinventory_code,

Line 2913: mtl_item_sub_defaults sd,

2909: NULL, -- program_application_id
2910: NULL, -- program_id
2911: SYSDATE -- program_update_date
2912: from
2913: mtl_item_sub_defaults sd,
2914: bom_cto_src_orgs bcso,
2915: bom_cto_order_lines_upg bcolu
2916: where bcolu.config_item_id is not null
2917: and bcolu.status = 'BCSO'

Line 2924: from mtl_item_sub_defaults

2920: and bcso.model_item_id = bcolu.inventory_item_id
2921: and bcso.line_id = bcolu.line_id
2922: and NOT EXISTS
2923: (select NULL
2924: from mtl_item_sub_defaults
2925: where inventory_item_id = bcolu.config_item_id
2926: and organization_id = bcso.organization_id);
2927:
2928: WriteToLog('Inserted rows into mtl_item_sub_defaults:: '||sql%rowcount,2);

Line 2928: WriteToLog('Inserted rows into mtl_item_sub_defaults:: '||sql%rowcount,2);

2924: from mtl_item_sub_defaults
2925: where inventory_item_id = bcolu.config_item_id
2926: and organization_id = bcso.organization_id);
2927:
2928: WriteToLog('Inserted rows into mtl_item_sub_defaults:: '||sql%rowcount,2);
2929:
2930:
2931: /*--------------------------------------+
2932: Copy Locator Defaults