64: IS
65: l_rows NUMBER := 0;
66: BEGIN
67:
68: INSERT /*+ append parallel(opi_dbi_inv_value_f) */ INTO opi_dbi_inv_value_f
69: (operating_unit_id,
70: organization_id,
71: subinventory_code,
72: inventory_item_id,
441: invlog.transaction_date transaction_date,
442: sum(onhand_value_b) dbi_onhand_value_b,
443: sum(intransit_value_b) dbi_intransit_value_b
444: FROM
445: opi_dbi_inv_value_f f,
446: opi_dbi_inv_value_log invlog
447: WHERE f.organization_id = invlog.organization_id
448: AND f.transaction_date < invlog.transaction_date + 1 -- include all txns on CPCSD First Period close date too
449: AND invlog.uncosted_trx_id = -99 -- Indicates that the organization needs lump-sum adjustment processing