APPS.INV_LOT_API_PUB dependencies on MTL_SYSTEM_ITEMS_B

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 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 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 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 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 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;