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.WSM_SERIAL_SUPPORT_PVT dependencies on MTL_SYSTEM_ITEMS

Line 714: -- Query up the MTL_SYSTEM_ITEMS_B to get the serial control code for the item passed..

710: x_return_status := G_RET_SUCCESS;
711: x_error_msg := NULL;
712: x_error_count := 0;
713:
714: -- Query up the MTL_SYSTEM_ITEMS_B to get the serial control code for the item passed..
715: -- IF g_serial_ctl_code.exists(p_serial_item_id) THEN
716: IF g_serial_ctl_code.exists(p_serial_item_id || '_' || p_organization_id) THEN
717: l_stmt_num := 20;
718: x_serial_ctrl_code := g_serial_ctl_code(p_serial_item_id || '_' || p_organization_id);

Line 725: FROM MTL_SYSTEM_ITEMS MSI

721:
722: BEGIN
723: SELECT nvl(SERIAL_NUMBER_CONTROL_CODE,1)
724: INTO x_serial_ctrl_code
725: FROM MTL_SYSTEM_ITEMS MSI
726: WHERE MSI.inventory_item_id = p_serial_item_id
727: AND MSI.organization_id = p_organization_id;
728:
729: EXCEPTION

Line 7527: FROM MTL_SYSTEM_ITEMS

7523: l_stmt_num := 20;
7524:
7525: SELECT NVL(SERIAL_NUMBER_CONTROL_CODE,1)
7526: INTO l_serial_cntrl_code
7527: FROM MTL_SYSTEM_ITEMS
7528: WHERE inventory_item_id = p_primary_item_id
7529: AND organization_id = p_organization_id;
7530:
7531: IF l_serial_cntrl_code <> 2 THEN