APPS.CTO_CONFIG_ITEM_PK dependencies on MTL_PENDING_ITEM_STATUS

Line 6181: in the MTL_PENDING_ITEM_STATUS

6177:
6178:
6179: /*------------------------------------------+
6180: Create rows for config items
6181: in the MTL_PENDING_ITEM_STATUS
6182: +------------------------------------------*/
6183:
6184: lStmtNumber := 205;
6185:

Line 6190: insert into MTL_PENDING_ITEM_STATUS (

6186: IF PG_DEBUG <> 0 THEN
6187: oe_debug_pub.add ('Create_Item: ' || 'Validation Org is :' || lValidationOrg ,2);
6188: END IF;
6189:
6190: insert into MTL_PENDING_ITEM_STATUS (
6191: inventory_item_id,
6192: organization_id,
6193: status_code,
6194: effective_date,

Line 6228: from MTL_PENDING_ITEM_STATUS

6224: and bcso.line_id = pLineId
6225: and m.organization_id = bcso.organization_id
6226: and NOT EXISTS
6227: (select NULL
6228: from MTL_PENDING_ITEM_STATUS
6229: where inventory_item_id = pConfigId
6230: and organization_id = m.organization_id);
6231:
6232:

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

6231:
6232:
6233:
6234: IF PG_DEBUG <> 0 THEN
6235: oe_debug_pub.add('Create_Item: ' || 'after insert:MTL_PENDING_ITEM_STATUS',2);
6236: END IF;
6237:
6238: /*-------------------------------------------+
6239: Insert Item revision information