[Home] [Help]
449: CURSOR c_batch_products (c_batch_id NUMBER) IS
450: SELECT m.material_detail_id, m.inventory_item_id as item_id, m.organization_id,
451: decode(m.plan_qty, 0, nvl(m.wip_plan_qty,0), m.plan_qty) prod_plan_qty,
452: m.cost_alloc, s.batchstep_id
453: FROM gme_material_details m, gme_batch_step_items s
454: WHERE m.batch_id = c_batch_id AND
455: m.line_type = 1 AND
456: m.material_detail_id = s.material_detail_id and
457: decode(m.plan_qty, 0, m.wip_plan_qty, m.plan_qty) <> 0 and
509: /* Bug 6125370 - Start: Validate product lines*/
510: l_count := 0;
511: SELECT count(*)
512: INTO l_count
513: FROM gme_material_details m
514: WHERE m.batch_id = p_batch_id AND
515: m.line_type = 1 AND
516: decode(m.plan_qty, 0, m.wip_plan_qty, m.plan_qty) <> 0 AND
517: nvl(m.cost_alloc,0) <> 0;
607: gmf_vib_id_s.nextval,
608: p.organization_id,
609: l_vib_profile_value
610: FROM gme_batch_step_items s,
611: gme_material_details m
612: WHERE batchstep_id = ds.dep_step_id AND
613: s.material_detail_id = m.material_detail_id AND
614: m.line_type <> 1;
615:
705: NULL,
706: gmf_vib_id_s.nextval,
707: p.organization_id,
708: l_vib_profile_value
709: FROM gme_material_details p, gme_material_details i
710: WHERE
711: p.batch_id = p_batch_id AND
712: i.batch_id = p_batch_id AND
713: p.line_type = 1 AND
767: NULL,
768: gmf_vib_id_s.nextval,
769: p.organization_id,
770: l_vib_profile_value
771: FROM gme_material_details p, gme_batch_step_resources r, gme_batch_steps s
772: WHERE
773: p.batch_id = p_batch_id AND
774: s.batch_id = p_batch_id AND
775: s.batchstep_id = r.batchstep_id AND
831: NULL,
832: gmf_vib_id_s.nextval,
833: p.organization_id,
834: l_vib_profile_value
835: FROM gme_material_details p, gme_material_details i
836: WHERE
837: p.batch_id = p_batch_id AND
838: i.batch_id = p_batch_id AND
839: p.line_type = 1 AND
895: NULL,
896: gmf_vib_id_s.nextval,
897: p.organization_id,
898: l_vib_profile_value
899: FROM gme_material_details p, gme_batch_step_resources r, gme_batch_steps s
900: WHERE
901: p.batch_id = p_batch_id AND
902: s.batch_id = p_batch_id AND
903: s.batchstep_id = r.batchstep_id AND
1081: mmt.transaction_date, md.line_type, tp.transaction_id2 as reverse_id, l.ROWID, l.*
1082: FROM gmf_outgoing_material_layers l,
1083: mtl_material_transactions mmt,
1084: mtl_system_items_b msi,
1085: gme_material_details md,
1086: gme_transaction_pairs tp
1087: WHERE
1088: mmt.transaction_source_type_id = 5 AND
1089: mmt.transaction_source_id = p_tran_rec.transaction_source_id AND
1102: SELECT count(*)
1103: FROM gmf_outgoing_material_layers l,
1104: mtl_material_transactions mmt,
1105: mtl_system_items_b msi,
1106: gme_material_details md,
1107: gme_transaction_pairs tp
1108: WHERE
1109: mmt.transaction_source_type_id = 5 AND
1110: mmt.transaction_source_id = p_tran_rec.transaction_source_id AND
1720: IF req.ing_material_detail_id IS NOT NULL THEN
1721:
1722: SELECT m.dtl_um, m.line_type, i.primary_uom_code
1723: INTO l_doc_um, l_line_type, l_item_um
1724: FROM gme_material_details m, mtl_system_items_b i
1725: WHERE
1726: m.batch_id = req.batch_id AND
1727: m.material_detail_id = req.ing_material_detail_id AND
1728: i.inventory_item_id = m.inventory_item_id AND
1906: SELECT l.layer_id, l.layer_doc_um, l.remaining_ib_doc_qty, t.inventory_item_id, t.transaction_date,
1907: NULL lot_number, md.line_type, t.primary_quantity, msi.primary_uom_code, l.ROWID, tp.transaction_id2 as reverse_id,
1908: l.layer_doc_qty
1909: FROM gmf_outgoing_material_layers l, mtl_material_transactions t,
1910: gme_material_details md,
1911: mtl_system_items_b msi, gme_transaction_pairs tp
1912: WHERE
1913: t.trx_source_line_id = p_ing_material_detail_id AND
1914: t.transaction_source_id = p_batch_id AND