DBA Data[Home] [Help]

APPS.INV_CG_UPGRADE dependencies on MTL_PER_CLOSE_DTLS

Line 343: from mtl_per_close_dtls

339: acct_period_id
340: , 1 inventory_type
341: , cost_group_id
342: , sum(NVL(period_end_unit_cost,0)*NVL(period_end_quantity,0)) inventory_value
343: from mtl_per_close_dtls
344: where organization_id = l_organization_id
345: group by
346: acct_period_id
347: , organization_id

Line 428: update mtl_per_close_dtls

424: update mtl_period_summary
425: set cost_group_id = l_cost_group_id
426: where rowid = l_rowid;
427: if ( l_details_updated = FALSE ) then
428: update mtl_per_close_dtls
429: set cost_group_id = l_cost_group_id
430: where organization_id = l_organization_id
431: and cost_group_id = 1 ;
432: l_details_updated := TRUE ;