DBA Data[Home] [Help]

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);