APPS.CTO_UPDATE_ITEMS_PK dependencies on MTL_PENDING_ITEM_STATUS

Line 1060: insert into MTL_PENDING_ITEM_STATUS (

1056:
1057: WriteToLog('Inserted rows into mtl_system_items_tl:: '||sql%rowcount,2);
1058:
1059: lStmtNumber := 20;
1060: insert into MTL_PENDING_ITEM_STATUS (
1061: inventory_item_id,
1062: organization_id,
1063: status_code,
1064: effective_date,

Line 1102: from MTL_PENDING_ITEM_STATUS

1098: and bcso.line_id = bcolu.line_id
1099: and m.organization_id = bcso.organization_id
1100: and NOT EXISTS
1101: (select NULL
1102: from MTL_PENDING_ITEM_STATUS
1103: where inventory_item_id = bcolu.config_item_id
1104: and organization_id = bcso.organization_id);
1105:
1106: WriteToLog('Inserted rows into mtl_pending_item_status:: '||sql%rowcount,2);

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

1102: from MTL_PENDING_ITEM_STATUS
1103: where inventory_item_id = bcolu.config_item_id
1104: and organization_id = bcso.organization_id);
1105:
1106: WriteToLog('Inserted rows into mtl_pending_item_status:: '||sql%rowcount,2);
1107:
1108: /*-------------------------------------------+
1109: Insert Item revision information
1110: Till Patchset I, this information was inserted into mtl_item_revisions table.