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 1629: INSERT INTO mtl_lot_numbers

1625:
1626: -- Lot number does not exist
1627: select mtl_gen_object_id_s.nextval into l_object_id from dual;
1628:
1629: INSERT INTO mtl_lot_numbers
1630: (INVENTORY_ITEM_ID
1631: ,ORGANIZATION_ID
1632: ,LOT_NUMBER
1633: ,LAST_UPDATE_DATE

Line 1888: FROM MTL_LOT_NUMBERS

1884:
1885: IF l_lotunique = 1 then
1886: SELECT count(1)
1887: INTO l_count
1888: FROM MTL_LOT_NUMBERS
1889: WHERE inventory_item_id <> l_item_id
1890: AND lot_number = p_lot_number
1891: AND NOT EXISTS( SELECT NULL
1892: FROM mtl_lot_numbers lot

Line 1892: FROM mtl_lot_numbers lot

1888: FROM MTL_LOT_NUMBERS
1889: WHERE inventory_item_id <> l_item_id
1890: AND lot_number = p_lot_number
1891: AND NOT EXISTS( SELECT NULL
1892: FROM mtl_lot_numbers lot
1893: WHERE lot.lot_number = p_lot_number
1894: AND lot.organization_id = l_org_id
1895: AND lot.inventory_item_id = l_item_id);
1896:

Line 1909: FROM mtl_lot_numbers

1905:
1906:
1907: SELECT COUNT(1)
1908: INTO l_count
1909: FROM mtl_lot_numbers
1910: WHERE inventory_item_id = l_item_id
1911: AND organization_id = l_org_id
1912: AND lot_number = p_lot_number;
1913:

Line 1922: FROM mtl_lot_numbers

1918: fnd_msg_pub.add;
1919:
1920: SELECT expiration_date
1921: INTO l_expiration_date
1922: FROM mtl_lot_numbers
1923: WHERE inventory_item_id = l_item_id
1924: AND organization_id = l_org_id
1925: AND lot_number = p_lot_number;
1926: