APPS.INVTTMTX dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 352: mtl_transaction_lots_temp

348: END ;
349:
350: DECLARE
351: cursor c4 is select group_header_id from
352: mtl_transaction_lots_temp
353: where group_header_id = v_trx_header_id
354: for update of group_header_id nowait;
355: BEGIN
356: open c4 ;

Line 357: delete mtl_transaction_lots_temp

353: where group_header_id = v_trx_header_id
354: for update of group_header_id nowait;
355: BEGIN
356: open c4 ;
357: delete mtl_transaction_lots_temp
358: where group_header_id = v_trx_header_id;
359: close c4 ;
360: EXCEPTION
361: WHEN OTHERS then

Line 407: DELETE FROM mtl_transaction_lots_temp

403: if ( (hdr_id IS NULL) OR (hdr_id < 0) ) then
404: completed := 1;
405: else
406: BEGIN
407: DELETE FROM mtl_transaction_lots_temp
408: WHERE group_header_id = hdr_id AND
409: transaction_temp_id NOT IN
410: (SELECT mmtt.transaction_temp_id FROM
411: mtl_material_transactions_temp mmtt

Line 424: FROM mtl_transaction_lots_temp mtlt

420: mtl_material_transactions_temp mmtt
421: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.transaction_temp_id
422: IS NOT NULL) AND transaction_temp_id NOT IN
423: ( SELECT mtlt.serial_transaction_temp_id
424: FROM mtl_transaction_lots_temp mtlt
425: WHERE mtlt.group_header_id = hdr_id
426: AND mtlt.serial_transaction_temp_id IS NOT NULL);
427:
428: completed := 1;

Line 499: /* INSERT INTO MTL_TRANSACTION_LOTS_TEMP

495: *************************************************************************************************************** */
496:
497: /** INVCONV Anand Thiyagarajan 02-Nov-2004 End **/
498:
499: /* INSERT INTO MTL_TRANSACTION_LOTS_TEMP
500: ( transaction_temp_id, last_update_date, last_updated_by, creation_date,
501: created_by, last_update_login, request_id, program_application_id,
502: program_id, program_update_date, transaction_quantity, primary_quantity,
503: lot_number, lot_expiration_date, group_header_id,

Line 521: INSERT INTO MTL_TRANSACTION_LOTS_TEMP

517: AND msi.inventory_item_id = mmtt.inventory_item_id
518: AND msi.organization_id = mmtt.organization_id) ; */
519:
520:
521: INSERT INTO MTL_TRANSACTION_LOTS_TEMP
522: ( transaction_temp_id, last_update_date, last_updated_by, creation_date,
523: created_by, last_update_login, request_id, program_application_id,
524: program_id, program_update_date, transaction_quantity, primary_quantity,
525: lot_number, lot_expiration_date, group_header_id,

Line 729: UPDATE mtl_transaction_lots_temp

725: and mln.organization_id(+) = mmtt.organization_id
726: and mln.lot_number(+) =mmtt.lot_number);
727:
728: -- The quantity in mtlt should always be positive
729: UPDATE mtl_transaction_lots_temp
730: SET primary_quantity = -1 * primary_quantity ,
731: transaction_quantity = -1 * transaction_quantity ,
732: secondary_quantity = -1 * secondary_quantity /* INVCONV Anand Thiyagarajan 22-Oct-2004*/
733: WHERE transaction_temp_id in