APPS.GMF_VIB dependencies on GME_MATERIAL_DETAILS

Line 452: FROM gme_material_details m, gme_batch_step_items s

448: CURSOR c_batch_products (c_batch_id NUMBER) IS
449: SELECT m.material_detail_id, m.inventory_item_id as item_id, m.organization_id,
450: decode(m.plan_qty, 0, nvl(m.wip_plan_qty,0), m.plan_qty) prod_plan_qty,
451: m.cost_alloc, s.batchstep_id
452: FROM gme_material_details m, gme_batch_step_items s
453: WHERE m.batch_id = c_batch_id AND
454: m.line_type = 1 AND
455: m.material_detail_id = s.material_detail_id and
456: decode(m.plan_qty, 0, m.wip_plan_qty, m.plan_qty) <> 0 and

Line 511: FROM gme_material_details m

507: /* Bug 6125370 - Start: Validate product lines*/
508: l_count := 0;
509: SELECT count(*)
510: INTO l_count
511: FROM gme_material_details m
512: WHERE m.batch_id = p_batch_id AND
513: m.line_type = 1 AND
514: decode(m.plan_qty, 0, m.wip_plan_qty, m.plan_qty) <> 0 AND
515: nvl(m.cost_alloc,0) <> 0;

Line 602: gme_material_details m

598: gmf_vib_id_s.nextval,
599: p.organization_id,
600: l_vib_profile_value
601: FROM gme_batch_step_items s,
602: gme_material_details m
603: WHERE batchstep_id = ds.dep_step_id AND
604: s.material_detail_id = m.material_detail_id AND
605: m.line_type <> 1;
606:

Line 700: FROM gme_material_details p, gme_material_details i

696: NULL,
697: gmf_vib_id_s.nextval,
698: p.organization_id,
699: l_vib_profile_value
700: FROM gme_material_details p, gme_material_details i
701: WHERE
702: p.batch_id = p_batch_id AND
703: i.batch_id = p_batch_id AND
704: p.line_type = 1 AND

Line 761: FROM gme_material_details p, gme_batch_step_resources r

757: NULL,
758: gmf_vib_id_s.nextval,
759: p.organization_id,
760: l_vib_profile_value
761: FROM gme_material_details p, gme_batch_step_resources r
762: WHERE
763: p.batch_id = p_batch_id AND
764: r.batch_id = p_batch_id AND
765: p.line_type = 1 AND

Line 824: FROM gme_material_details p, gme_material_details i

820: NULL,
821: gmf_vib_id_s.nextval,
822: p.organization_id,
823: l_vib_profile_value
824: FROM gme_material_details p, gme_material_details i
825: WHERE
826: p.batch_id = p_batch_id AND
827: i.batch_id = p_batch_id AND
828: p.line_type = 1 AND

Line 885: FROM gme_material_details p, gme_batch_step_resources r

881: NULL,
882: gmf_vib_id_s.nextval,
883: p.organization_id,
884: l_vib_profile_value
885: FROM gme_material_details p, gme_batch_step_resources r
886: WHERE
887: p.batch_id = p_batch_id AND
888: r.batch_id = p_batch_id AND
889: p.line_type = 1 AND

Line 1070: gme_material_details md,

1066: FROM gmf_outgoing_material_layers l,
1067: mtl_material_transactions mmt,
1068: mtl_transaction_lot_numbers mtln,
1069: mtl_system_items_b msi,
1070: gme_material_details md,
1071: gme_transaction_pairs tp
1072: WHERE
1073: mmt.transaction_source_type_id = 5 AND
1074: mmt.transaction_source_id = p_tran_rec.transaction_source_id AND

Line 1664: FROM gme_material_details m, mtl_system_items_b i

1660: IF req.ing_material_detail_id IS NOT NULL THEN
1661:
1662: SELECT m.dtl_um, m.line_type, i.primary_uom_code
1663: INTO l_doc_um, l_line_type, l_item_um
1664: FROM gme_material_details m, mtl_system_items_b i
1665: WHERE
1666: m.batch_id = req.batch_id AND
1667: m.material_detail_id = req.ing_material_detail_id AND
1668: i.inventory_item_id = m.inventory_item_id AND

Line 1849: mtl_transaction_lot_numbers mtln, gme_material_details md,

1845: SELECT l.layer_id, l.layer_doc_um, l.remaining_ib_doc_qty, t.inventory_item_id, t.transaction_date,
1846: mtln.lot_number, md.line_type, t.primary_quantity, msi.primary_uom_code, l.ROWID, tp.transaction_id2 as reverse_id,
1847: l.layer_doc_qty
1848: FROM gmf_outgoing_material_layers l, mtl_material_transactions t,
1849: mtl_transaction_lot_numbers mtln, gme_material_details md,
1850: mtl_system_items_b msi, gme_transaction_pairs tp
1851: WHERE
1852: t.trx_source_line_id = p_ing_material_detail_id AND
1853: t.transaction_source_id = p_batch_id AND