APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_PENDING_ITEM_STATUS

Line 6366: in the MTL_PENDING_ITEM_STATUS

6362:
6363:
6364: /*------------------------------------------+
6365: Create rows for config items
6366: in the MTL_PENDING_ITEM_STATUS
6367: +------------------------------------------*/
6368:
6369: lStmtNumber := 205;
6370:

Line 6375: insert into MTL_PENDING_ITEM_STATUS (

6371: IF PG_DEBUG <> 0 THEN
6372: oe_debug_pub.add ('Create_Item: ' || 'Validation Org is :' || lValidationOrg ,2);
6373: END IF;
6374:
6375: insert into MTL_PENDING_ITEM_STATUS (
6376: inventory_item_id,
6377: organization_id,
6378: status_code,
6379: effective_date,

Line 6413: from MTL_PENDING_ITEM_STATUS

6409: and bcso.line_id = pLineId
6410: and m.organization_id = bcso.organization_id
6411: and NOT EXISTS
6412: (select NULL
6413: from MTL_PENDING_ITEM_STATUS
6414: where inventory_item_id = pConfigId
6415: and organization_id = m.organization_id);
6416:
6417:

Line 6420: oe_debug_pub.add('Create_Item: ' || 'after insert:MTL_PENDING_ITEM_STATUS',2);

6416:
6417:
6418:
6419: IF PG_DEBUG <> 0 THEN
6420: oe_debug_pub.add('Create_Item: ' || 'after insert:MTL_PENDING_ITEM_STATUS',2);
6421: END IF;
6422:
6423: /*-------------------------------------------+
6424: Insert Item revision information