APPS.INV_CALCULATE_EXP_DATE dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 358: , mtl_material_transactions_temp b

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

Line 402: , mtl_material_transactions_temp b

398: BEGIN /*begin segment 3*/
399: SELECT a.origination_date
400: INTO x_orig_date
401: FROM mtl_transaction_lots_temp a
402: , mtl_material_transactions_temp b
403: WHERE b.inventory_item_id = p_inventory_item_id
404: AND a.lot_number = p_lot_number
405: AND a.transaction_temp_id = b.transaction_temp_id
406: AND ROWNUM = 1

Line 466: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

462: PROCEDURE get_lot_expiration_date
463: ( p_mtli_lot_rec IN MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE
464: ,p_mti_trx_rec IN MTL_TRANSACTIONS_INTERFACE%ROWTYPE
465: ,p_mtlt_lot_rec IN MTL_TRANSACTION_LOTS_TEMP%ROWTYPE
466: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
467: ,p_table IN NUMBER
468: ,x_lot_expiration_date OUT NOCOPY DATE
469: ,x_return_status OUT NOCOPY VARCHAR2
470: ) IS

Line 894: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

890: PROCEDURE log_transaction_rec(
891: p_mtli_lot_rec IN MTL_TRANSACTION_LOTS_INTERFACE%ROWTYPE
892: ,p_mti_trx_rec IN MTL_TRANSACTIONS_INTERFACE%ROWTYPE
893: ,p_mtlt_lot_rec IN MTL_TRANSACTION_LOTS_TEMP%ROWTYPE
894: ,p_mmtt_trx_rec IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
895: ,p_table IN NUMBER
896: )IS
897: l_date_format VARCHAR2(30);
898: BEGIN