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 387: --l_origination_type mtl_lot_numbers.origination_type%TYPE;

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

Line 388: --l_lot_rec_type mtl_lot_numbers%ROWTYPE;

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

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

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

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

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

Line 719: mtl_lot_numbers mln

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