APPS.GML_OPM_ROI_GRP dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 1441: FROM MTL_TRANSACTION_LOTS_TEMP

1437: l_lot_secondary_quantity ,
1438: l_reason_code ,
1439: l_vendor_lot_no_on_lot ,
1440: l_lot_desc
1441: FROM MTL_TRANSACTION_LOTS_TEMP
1442: WHERE rowid = p_mtlt_rowid ;
1443:
1444: l_progress := '030' ;
1445:

Line 1515: FROM MTL_TRANSACTION_LOTS_TEMP

1511: l_progress := '040' ;
1512: -- check for duplicate lots.
1513:
1514: SELECT count(1) INTO l_same_lot_count
1515: FROM MTL_TRANSACTION_LOTS_TEMP
1516: WHERE
1517: PRODUCT_CODE = 'RCV'
1518: AND PRODUCT_TRANSACTION_ID = l_rti_id
1519: AND Ltrim(Rtrim(lot_number)) = l_lot_no

Line 1530: FROM MTL_TRANSACTION_LOTS_TEMP

1526: RAISE FND_API.G_EXC_ERROR;
1527: END IF;
1528:
1529: SELECT count(1) INTO l_total_no_of_lots
1530: FROM MTL_TRANSACTION_LOTS_TEMP
1531: WHERE
1532: PRODUCT_CODE = 'RCV'
1533: AND PRODUCT_TRANSACTION_ID = l_rti_id ;
1534:

Line 1546: UPDATE mtl_transaction_lots_temp

1542: END IF;
1543:
1544: l_lot_secondary_quantity := l_rti_secondary_quantity ;
1545:
1546: UPDATE mtl_transaction_lots_temp
1547: SET secondary_quantity = l_lot_secondary_quantity
1548: WHERE rowid = p_mtlt_rowid ;
1549:
1550: END IF;

Line 1682: update mtl_transaction_lots_temp

1678: RAISE FND_API.G_EXC_ERROR;
1679: END IF;
1680:
1681: IF l_update_lot_qty THEN
1682: update mtl_transaction_lots_temp
1683: set secondary_quantity = l_lot_secondary_quantity
1684: where rowid = p_mtlt_rowid ;
1685: END IF;
1686: END IF; -- IF l_secondary_unit_of_measure IS NOT NULL THEN

Line 1867: update mtl_transaction_lots_temp

1863: RAISE FND_API.G_EXC_ERROR;
1864: END IF;
1865:
1866: IF l_update_lot_qty THEN
1867: update mtl_transaction_lots_temp
1868: set secondary_quantity = l_lot_secondary_quantity
1869: where rowid = p_mtlt_rowid ;
1870: END IF;
1871: END IF; -- IF l_secondary_unit_of_measure IS NOT NULL THEN

Line 1929: update mtl_transaction_lots_temp

1925: RAISE FND_API.G_EXC_ERROR;
1926: END IF;
1927:
1928: IF l_update_lot_qty THEN
1929: update mtl_transaction_lots_temp
1930: set secondary_quantity = l_lot_secondary_quantity
1931: where rowid = p_mtlt_rowid ;
1932: END IF;
1933: END IF; -- IF l_secondary_unit_of_measure IS NOT NULL THEN

Line 2183: update mtl_transaction_lots_temp

2179: RAISE FND_API.G_EXC_ERROR;
2180: END IF;
2181:
2182: IF l_update_lot_qty THEN
2183: update mtl_transaction_lots_temp
2184: set secondary_quantity = l_lot_secondary_quantity
2185: where rowid = p_mtlt_rowid ;
2186: END IF;
2187: END IF; -- IF l_secondary_unit_of_measure IS NOT NULL THEN

Line 2304: update mtl_transaction_lots_temp

2300: RAISE FND_API.G_EXC_ERROR;
2301: END IF;
2302:
2303: IF l_update_lot_qty THEN
2304: update mtl_transaction_lots_temp
2305: set secondary_quantity = l_lot_secondary_quantity
2306: where rowid = p_mtlt_rowid ;
2307: END IF;
2308: END IF; -- IF l_secondary_unit_of_measure IS NOT NULL THEN

Line 2400: update mtl_transaction_lots_temp

2396: RAISE FND_API.G_EXC_ERROR;
2397: END IF;
2398:
2399: IF l_update_lot_qty THEN
2400: update mtl_transaction_lots_temp
2401: set secondary_quantity = l_lot_secondary_quantity
2402: where rowid = p_mtlt_rowid ;
2403: END IF;
2404: END IF; -- IF l_secondary_unit_of_measure IS NOT NULL THEN

Line 2566: update mtl_transaction_lots_temp

2562: RAISE FND_API.G_EXC_ERROR;
2563: END IF;
2564:
2565: IF l_update_lot_qty THEN
2566: update mtl_transaction_lots_temp
2567: set secondary_quantity = l_lot_secondary_quantity
2568: where rowid = p_mtlt_rowid ;
2569: END IF;
2570: END IF; -- IF l_secondary_unit_of_measure IS NOT NULL THEN