[Home] [Help]
756: --* *
757: --* Each material transaction consists of data from ic_tran_pnd and a cost table which is *
758: --* in the same format as the inherited costs *
759: --* *
760: --* Each resource transaction consists of data from gme_resource_txns and a cost table which *
761: --* which is in the same format as the inherited costs *
762: --* *
763: --* Each step dependency consists of inherited step qty, step_qty_uom and the index of the *
764: --* dependent step in the structure. *
1279: CAST (MULTISET (SELECT SYSTEM.gmf_cost_type (0, ' ', 0, 0, 0)
1280: FROM DUAL) AS SYSTEM.gmf_cost_tab
1281: ) -- Bug 7317270
1282: )
1283: FROM gme_resource_txns grt,
1284: gme_batch_step_resources gbsr
1285: WHERE gbsr.batch_id = p_batch_id
1286: AND gbsr.batchstep_id = p_batchstep_id
1287: AND gbsr.batchstep_resource_id = grt.line_id