25: PROCEDURE pre_r12_opm_res_actual (errbuf IN OUT NOCOPY VARCHAR2,
26: retcode IN OUT NOCOPY VARCHAR2) IS
27:
28: l_rowcount NUMBER;
29: g_hr_uom sy_uoms_mst.um_code%TYPE;
30:
31: BEGIN
32:
33: retcode := 0;
67: rtran.doc_id job_id,
68: 4 job_type,
69: prod.inventory_item_id assembly_item_id,
70: rmst.resource_class department_id
71: FROM sy_uoms_mst hruom,
72: sy_uoms_mst ruom,
73: gme_resource_txns rtran,
74: cr_rsrc_dtl rdtl,
75: cr_rsrc_mst_b rmst,
68: 4 job_type,
69: prod.inventory_item_id assembly_item_id,
70: rmst.resource_class department_id
71: FROM sy_uoms_mst hruom,
72: sy_uoms_mst ruom,
73: gme_resource_txns rtran,
74: cr_rsrc_dtl rdtl,
75: cr_rsrc_mst_b rmst,
76: gme_material_details prod,