DBA Data[Home] [Help]

APPS.ENG_IMPL_ITEM_CHANGES_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 457: FROM MTL_SYSTEM_ITEMS_KFV item

453: CURSOR c_item_info (c_inventory_item_id NUMBER ,
454: c_organization_id NUMBER )
455: IS
456: SELECT item.concatenated_segments item_name
457: FROM MTL_SYSTEM_ITEMS_KFV item
458: WHERE item.organization_id = c_organization_id
459: AND item.inventory_item_id = c_inventory_item_id ;
460:
461:

Line 462: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

458: WHERE item.organization_id = c_organization_id
459: AND item.inventory_item_id = c_inventory_item_id ;
460:
461:
462: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
463:
464:
465: BEGIN
466:

Line 1586: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

1582: l_current_column_index NUMBER;
1583:
1584: l_inventory_item_id NUMBER ;
1585: l_organization_id NUMBER ;
1586: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1587: l_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;
1588: l_out_inventory_item_id NUMBER ;
1589: l_out_organization_id NUMBER ;
1590: l_process_control VARCHAR2(30) ;

Line 1587: l_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;

1583:
1584: l_inventory_item_id NUMBER ;
1585: l_organization_id NUMBER ;
1586: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1587: l_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;
1588: l_out_inventory_item_id NUMBER ;
1589: l_out_organization_id NUMBER ;
1590: l_process_control VARCHAR2(30) ;
1591: l_process_item NUMBER ;