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 1957: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;

1953: l_lot_uniqueness NUMBER;
1954: no_shelf_life_control CONSTANT NUMBER := 1;
1955: item_shelf_life_days CONSTANT NUMBER := 2;
1956: user_defined_exp_date CONSTANT NUMBER := 4;
1957: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
1958: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
1959: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
1960: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1961: BEGIN

Line 1958: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;

1954: no_shelf_life_control CONSTANT NUMBER := 1;
1955: item_shelf_life_days CONSTANT NUMBER := 2;
1956: user_defined_exp_date CONSTANT NUMBER := 4;
1957: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
1958: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
1959: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
1960: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1961: BEGIN
1962: x_return_status := g_ret_sts_success;

Line 2069: FROM mtl_system_items

2065: SELECT shelf_life_days
2066: , shelf_life_code
2067: INTO l_shelf_life_days
2068: , l_shelf_life_code
2069: FROM mtl_system_items
2070: WHERE inventory_item_id = p_inventory_item_id
2071: AND organization_id = p_org_id;
2072: EXCEPTION
2073: WHEN NO_DATA_FOUND THEN

Line 3340: , mtl_system_items_kfv msi

3336: SELECT DISTINCT rt.transfer_lpn_id
3337: , rt.organization_id
3338: FROM rcv_transactions rt
3339: , mtl_parameters mp
3340: , mtl_system_items_kfv msi
3341: , rcv_supply rs
3342: WHERE mp.wms_enabled_flag = 'Y'
3343: AND mp.organization_id = rt.organization_id
3344: AND rt.transaction_type IN ('RECEIVE','ACCEPT','REJECT')