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

Line 1647: INSERT INTO mtl_lot_numbers

1643:
1644: -- Lot number does not exist
1645: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1646:
1647: INSERT INTO mtl_lot_numbers
1648: (INVENTORY_ITEM_ID
1649: ,ORGANIZATION_ID
1650: ,LOT_NUMBER
1651: ,LAST_UPDATE_DATE

Line 1918: FROM MTL_LOT_NUMBERS

1914:
1915: IF l_lotunique = 1 then
1916: SELECT count(1)
1917: INTO l_count
1918: FROM MTL_LOT_NUMBERS
1919: WHERE inventory_item_id <> l_item_id
1920: AND lot_number = p_lot_number
1921: AND NOT EXISTS( SELECT NULL
1922: FROM mtl_lot_numbers lot

Line 1922: FROM mtl_lot_numbers lot

1918: FROM MTL_LOT_NUMBERS
1919: WHERE inventory_item_id <> l_item_id
1920: AND lot_number = p_lot_number
1921: AND NOT EXISTS( SELECT NULL
1922: FROM mtl_lot_numbers lot
1923: WHERE lot.lot_number = p_lot_number
1924: AND lot.organization_id = l_org_id
1925: AND lot.inventory_item_id = l_item_id);
1926:

Line 1939: FROM mtl_lot_numbers

1935:
1936:
1937: SELECT COUNT(1)
1938: INTO l_count
1939: FROM mtl_lot_numbers
1940: WHERE inventory_item_id = l_item_id
1941: AND organization_id = l_org_id
1942: AND lot_number = p_lot_number;
1943:

Line 1952: FROM mtl_lot_numbers

1948: fnd_msg_pub.add;
1949:
1950: SELECT expiration_date
1951: INTO l_expiration_date
1952: FROM mtl_lot_numbers
1953: WHERE inventory_item_id = l_item_id
1954: AND organization_id = l_org_id
1955: AND lot_number = p_lot_number;
1956: