APPS.QA_PLAN_ELEMENT_API dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 2215: FROM mtl_transaction_lots_temp

2211: RETURN BOOLEAN IS
2212:
2213: CURSOR c IS
2214: SELECT 1
2215: FROM mtl_transaction_lots_temp
2216: WHERE transaction_temp_id = x_transaction_id
2217: AND lot_number = x_lot_number;
2218:
2219: result BOOLEAN;

Line 2262: mtl_transaction_lots_temp mtlt

2258: --
2259: CURSOR c IS
2260: SELECT 1
2261: FROM mtl_serial_numbers msn,
2262: mtl_transaction_lots_temp mtlt
2263: WHERE msn.lot_line_mark_id = x_transaction_id
2264: AND mtlt.transaction_temp_id = msn.lot_line_mark_id
2265: AND mtlt.serial_transaction_temp_id = msn.line_mark_id
2266: AND mtlt.lot_number = x_lot_number

Line 3608: FROM mtl_transaction_lots_temp

3604: -- After Single Scan LOV
3605: wild := value;
3606:
3607: sql_string := 'SELECT lot_number, lot_expiration_date
3608: FROM mtl_transaction_lots_temp
3609: WHERE transaction_temp_id = :1
3610: AND lot_number like :2
3611: ORDER BY lot_number';
3612:

Line 3636: mtl_transaction_lots_temp mtlt

3632: -- bso Tue Jul 20 15:52:21 PDT 2004
3633: --
3634: sql_string := 'SELECT msn.serial_number, msn.current_status
3635: FROM mtl_serial_numbers msn,
3636: mtl_transaction_lots_temp mtlt
3637: WHERE msn.lot_line_mark_id = :1
3638: AND mtlt.transaction_temp_id = msn.lot_line_mark_id
3639: AND mtlt.serial_transaction_temp_id = msn.line_mark_id
3640: AND mtlt.lot_number = :2