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.AHL_PRD_SERN_CHANGE_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 464: MTL_SYSTEM_ITEMS_KFV

460: IS
461: SELECT
462: inventory_item_id
463: FROM
464: MTL_SYSTEM_ITEMS_KFV
465: WHERE
466: CONCATENATED_SEGMENTS = c_item_number;
467:
468: -- Balaji added cursor for checking if destination item is valid.- Begin

Line 474: MTL_SYSTEM_ITEMS_KFV

470: IS
471: SELECT
472: inventory_item_id
473: FROM
474: MTL_SYSTEM_ITEMS_KFV
475: WHERE
476: CONCATENATED_SEGMENTS = c_item_number
477: AND organization_id = c_organization_id
478: AND SERIAL_NUMBER_CONTROL_CODE in (2,5,6);

Line 496: MTL_SYSTEM_ITEMS_KFV MTL

492: AHL_PRD_SERN_CHANGE_PVT.GET_SERIALTAG_CODE (CSI.INSTANCE_ID) OLD_SER_TAG_CODE,
493: CSI.INVENTORY_REVISION OLD_INV_REV,
494: CSI.LOT_NUMBER OLD_LOT_NUM
495: FROM CSI_ITEM_INSTANCES CSI,
496: MTL_SYSTEM_ITEMS_KFV MTL
497: WHERE CSI.INVENTORY_ITEM_ID = MTL.INVENTORY_ITEM_ID
498: AND CSI.LAST_VLD_ORGANIZATION_ID = MTL.ORGANIZATION_ID
499: AND CSI.INSTANCE_ID = C_INSTANCE_ID;
500: