eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INVTTMTX dependencies on MTL_LOT_NUMBERS

Line 384: --l_origination_type mtl_lot_numbers.origination_type%TYPE;

380: varibales no longer needed are commented */
381:
382: --l_transaction_Action_id mtl_material_transactions_temp.transaction_action_id%TYPE;
383: --l_transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE;
384: --l_origination_type mtl_lot_numbers.origination_type%TYPE;
385: --l_lot_rec_type mtl_lot_numbers%ROWTYPE;
386: --l_organization_id mtl_lot_numbers.organization_id%TYPE;
387: --l_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE;
388: --l_transaction_date DATE;

Line 385: --l_lot_rec_type mtl_lot_numbers%ROWTYPE;

381:
382: --l_transaction_Action_id mtl_material_transactions_temp.transaction_action_id%TYPE;
383: --l_transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE;
384: --l_origination_type mtl_lot_numbers.origination_type%TYPE;
385: --l_lot_rec_type mtl_lot_numbers%ROWTYPE;
386: --l_organization_id mtl_lot_numbers.organization_id%TYPE;
387: --l_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE;
388: --l_transaction_date DATE;
389: --l_expiration_date DATE;

Line 386: --l_organization_id mtl_lot_numbers.organization_id%TYPE;

382: --l_transaction_Action_id mtl_material_transactions_temp.transaction_action_id%TYPE;
383: --l_transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE;
384: --l_origination_type mtl_lot_numbers.origination_type%TYPE;
385: --l_lot_rec_type mtl_lot_numbers%ROWTYPE;
386: --l_organization_id mtl_lot_numbers.organization_id%TYPE;
387: --l_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE;
388: --l_transaction_date DATE;
389: --l_expiration_date DATE;
390: --l_return_status VARCHAR2(1) ;

Line 387: --l_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE;

383: --l_transaction_source_type_id mtl_material_transactions_temp.transaction_source_type_id%TYPE;
384: --l_origination_type mtl_lot_numbers.origination_type%TYPE;
385: --l_lot_rec_type mtl_lot_numbers%ROWTYPE;
386: --l_organization_id mtl_lot_numbers.organization_id%TYPE;
387: --l_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE;
388: --l_transaction_date DATE;
389: --l_expiration_date DATE;
390: --l_return_status VARCHAR2(1) ;
391: --l_msg_data VARCHAR2(3000) ;

Line 716: mtl_lot_numbers mln

712: , mmtt.reason_id
713: /* INVCONV Anand Thiyagarajan 22-Oct-2004 End */
714: FROM mtl_material_transactions_temp mmtt,
715: mtl_system_items msi,
716: mtl_lot_numbers mln
717: WHERE mmtt.transaction_header_id = hdr_id AND mmtt.lot_number IS
718: NOT NULL AND mmtt.transaction_header_id IS NOT NULL
719: AND msi.inventory_item_id = mmtt.inventory_item_id
720: AND msi.organization_id = mmtt.organization_id