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_ASN_LOT_ATT dependencies on MTL_SYSTEM_ITEMS

Line 526: FROM MTL_SYSTEM_ITEMS

522: -- Check for Lot UniqueNess
523: BEGIN
524: SELECT LOT_CONTROL_CODE
525: INTO l_lot_control_code
526: FROM MTL_SYSTEM_ITEMS
527: WHERE INVENTORY_ITEM_ID = l_inventory_item_id
528: AND ORGANIZATION_ID = l_organization_id;
529:
530: if(l_lot_control_code = 1) then

Line 592: FROM MTL_SYSTEM_ITEMS

588: SELECT SHELF_LIFE_CODE,
589: SHELF_LIFE_DAYS
590: INTO l_shelf_life_code,
591: l_shelf_life_days
592: FROM MTL_SYSTEM_ITEMS
593: WHERE INVENTORY_ITEM_ID = l_inventory_item_id
594: AND ORGANIZATION_ID = l_organization_id;
595:
596: if(l_shelf_life_code = 2) then

Line 1467: FROM MTL_SYSTEM_ITEMS

1463:
1464: BEGIN
1465: SELECT serial_number_control_code
1466: INTO l_serial_control_code
1467: FROM MTL_SYSTEM_ITEMS
1468: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1469: AND ORGANIZATION_ID = p_organization_id;
1470:
1471: if(l_serial_control_code = 1) then