APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_SYSTEM_ITEMS

Line 463: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;

459: l_attribute14 mtl_lot_numbers.attribute14%type := p_attribute14;
460: l_attribute15 mtl_lot_numbers.attribute15%type := p_attribute15;
461: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
462: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;
463: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
464: l_api_version CONSTANT NUMBER := 1.0;
465: l_api_name CONSTANT VARCHAR2(30) := 'insert_mtli';
466: l_progress NUMBER; --Progress Indicator
467: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);

Line 1941: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;

1937: l_lot_uniqueness NUMBER;
1938: no_shelf_life_control CONSTANT NUMBER := 1;
1939: item_shelf_life_days CONSTANT NUMBER := 2;
1940: user_defined_exp_date CONSTANT NUMBER := 4;
1941: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
1942: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
1943: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
1944: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1945: BEGIN

Line 1942: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;

1938: no_shelf_life_control CONSTANT NUMBER := 1;
1939: item_shelf_life_days CONSTANT NUMBER := 2;
1940: user_defined_exp_date CONSTANT NUMBER := 4;
1941: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
1942: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
1943: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
1944: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1945: BEGIN
1946: x_return_status := g_ret_sts_success;

Line 2053: FROM mtl_system_items

2049: SELECT shelf_life_days
2050: , shelf_life_code
2051: INTO l_shelf_life_days
2052: , l_shelf_life_code
2053: FROM mtl_system_items
2054: WHERE inventory_item_id = p_inventory_item_id
2055: AND organization_id = p_org_id;
2056: EXCEPTION
2057: WHEN NO_DATA_FOUND THEN

Line 3311: , mtl_system_items_kfv msi

3307: SELECT DISTINCT rt.transfer_lpn_id
3308: , rt.organization_id
3309: FROM rcv_transactions rt
3310: , mtl_parameters mp
3311: , mtl_system_items_kfv msi
3312: , rcv_supply rs
3313: WHERE mp.wms_enabled_flag = 'Y'
3314: AND mp.organization_id = rt.organization_id
3315: AND rt.transaction_type IN ('RECEIVE','ACCEPT','REJECT')