[Home] [Help]
1222: sy_uoms_mst ruom,
1223: gme_resource_txns rtran,
1224: cr_rsrc_dtl rdtl,
1225: cr_rsrc_mst_b rmst,
1226: gme_material_details prod,
1227: (
1228: SELECT gtv.transaction_id,
1229: gtv.accounted_flag,
1230: gtv.txn_base_value
1491: sy_uoms_mst ruom,
1492: gme_resource_txns rtran,
1493: cr_rsrc_dtl rdtl,
1494: cr_rsrc_mst_b rmst,
1495: gme_material_details prod,
1496: (
1497: SELECT gtv.transaction_id,
1498: gtv.accounted_flag,
1499: gtv.txn_base_value
1823: job.job_type,
1824: job.source
1825: FROM opi_dbi_jobs_f job,
1826: mtl_system_items_b msi,
1827: gme_material_details bmatl
1828: WHERE job.job_type = 4
1829: AND job.std_res_flag = 1
1830: AND bmatl.batch_id = job.job_id
1831: AND bmatl.line_type = 1 -- coproducts
2046: job.source
2047: FROM
2048: opi_dbi_jobs_f job,
2049: mtl_system_items_b msi,
2050: gme_material_details bmatl
2051: WHERE
2052: job.job_type = 4
2053: AND job.std_res_flag = 1
2054: AND bmatl.batch_id = job.job_id