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.EAM_MTL_TXN_PROCESS dependencies on MTL_LOT_NUMBERS

Line 520: From mtl_lot_numbers

516: if(p_lot_ctrl_code <> 1 and p_lot_num IS NOT NULL) then
517: Begin
518: select count(*)
519: into l_lotcount
520: From mtl_lot_numbers
521: where organization_id = p_org_id
522: and inventory_item_id = p_item_id
523: and lot_number = p_lot_num;
524:

Line 527: -- selecting the lot attribute values from the mtl_lot_numbers

523: and lot_number = p_lot_num;
524:
525: if( l_lotcount > 0 ) then
526:
527: -- selecting the lot attribute values from the mtl_lot_numbers
528:
529: SELECT
530: supplier_lot_number,
531: attribute_category ,

Line 647: FROM mtl_lot_numbers

643: l_n_attribute7 ,
644: l_n_attribute8 ,
645: l_n_attribute9 ,
646: l_n_attribute10
647: FROM mtl_lot_numbers
648: WHERE lot_number = p_lot_num
649: AND inventory_item_id = p_item_id
650: AND organization_id = p_org_id ;
651: