eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_API_PUB dependencies on MTL_SYSTEM_ITEMS

Line 369: FROM mtl_system_items

365: ELSE
366: BEGIN
367: SELECT lot_control_code
368: INTO l_lot_control_code
369: FROM mtl_system_items
370: WHERE inventory_item_id = p_inventory_item_id
371: AND organization_id = p_organization_id;
372:
373: IF ( l_lot_control_code = 1 )

Line 399: FROM mtl_system_items

395: WHERE organization_id = p_organization_id;
396:
397: SELECT lot_status_enabled --Added select for bug4066234
398: INTO l_dest_status_enabled
399: FROM mtl_system_items
400: WHERE
401: inventory_item_id=p_inventory_item_id and
402: organization_id=p_organization_id;
403:

Line 445: FROM mtl_system_items

441: SELECT shelf_life_code,
442: shelf_life_days
443: INTO l_shelf_life_code,
444: l_shelf_life_days
445: FROM mtl_system_items
446: WHERE inventory_item_id = p_inventory_item_id
447: AND organization_id = p_organization_id;
448:
449: IF ( l_shelf_life_code = 2 ) THEN

Line 2442: UPDATE mtl_system_items_b

2438: print_debug('before updating msi '||p_lot_prefix,9);
2439: END IF;
2440:
2441: if( p_lot_generation = 2 AND p_lot_uniqueness = 1 ) THEN
2442: UPDATE mtl_system_items_b
2443: SET start_auto_lot_number = p_new_suffix
2444: -- Bug# 7298723
2445: -- WHERE organization_id = p_org_id
2446: WHERE auto_lot_alpha_prefix = p_lot_prefix

Line 2453: UPDATE mtl_system_items

2449: --AND inventory_item_id = p_inventory_item_id;
2450: l_update_count := SQL%ROWCOUNT; -- Bug# 7298723
2451:
2452: elsif( p_lot_generation = 2 and p_lot_uniqueness <> 1 ) THEN
2453: UPDATE mtl_system_items
2454: SET start_auto_lot_number = p_new_suffix
2455: WHERE organization_id = p_org_id
2456: AND inventory_item_id = p_inventory_item_id;
2457:

Line 2656: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly

2652: ======================================*/
2653: CURSOR get_item_data IS
2654: SELECT child_lot_flag, parent_child_generation_flag,
2655: child_lot_prefix, child_lot_starting_number
2656: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
2657: WHERE organization_id = p_org_id
2658: AND inventory_item_id = p_inventory_item_id;
2659:
2660: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;

Line 2660: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;

2656: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
2657: WHERE organization_id = p_org_id
2658: AND inventory_item_id = p_inventory_item_id;
2659:
2660: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
2661: x_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2662: x_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
2663: x_child_lot_starting_number MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
2664:

Line 2661: x_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;

2657: WHERE organization_id = p_org_id
2658: AND inventory_item_id = p_inventory_item_id;
2659:
2660: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
2661: x_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2662: x_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
2663: x_child_lot_starting_number MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
2664:
2665:

Line 2662: x_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;

2658: AND inventory_item_id = p_inventory_item_id;
2659:
2660: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
2661: x_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2662: x_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
2663: x_child_lot_starting_number MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
2664:
2665:
2666: /*====================================

Line 2663: x_child_lot_starting_number MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;

2659:
2660: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
2661: x_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2662: x_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
2663: x_child_lot_starting_number MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
2664:
2665:
2666: /*====================================
2667: OPM Convergence

Line 3209: FROM mtl_system_items

3205: END IF;
3206:
3207: SELECT lot_control_code
3208: INTO l_lot_control_code
3209: FROM mtl_system_items
3210: WHERE organization_id = p_org_id
3211: AND inventory_item_id = p_inventory_item_id;
3212:
3213: IF ( l_lot_control_code = 1 ) THEN

Line 3231: FROM mtl_system_items

3227: SELECT auto_lot_alpha_prefix,
3228: start_auto_lot_number
3229: INTO l_lot_prefix,
3230: l_lot_suffix
3231: FROM mtl_system_items
3232: WHERE organization_id = p_org_id
3233: AND inventory_item_id = p_inventory_item_id;
3234: IF (l_debug = 1) THEN
3235: print_debug('lot prefix and start number is ' || l_lot_prefix || ' & ' ||l_lot_suffix,9);

Line 3301: FROM MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM

3297:
3298: -- Following query added as a part of the bug fix for Bug # 3330855
3299: SELECT ORGANIZATION_CODE, CONCATENATED_SEGMENTS
3300: INTO v_org_code, v_item_name
3301: FROM MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM
3302: WHERE ORG.ORGANIZATION_ID = p_org_id
3303: AND INVENTORY_ITEM_ID = p_inventory_item_id
3304: AND ITEM.ORGANIZATION_ID = p_org_id;
3305:

Line 4261: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;

4257: , p_supplier_lot_number IN VARCHAR2
4258: , p_vendor_name IN VARCHAR2
4259: ) IS
4260: /*Program variables declaration */
4261: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
4262: l_chk_lot_uniqueness BOOLEAN;
4263: l_wms_installed VARCHAR2(5);
4264: l_lot_number_uniqueness NUMBER;
4265: l_return_status VARCHAR2(1);

Line 4276: FROM mtl_system_items

4272:
4273: BEGIN
4274: SELECT lot_control_code
4275: INTO l_lot_control_code
4276: FROM mtl_system_items
4277: WHERE inventory_item_id = p_inventory_item_id
4278: AND organization_id = p_organization_id;
4279:
4280: /* If not lot controlled , then error out */

Line 4633: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;

4629: /* Shelf life code constants */
4630: no_shelf_life_control CONSTANT NUMBER := 1;
4631: item_shelf_life_days CONSTANT NUMBER := 2;
4632: user_defined_exp_date CONSTANT NUMBER := 4;
4633: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
4634: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
4635: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
4636: l_global_nsegments NUMBER := 0;
4637: BEGIN

Line 4634: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;

4630: no_shelf_life_control CONSTANT NUMBER := 1;
4631: item_shelf_life_days CONSTANT NUMBER := 2;
4632: user_defined_exp_date CONSTANT NUMBER := 4;
4633: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
4634: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
4635: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
4636: l_global_nsegments NUMBER := 0;
4637: BEGIN
4638: x_return_status := g_ret_sts_success;

Line 4705: FROM mtl_system_items

4701: SELECT shelf_life_days
4702: , shelf_life_code
4703: INTO l_shelf_life_days
4704: , l_shelf_life_code
4705: FROM mtl_system_items
4706: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4707: AND organization_id = p_lot_rec.organization_id;
4708: EXCEPTION
4709: WHEN NO_DATA_FOUND THEN

Line 7861: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly

7857: CURSOR get_item_data IS
7858: SELECT child_lot_flag, parent_child_generation_flag,
7859: child_lot_prefix, child_lot_validation_flag,
7860: child_lot_starting_number
7861: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
7862: WHERE organization_id = p_organization_id
7863: AND inventory_item_id = p_inventory_item_id;
7864:
7865: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;

Line 7865: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;

7861: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
7862: WHERE organization_id = p_organization_id
7863: AND inventory_item_id = p_inventory_item_id;
7864:
7865: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
7866: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
7867: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
7868: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;
7869: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;

Line 7866: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;

7862: WHERE organization_id = p_organization_id
7863: AND inventory_item_id = p_inventory_item_id;
7864:
7865: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
7866: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
7867: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
7868: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;
7869: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
7870: L_ITEM_LOT_LENGTH CONSTANT NUMBER := 80;

Line 7867: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;

7863: AND inventory_item_id = p_inventory_item_id;
7864:
7865: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
7866: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
7867: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
7868: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;
7869: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
7870: L_ITEM_LOT_LENGTH CONSTANT NUMBER := 80;
7871:

Line 7868: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;

7864:
7865: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
7866: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
7867: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
7868: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;
7869: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
7870: L_ITEM_LOT_LENGTH CONSTANT NUMBER := 80;
7871:
7872:

Line 7869: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;

7865: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
7866: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
7867: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
7868: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;
7869: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
7870: L_ITEM_LOT_LENGTH CONSTANT NUMBER := 80;
7871:
7872:
7873: /*====================================

Line 8337: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly

8333: CURSOR get_item_details( org_id IN NUMBER
8334: , item_id IN NUMBER) IS
8335: SELECT NVL( lot_divisible_flag, 'Y')
8336: ,lot_control_code
8337: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
8338: WHERE organization_id = org_id
8339: AND inventory_item_id = item_id;
8340:
8341: /*====================================

Line 9186: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly

9182: child_lot_flag,
9183: copy_lot_attribute_flag,
9184: shelf_life_code,
9185: grade_control_flag
9186: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
9187: WHERE inventory_item_id = cp_inventory_item_id
9188: AND organization_id = cp_organization_id;
9189:
9190: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;

Line 9256: /* Check item existence in Mtl_system_items Table */

9252: RAISE fnd_api.g_exc_error;
9253: END IF ;
9254:
9255:
9256: /* Check item existence in Mtl_system_items Table */
9257: OPEN c_chk_msi_attr(p_lot_rec.inventory_item_id,p_lot_rec.organization_id);
9258: FETCH c_chk_msi_attr INTO l_chk_msi_attr_rec;
9259:
9260: IF c_chk_msi_attr%NOTFOUND THEN

Line 10225: FROM mtl_system_items

10221: , tracking_quantity_ind
10222: , secondary_default_ind
10223: , secondary_uom_code
10224: , primary_uom_code
10225: FROM mtl_system_items
10226: WHERE organization_id = org_id
10227: AND inventory_item_id = item_id;
10228:
10229: BEGIN