272: PROCEDURE Cost_Inception_Quantities
273: IS
274: BEGIN
275:
276: INSERT INTO opi_pmi_cost_param_gtmp
277: (whse_code, orgn_code, item_id, trans_date)
278: SELECT
279: DISTINCT q.whse_code, w.orgn_code, q.item_id, id.transaction_date
280: FROM
291: AND id.organization_id = c.organization_id;
292:
293: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' cost parameter rows inserted.');
294:
295: opi_pmi_cost.get_cost;
296:
297: EXCEPTION
298: WHEN OTHERS
299: THEN
334: SUM(DECODE(q.type, 1, q.quantity * c.total_cost, 0)) onhand_value_b,
335: SUM(DECODE(q.type, 2, q.quantity * c.total_cost, 0)) intransit_value_b
336: FROM
337: opi_dbi_opm_inception_qty q,
338: opi_pmi_cost_result_gtmp c,
339: ic_item_mst_b iim,
340: ic_whse_mst w,
341: mtl_system_items_b msi
342: WHERE