APPS.INV_CALCULATE_EXP_DATE dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 357: , mtl_material_transactions_temp b

353: BEGIN /*begin segment 3*/
354: SELECT a.origination_date
355: INTO x_orig_date
356: FROM mtl_transaction_lots_temp a
357: , mtl_material_transactions_temp b
358: WHERE b.inventory_item_id = p_inventory_item_id
359: AND a.lot_number = p_lot_number
360: AND a.transaction_temp_id = b.transaction_temp_id
361: AND ROWNUM = 1

Line 421: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

417: PROCEDURE get_lot_expiration_date
418: ( p_mtli_lot_rec IN MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE
419: ,p_mti_trx_rec IN MTL_TRANSACTIONS_INTERFACE%ROWTYPE
420: ,p_mtlt_lot_rec IN MTL_TRANSACTION_LOTS_TEMP%ROWTYPE
421: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
422: ,p_table IN NUMBER
423: ,x_lot_expiration_date OUT NOCOPY DATE
424: ,x_return_status OUT NOCOPY VARCHAR2
425: ) IS

Line 849: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

845: PROCEDURE log_transaction_rec(
846: p_mtli_lot_rec IN MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE
847: ,p_mti_trx_rec IN MTL_TRANSACTIONS_INTERFACE%ROWTYPE
848: ,p_mtlt_lot_rec IN MTL_TRANSACTION_LOTS_TEMP%ROWTYPE
849: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
850: ,p_table IN NUMBER
851: )IS
852: l_date_format VARCHAR2(30);
853: BEGIN