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 88: l_lot_status_enabled mtl_system_items.lot_status_enabled%TYPE; /* Bug8647949 */

84: )
85: IS
86: l_old_status_id NUMBER;
87: l_ret_status BOOLEAN;
88: l_lot_status_enabled mtl_system_items.lot_status_enabled%TYPE; /* Bug8647949 */
89: BEGIN
90:
91: print_debug('Entered validate_lot_status ', 9);
92: print_debug('validate_lot_status: Organization Id: '||p_organization_id, 9);

Line 101: from mtl_system_items

97: /* Bug8647949 - Fetching lot_status_enabled code of Item and Calling validate_lot_status
98: only when lot_status_enabled is 'Y' */
99: Select nvl(lot_status_enabled,'N')
100: into l_lot_status_enabled
101: from mtl_system_items
102: where organization_id= p_organization_id
103: and inventory_item_id= p_inventory_item_id;
104:
105: IF(l_lot_status_enabled= 'Y' and (p_status_id <> g_miss_num or p_status_id is not null)) then

Line 480: FROM mtl_system_items

476: ELSE
477: BEGIN
478: SELECT lot_control_code
479: INTO l_lot_control_code
480: FROM mtl_system_items
481: WHERE inventory_item_id = p_inventory_item_id
482: AND organization_id = p_organization_id;
483:
484: IF ( l_lot_control_code = 1 )

Line 510: FROM mtl_system_items

506: WHERE organization_id = p_organization_id;
507:
508: SELECT lot_status_enabled --Added select for bug4066234
509: INTO l_dest_status_enabled
510: FROM mtl_system_items
511: WHERE
512: inventory_item_id=p_inventory_item_id and
513: organization_id=p_organization_id;
514:

Line 556: FROM mtl_system_items

552: SELECT shelf_life_code,
553: shelf_life_days
554: INTO l_shelf_life_code,
555: l_shelf_life_days
556: FROM mtl_system_items
557: WHERE inventory_item_id = p_inventory_item_id
558: AND organization_id = p_organization_id;
559:
560: IF ( l_shelf_life_code = 2 ) THEN

Line 2583: UPDATE mtl_system_items_b

2579: ELSE /* not (l_got_lock) */
2580: print_debug('Got lock on lot items ', 9);
2581: /* end of changes for bug 8428348 */
2582: if( p_lot_generation = 2 AND p_lot_uniqueness = 1 ) THEN
2583: UPDATE mtl_system_items_b
2584: SET start_auto_lot_number = p_new_suffix
2585: -- Bug# 7298723
2586: -- WHERE organization_id = p_org_id
2587: WHERE auto_lot_alpha_prefix = p_lot_prefix

Line 2594: UPDATE mtl_system_items

2590: --AND inventory_item_id = p_inventory_item_id;
2591: l_update_count := SQL%ROWCOUNT; -- Bug# 7298723
2592:
2593: elsif( p_lot_generation = 2 and p_lot_uniqueness <> 1 ) THEN
2594: UPDATE mtl_system_items
2595: SET start_auto_lot_number = p_new_suffix
2596: WHERE organization_id = p_org_id
2597: AND inventory_item_id = p_inventory_item_id;
2598:

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

2799: ======================================*/
2800: CURSOR get_item_data IS
2801: SELECT child_lot_flag, parent_child_generation_flag,
2802: child_lot_prefix, child_lot_starting_number
2803: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
2804: WHERE organization_id = p_org_id
2805: AND inventory_item_id = p_inventory_item_id;
2806:
2807: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;

Line 2807: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;

2803: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
2804: WHERE organization_id = p_org_id
2805: AND inventory_item_id = p_inventory_item_id;
2806:
2807: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
2808: x_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2809: x_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
2810: x_child_lot_starting_number MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
2811:

Line 2808: x_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;

2804: WHERE organization_id = p_org_id
2805: AND inventory_item_id = p_inventory_item_id;
2806:
2807: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
2808: x_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2809: x_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
2810: x_child_lot_starting_number MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
2811:
2812:

Line 2809: x_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;

2805: AND inventory_item_id = p_inventory_item_id;
2806:
2807: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
2808: x_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2809: x_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
2810: x_child_lot_starting_number MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
2811:
2812:
2813: /*====================================

Line 2810: x_child_lot_starting_number MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;

2806:
2807: x_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
2808: x_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
2809: x_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
2810: x_child_lot_starting_number MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
2811:
2812:
2813: /*====================================
2814: OPM Convergence

Line 3368: FROM mtl_system_items

3364: END IF;
3365:
3366: SELECT lot_control_code
3367: INTO l_lot_control_code
3368: FROM mtl_system_items
3369: WHERE organization_id = p_org_id
3370: AND inventory_item_id = p_inventory_item_id;
3371:
3372: IF ( l_lot_control_code = 1 ) THEN

Line 3390: FROM mtl_system_items

3386: SELECT auto_lot_alpha_prefix,
3387: start_auto_lot_number
3388: INTO l_lot_prefix,
3389: l_lot_suffix
3390: FROM mtl_system_items
3391: WHERE organization_id = p_org_id
3392: AND inventory_item_id = p_inventory_item_id;
3393: IF (l_debug = 1) THEN
3394: print_debug('lot prefix and start number is ' || l_lot_prefix || ' & ' ||l_lot_suffix,9);

Line 3460: FROM MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM

3456:
3457: -- Following query added as a part of the bug fix for Bug # 3330855
3458: SELECT ORGANIZATION_CODE, CONCATENATED_SEGMENTS
3459: INTO v_org_code, v_item_name
3460: FROM MTL_PARAMETERS ORG, MTL_SYSTEM_ITEMS_KFV ITEM
3461: WHERE ORG.ORGANIZATION_ID = p_org_id
3462: AND INVENTORY_ITEM_ID = p_inventory_item_id
3463: AND ITEM.ORGANIZATION_ID = p_org_id;
3464:

Line 4420: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;

4416: , p_supplier_lot_number IN VARCHAR2
4417: , p_vendor_name IN VARCHAR2
4418: ) IS
4419: /*Program variables declaration */
4420: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
4421: l_chk_lot_uniqueness BOOLEAN;
4422: l_wms_installed VARCHAR2(5);
4423: l_lot_number_uniqueness NUMBER;
4424: l_return_status VARCHAR2(1);

Line 4435: FROM mtl_system_items

4431:
4432: BEGIN
4433: SELECT lot_control_code
4434: INTO l_lot_control_code
4435: FROM mtl_system_items
4436: WHERE inventory_item_id = p_inventory_item_id
4437: AND organization_id = p_organization_id;
4438:
4439: /* If not lot controlled , then error out */

Line 4792: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;

4788: /* Shelf life code constants */
4789: no_shelf_life_control CONSTANT NUMBER := 1;
4790: item_shelf_life_days CONSTANT NUMBER := 2;
4791: user_defined_exp_date CONSTANT NUMBER := 4;
4792: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
4793: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
4794: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
4795: l_global_nsegments NUMBER := 0;
4796: l_lot_grade VARCHAR2(150); /*bug 13780398 Bug 13987577 changed the data type to incoporate more than 2 bytes*/

Line 4793: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;

4789: no_shelf_life_control CONSTANT NUMBER := 1;
4790: item_shelf_life_days CONSTANT NUMBER := 2;
4791: user_defined_exp_date CONSTANT NUMBER := 4;
4792: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
4793: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
4794: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
4795: l_global_nsegments NUMBER := 0;
4796: l_lot_grade VARCHAR2(150); /*bug 13780398 Bug 13987577 changed the data type to incoporate more than 2 bytes*/
4797: l_grade_enabled VARCHAR2(1); --bug 13780398

Line 4867: FROM mtl_system_items

4863: SELECT shelf_life_days
4864: , shelf_life_code
4865: INTO l_shelf_life_days
4866: , l_shelf_life_code
4867: FROM mtl_system_items
4868: WHERE inventory_item_id = p_lot_rec.inventory_item_id
4869: AND organization_id = p_lot_rec.organization_id;
4870: EXCEPTION
4871: WHEN NO_DATA_FOUND THEN

Line 6905: from mtl_system_items

6901: and lot_number=p_lot_rec.lot_number;
6902:
6903: Select nvl(GRADE_CONTROL_FLAG,'N')
6904: into l_grade_enabled
6905: from mtl_system_items
6906: where organization_id= p_lot_rec.organization_id
6907: and inventory_item_id= p_lot_rec.inventory_item_id;
6908:
6909:

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

8210: CURSOR get_item_data IS
8211: SELECT child_lot_flag, parent_child_generation_flag,
8212: child_lot_prefix, child_lot_validation_flag,
8213: child_lot_starting_number
8214: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
8215: WHERE organization_id = p_organization_id
8216: AND inventory_item_id = p_inventory_item_id;
8217:
8218: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;

Line 8218: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;

8214: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
8215: WHERE organization_id = p_organization_id
8216: AND inventory_item_id = p_inventory_item_id;
8217:
8218: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
8219: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
8220: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
8221: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;
8222: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;

Line 8219: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;

8215: WHERE organization_id = p_organization_id
8216: AND inventory_item_id = p_inventory_item_id;
8217:
8218: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
8219: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
8220: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
8221: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;
8222: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
8223: L_ITEM_LOT_LENGTH CONSTANT NUMBER := 80;

Line 8220: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;

8216: AND inventory_item_id = p_inventory_item_id;
8217:
8218: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
8219: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
8220: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
8221: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;
8222: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
8223: L_ITEM_LOT_LENGTH CONSTANT NUMBER := 80;
8224:

Line 8221: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;

8217:
8218: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
8219: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
8220: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
8221: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;
8222: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
8223: L_ITEM_LOT_LENGTH CONSTANT NUMBER := 80;
8224:
8225:

Line 8222: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;

8218: l_item_child_lot_flag MTL_SYSTEM_ITEMS.CHILD_LOT_FLAG%TYPE;
8219: l_item_parent_child_gen_flag MTL_SYSTEM_ITEMS.PARENT_CHILD_GENERATION_FLAG%TYPE;
8220: l_item_child_lot_prefix MTL_SYSTEM_ITEMS.CHILD_LOT_PREFIX%TYPE;
8221: l_item_child_lot_validation MTL_SYSTEM_ITEMS.CHILD_LOT_VALIDATION_FLAG%TYPE;
8222: l_item_child_lot_startno MTL_SYSTEM_ITEMS.CHILD_LOT_STARTING_NUMBER%TYPE;
8223: L_ITEM_LOT_LENGTH CONSTANT NUMBER := 80;
8224:
8225:
8226: /*====================================

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

8699: , item_id IN NUMBER) IS
8700: SELECT NVL( lot_divisible_flag, 'Y')
8701: ,lot_control_code
8702: ,tracking_quantity_ind
8703: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
8704: WHERE organization_id = org_id
8705: AND inventory_item_id = item_id;
8706:
8707: l_tracking_quantity_ind VARCHAR2(5);

Line 8872: FROM mtl_system_items

8868: IF (p_transaction_type_id = 36 AND p_revision IS NOT NULL) THEN
8869:
8870: SELECT Nvl(revision_qty_control_code,1)
8871: INTO l_revision_qty_control_code
8872: FROM mtl_system_items
8873: WHERE inventory_item_id = p_inventory_item_id
8874: AND organization_id = p_organization_id;
8875:
8876: print_debug('In going into RTV get item revision revision_qty_control_code: '

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

9644: child_lot_flag,
9645: copy_lot_attribute_flag,
9646: shelf_life_code,
9647: grade_control_flag
9648: FROM mtl_system_items_b -- NSRIVAST, Changed the name to MTL_SYSTEM_ITEMS_B as per review comments by Shelly
9649: WHERE inventory_item_id = cp_inventory_item_id
9650: AND organization_id = cp_organization_id;
9651:
9652: l_chk_msi_attr_rec c_chk_msi_attr%ROWTYPE;

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

9721: RAISE fnd_api.g_exc_error;
9722: END IF ;
9723:
9724:
9725: /* Check item existence in Mtl_system_items Table */
9726: OPEN c_chk_msi_attr(p_lot_rec.inventory_item_id,p_lot_rec.organization_id);
9727: FETCH c_chk_msi_attr INTO l_chk_msi_attr_rec;
9728:
9729: IF c_chk_msi_attr%NOTFOUND THEN

Line 10702: FROM mtl_system_items

10698: , tracking_quantity_ind
10699: , secondary_default_ind
10700: , secondary_uom_code
10701: , primary_uom_code
10702: FROM mtl_system_items
10703: WHERE organization_id = org_id
10704: AND inventory_item_id = item_id;
10705:
10706: BEGIN