APPS.GMD_QMSMC dependencies on GME_PENDING_PRODUCT_LOTS

Line 2438: from mtl_lot_numbers mln, gme_material_details d, GME_PENDING_PRODUCT_LOTS ppl

2434: -- old cursor was bringing back too many rows and was not using org id and item id in query so the wrong lot information was being returned
2435:
2436: CURSOR Cur_pending_lot(x_material_detail_id number) is
2437: select mln.lot_number, mln.parent_lot_number
2438: from mtl_lot_numbers mln, gme_material_details d, GME_PENDING_PRODUCT_LOTS ppl
2439: where mln.lot_number = ppl.lot_number
2440: and ppl.material_detail_id = x_material_detail_id
2441: and ppl.material_detail_id = d.material_detail_id
2442: and d.organization_id = mln.organization_id

Line 2452: from GME_PENDING_PRODUCT_LOTS

2448: select mln.lot_number, mln.parent_lot_number
2449: from mtl_lot_numbers mln
2450: where lot_number =
2451: (select lot_number
2452: from GME_PENDING_PRODUCT_LOTS
2453: where material_detail_id = x_material_detail_id
2454: and pending_product_lot_id =
2455: (select min(pending_product_lot_id)
2456: from GME_PENDING_PRODUCT_LOTS

Line 2456: from GME_PENDING_PRODUCT_LOTS

2452: from GME_PENDING_PRODUCT_LOTS
2453: where material_detail_id = x_material_detail_id
2454: and pending_product_lot_id =
2455: (select min(pending_product_lot_id)
2456: from GME_PENDING_PRODUCT_LOTS
2457: where material_detail_id = x_material_detail_id));
2458:
2459:
2460: Bug No.8942353 - End */