DBA Data[Home] [Help]

APPS.INV_LABEL_PVT13 dependencies on GMD_OPERATIONS

Line 164: from gme_batch_steps gbs, gme_batch_step_items gbsi, gmd_operations go

160: bl.dtl_um item_uom,
161: bl.actual_qty actual_quantity,
162:
163: (select batchstep_no || '-' || go.oprn_no
164: from gme_batch_steps gbs, gme_batch_step_items gbsi, gmd_operations go
165: where gbs.batch_id = bh.batch_id
166: and gbsi.batchstep_id = gbs.batchstep_id
167: and gbsi.material_detail_id = bl.material_detail_id
168: and go.oprn_id = gbs.oprn_id) batch_line

Line 223: from gme_batch_steps gbs, gme_batch_step_items gbsi, gmd_operations go

219: bl.actual_qty actual_quantity ,
220: hzc.hazard_class hazard_class,
221: mtln.lot_number,
222: (select batchstep_no || '-' || go.oprn_no
223: from gme_batch_steps gbs, gme_batch_step_items gbsi, gmd_operations go
224: where gbs.batch_id = bh.batch_id
225: and gbsi.batchstep_id = gbs.batchstep_id
226: and gbsi.material_detail_id = bl.material_detail_id
227: and go.oprn_id = gbs.oprn_id) batch_line,

Line 290: from gme_batch_steps gbs, gme_batch_step_items gbsi, gmd_operations go

286: bl.actual_qty actual_quantity ,
287: hzc.hazard_class hazard_class,
288: gppl.lot_number,
289: (select batchstep_no || '-' || go.oprn_no
290: from gme_batch_steps gbs, gme_batch_step_items gbsi, gmd_operations go
291: where gbs.batch_id = bh.batch_id
292: and gbsi.batchstep_id = gbs.batchstep_id
293: and gbsi.material_detail_id = bl.material_detail_id
294: and go.oprn_id = gbs.oprn_id) batch_line