DBA Data[Home] [Help]

APPS.ENG_IMPL_ITEM_CHANGES_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 456: FROM MTL_SYSTEM_ITEMS_KFV item

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

Line 461: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

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

Line 1577: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

1573: l_current_column_index NUMBER;
1574:
1575: l_inventory_item_id NUMBER ;
1576: l_organization_id NUMBER ;
1577: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1578: l_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;
1579: l_out_inventory_item_id NUMBER ;
1580: l_out_organization_id NUMBER ;
1581: l_process_control VARCHAR2(30) ;

Line 1578: l_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;

1574:
1575: l_inventory_item_id NUMBER ;
1576: l_organization_id NUMBER ;
1577: l_item_number MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
1578: l_item_desc MTL_SYSTEM_ITEMS_KFV.DESCRIPTION%TYPE;
1579: l_out_inventory_item_id NUMBER ;
1580: l_out_organization_id NUMBER ;
1581: l_process_control VARCHAR2(30) ;
1582: l_process_item NUMBER ;