APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_PENDING_ITEM_STATUS

Line 1203: insert into MTL_PENDING_ITEM_STATUS (

1199:
1200: WriteToLog('Inserted rows into mtl_system_items_tl:: '||sql%rowcount,2);
1201:
1202: lStmtNumber := 20;
1203: insert into MTL_PENDING_ITEM_STATUS (
1204: inventory_item_id,
1205: organization_id,
1206: status_code,
1207: effective_date,

Line 1245: from MTL_PENDING_ITEM_STATUS

1241: and bcso.line_id = bcolu.line_id
1242: and m.organization_id = bcso.organization_id
1243: and NOT EXISTS
1244: (select NULL
1245: from MTL_PENDING_ITEM_STATUS
1246: where inventory_item_id = bcolu.config_item_id
1247: and organization_id = bcso.organization_id);
1248:
1249: WriteToLog('Inserted rows into mtl_pending_item_status:: '||sql%rowcount,2);

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

1245: from MTL_PENDING_ITEM_STATUS
1246: where inventory_item_id = bcolu.config_item_id
1247: and organization_id = bcso.organization_id);
1248:
1249: WriteToLog('Inserted rows into mtl_pending_item_status:: '||sql%rowcount,2);
1250:
1251: /*-------------------------------------------+
1252: Insert Item revision information
1253: Till Patchset I, this information was inserted into mtl_item_revisions table.